I am trying to add a barcode to a report of mine that I can then scan in order to escape/close that report. The reason for this is my work station will not have a keyboard. The user will simply scan a work order number, this will bring up a report on screen with work order detail. Then to get back to main screen to scan next work order I need to be able to escape/close the current report without using a keyboard.
View RepliesI'm trying to make a database for some product that have barcode, but i don't understand how to scan product barcode then interpret it into data in access,,, and how later I can look for these data by using barcode.
View 4 Replies View RelatedI'm working on a project that uses a barcode scanner. The user will scan a barcode which will choose an item from a combo box. The result of what it enters will populate a text box. I have that part working fine.
The next step is to get it to open a form based on the value in the textbox. The textbox will have about 7 different possible values and each one should open a different form.
The way this is supposed to work:
User approaches a machine and scans the barcode. He is presented with a form giving him options based on the type of equipment the machine is. A compressor for example would present him with a set of options for compressors (gauge readings, maintanence, etc).
I have an unbound form with two controls:
cboAssetNumber
txtType
How to code this and which events to code it in. Users will be going from machine to machine and using the form over and over again so I need to somehow manage the clearing of the form to begin again with another barcode scan.
I saw another thread about a barcode scanner and one response was to program the scanner to send the barcode and then send an "Enter" press to move focus to the next control. I've looked through the documentation and haven't been able to find if that is possible. Right now it sends the number and that's it. It's a "Motion" Tablet.
I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.
So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .
Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?
Im trying to add a barcode to a report which I can scan with a barcode scanner. I have downloaded A code39 TrueType font and created a textbox and have put the following in the Data, Control source
Code:
="*" & [Barcode] & "*"
but when I print out the report its only converting the field barcode to a code 39 barcode and leaving "*" at either side of it. I know its not the font as if I open note pad, select the font and enter *1234* all is converted to a scanable barcode.
I want to be able to put a barcode in a field that when a reader scans the barcode it records the current time. Need it for access control to record who is in and out of the office. Reading other threads I understand it may be possible in Dlookup.
View 3 Replies View RelatedI am wanting to insert a Barcode ActiveX control, but it is not listed. In an instruction video, after clicking on ActiveX Controls, the one named "ABarcode ActiveX" is at the top of the list.=how I can obtain this.
View 2 Replies View RelatedI have a field that displays a date on a form.
I set the conditional formatting to be
Value is Between Date() and Date() + 14
It would only apply the formatting for dates that were equal to the date and +5 days.
I then tried Between Now() and Now() + 14
Same results
I then tried Between Date() and DateAdd("d",14,Date())
No change
I checked the property for the box and the back style is normal.
I am making the back color a light red. I tried to change the fore color red. Nothing.
I displayed what Date() was giving me in a text box control and I displayed what Date() + 14 was giving me in a text box control. They both were showing the correct dates, but my date, which was in between them, was not changing colors.
I am using a form with command buttons on it to set the criteria in my query to run the report.
Example : cmdQ1 'Command Button
PHP Code:
'1st Quarterly Report.
BeginDate = DateSerial(Year(Date), Int((Month(Date) - 1) / 3) * 3 + 1, 1)
EndDate = DateSerial(Year(Date), Int((Month(Date) - 1) / 3) * 3 + 4, 0)Â
I managed to get this far but need to continue on with 2,3, and 4th quarters.
Using Access 97, I have a single-form allow-additions form where a couple of bound fields are auto-populated 'on current' and a couple of other bound fields are left to be populated by the user (me!).
At the end of an input session, I can press ESC and then close the form OK. But if I forget to press ESC and try to close the form, I have an invalid incomplete record on screen.
How do I indicate that the new record isn't wanted? I have tried stuff like
If Me!txtRequiredBoundField = Null then
SendKeys "(ESC)"
End If
to no avail.
Thanks in advance.
Hi All,
I need some help. I want to disable the Escape key when users are entering data on a form. How can I do that?
Help apprecieted
Regards
K
Hi,
I would like to be able to abort a record input using code rather than the esc key on the keyboard.
Is this possible, if so can anyone help with the correct code or method etc.
Sue
How do you guys escape the double quotes in the string..
Code:sRandomNumber = "1234"sCmdLine = "-RandomNumber="" & sRandomNumber & """
I tried this but this doesn't work...
sCmdLine = "-RandomNumber=""" & sRandomNumber & """"
I tried another method which doesn't work either...
sCmdLine = "-RandomNumber=" & chr(34) & sRandomNumber & chr(34).
What I got instead is this..
--snip--
-RandomNumber=""1234""
--snip--
Thanks...
I am trying to run a query where one field has a Not Equal parameter AND another field has Not Equal parameter (for example, Product Code Not Equal "A" AND Client State Not Equal "NY)
The result of the above query are all records that have Product Code = "A" are missing from the result. I want some of the "A" Product Codes; I just want to exclude the ones where the Client state is NY.
The list of values for each field is too big to state it in a positive way (I would have to list all the other 28 product codes and all the other 49 states).
What am I doing wrong? Thank you in advance for any suggestions.
By utilizing the search feature, I have discovered issues that are somewhat relative to what I need assistance with, however nothing specific. So here we go…
1.I have a table named tblManifest. Within this table is a text field named PRODUCT and a text field named ACTION (which is a YES or NO option). There are multiple records (duplicates are acceptable) stored within this table/field
2.I have a form named frmReceipts. Within this form is a text box named PRODUCT.
Here is my issue. Within frmReceipts & text box PRODUCT, the user will utilize a handeld scanner to scan a product id barcode. After the scan, I want the record to be added to a table named tblReceipts. This is I have.
My problem is with product identity and specialized treatment of specific product id’s. What I need is when the user scans the product id and that particular product id is flagged as YES within the ACTION field in tblManifest, I would like for a separate wav file to be played and a comment box to flash on the screen. This will alert the user that the product requires specialized treatment. The wav is located in C:My DocumentsTest.wav. If product is flagged as NO, then no wav should be played and no comment is displayed.
I would imagine that this is possible, however beyond my basic Access skills. Thanks in advance for any assistance.
Is there anyway to scan documents and save them in an Access table? As of now we scan them and save them to a folder on the network. Then go into Access form to add them into the tables. Would like to automate this process all from Access but have know idea how to go about this. Any suggestions?
View 4 Replies View RelatedWe are wanting to have our entry form open; click a button that scans a document; to a pdf file; then attaches a hyperlink to that pdf to that record.
If that record was ever retrieved; we could simply double-click the hyperlink to access the pdf file.
Is this possible? Could you give us some recommendations?
Thanks in advance.
I have a table with these 2 fields: Name and AnniversaryDate. What is the best way to write a query that will show me all the anniversaries that will fall within the next two weeks?
For instance if I have a record with these values:
Name, Anniversary
BukHix, 1/1/2003
I want the query to look at today’s date, which in this case would be 12/29/2005 go two weeks forward, which would make it 1/12/2006 and show any anniversary date that would fall between the dates.
The catch (and the part that is throwing me off) is how do I do that without explicitly naming the year? I mean I need to catch every date in that range from 1965 to Current year - 1.
Any ideas?
Where do I put code to run over an entire continuus form. I have a yes/no on each record and it is controlled by an if statement. If I click on every single record it will run the code. I need it to check all the records in the subform. I have tried OnLoad, OnOpen, OnCurrent, OnTimer. None have worked. Any help???
View 1 Replies View RelatedIs it possible to put a command button on a report? I can't do any kind of programming so only use the command button wizards.
I'd like to have a button to click on in order to print or close the report, rather than use the menu bar.
Is this possible, easily?
Thanks very much.
I have hp scanner whose twain driver has the option to scanning in the pdf document.
Microsoft WIA 2.0 have save scanned document only to graphical format.
I want automated (on click any button control) to scan multipage document from glass source or ADF to pdf document and attach it to attachment field.
I'm found VB Module for accessing TWAIN compatible scanner but it is call twain software and scan to bmp format with assigned name of file.
Me need it also only use the pdf format .
[forms]![shop touch screen].txtfilter = [reports]!report titles].singer
I have this command which copies the contents of a field in a report to a field in a form which is acting as a filter and to requery. (from within the report)how to apply the call command from within my report
Call txtfilter_change
When I try: call [forms]![shop touch screen].txtfilter_change I get errors
I want to create a button on my form that when pressed will scan my multi page document (ADF) from my Epson WF-3540 and save it as a specified file name and folder.
View 5 Replies View RelatedI have a form with several command buttons to run reports. When I open the form I used the docmd.maximize and when I use the button to run the report it runs but when I close the report it returns to the form which is now sized not maximized. I want to have the form as it was before I opened the report.
View 2 Replies View RelatedI have a typical Access 2007 database with a main form that has combo boxes that are populated by other tables. To edit or add to the combo boxes I have separate forms. When I make the changes I want the combo boxes to be refreshed. I would imagine I can do it with a FormName.Refresh command. However, I am curious if there is a command to refresh all forms and reports in case I have more than one form open with combo boxes that link to the changed data.
View 11 Replies View RelatedWhat I want to be able to do is have a button next to every client entry which the user can click. Once the button is clicked, I want the "person name" box in the report to be formatted to have a yellow background.The purpose of doing this is so after a couple of days when we come back to the report, we can easily see by the yellow background which people we have to follow up with.
I don't think conditional formatting will work because I have so many different "person names" in the report that it would go above the 3 rule limit, only solution in VBA.The button I created is called "Format", and this is the VBA code I have tried:
Private Sub Format_Click ()
Me.Person_Name.BackColor = vbYellow
End Sub