I have a form with a field to input a bar code.
It works great on the table, but I can not get the form to move to the next record without using the mouse.
I have tried using macros, and I do not know visual basic.
Any help appreciated?
I have a form with a field to input a bar code.
It works great on the table, but I can not get the form to move to the next record without using the mouse.
I have tried using macros, and I do not know visual basic.
Any help appreciated?
I am not remembering what I have done in the past. In some circumstances, I do not believe I did anything special. Maybe you can use the On Change event to move to the next control in the tab order.
Pressing Enter key in the last control (the bar code box?) does not cycle the records?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I can make it go to the next record manually., but I am setting this up for others to use. They want to quickly use the bar code reader to read lots of records. I want it to move on its own.
It will work on the table, which would be fine if I were the only one using the program.
I tried the on change event, and it did not work.
Actually THe on change does move to new record, but it divides the barcode into several different records, adding one number to each record.
I do not know what this means. The only other advice I can offer would be to look at the settings of the barcode scanner. The better scanners will have all sorts of options of what to do with the data. You could look for a way to simulate the enter key there. Normally, this would be default.
You are using a scanner? Can the scanner be set to send an Enter code with input?
How does the focus automatically move to next record in table?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
THe scanner I am using has no directions. I was wondering about it as well. It works if I am on Excel or using just the table on Access.
But it does not work if I make a form for the table.
I still don't understand how it would automatically move to next or new record row in table (or Excel).
Search web for info on your scanner?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I guess it does have something to do with the scanner. I did not do anything to make it automatically move in Excel or tables. It just does. I borrowed a nice scanner before I started this project. It worked in Excel. I just assumed they all worked the same way.
You say you tried macros - which ones?
Did you try the textbox AfterUpdate event?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I tried just about every one. They did different things. Some did nothing. Others would take my code and split it to different records. For example, a code of 123. A "1" will go into the new record, then the "2" would go to a new record. Then the "3" would go into another new record.
I would not have expected that to happen with OnChange event from scanner input - typed input yes.
AfterUpdate is the only relevant event I can think of.
Back to scanner settings. You need to know your device.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Onchange does the same thing if I just try to type 123 into the field. As soon as I hit the one, it will go to the next record.