We help IT Professionals succeed at work.

Access 2003 - BarCode Scanning

Hockeynut57 asked
Medium Priority
Last Modified: 2012-06-21
Done a fair amount of work in Access and this one is stumping me.  I have a simple database nothing elaborate just a reg table with a form linked to it.  The table has 4 fields and each field is inputed via a barcode scan from a USB scanner.  The first field goes in fine and the cursor goes to the next field.  When i do the second scan it shows the information going into the field but it does not hold it.  The field is empty.  Even if a do a new table and set it up using datasheet view and start scanning data it does the same thing.  The only way i can get it to work is if i double click on the 2nd field before scanning and then it works.  Any ideas would be greatly appreciated.
Watch Question

Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017

<<Any ideas would be greatly appreciated.>>

1. Check the prefix/suffixes the scanner is sending (if any).
2. Check the Access Keyboard options that are set (Tools/Options):

    Move after enter
    Behavior entering field
    Arrow key behavior
    Cursor stops at first / last field.

  Typically, you want a gun to issue a CR (Carriage Return), which will be seen as an enter key to move between controls.  You can also use a tab character.




I checked the items thanks,had already checked the scanner.  Let me make it a little more interesting.  I have 3 fields and just discovered, that the first one scans and accepts no problem, the second one scans sees the data but doesnt save it and the 3rd one scans and saves the data.  It doesnt matter the data i scan either as i have scanned the items that stay in 1 and 3 but they wont stay in 2.  Is there anyway that i can have script to tell teh field to double click itself and that should fix the problem.
President / Owner
Most Valuable Expert 2017
Unlock this solution and get a sample of our free trial.
(No credit card required)


It appears to be the scanner causing the issue somehow, even though i reset it and checked the settings it was still acting up.  I changed the scanner and it worked fine.  Thanks for the help going to accept the above solution as it sorta pointed me back there again.  Thanks everyone for the help
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.