Access and Barcodes

tammyborden32
tammyborden32 used Ask the Experts™
on
Hi All,

I have an Access97 database for inventory tracking.  We print barcode labels for finished inventory from the database.  When the inventory is shipped, personnel scan the barcode into an input box to remove the item from inventory.

 At the outgoing shipments computer, the scanner reads the barcode.  The number in the input box looks correct.  The inventory number is 10 digit number.  The input fields displays the number correctly, but Access says the item is not in the list.  We have verified that the inventory number is in the underlying table.  If I copy and paste the same number from the table into the input box, it finds it.  This happens on every inventory number.  We verified the number is correct.  

On my workstation, using the same label and scanning with the same barcode scanner - the item is found correctly.

Anyone run into this and can point me in the right direction?

Thanks,

Tammy
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Tammy,

 When you say "the same barcode scanner", do you mean your using the scanner from the other station or the same model scanner?

If the first, then I would suspect option settings in Access.  If the second, then I would suspect the scanner is prefixing/suffixing non-visible characters to what's scanned.

Jim.

Author

Commented:
I'm using the scanner from the other station.  What options in Access.  Can you elaborate?

Thanks,

Tammy
What kind of scanner are you using - USB or Serial? If serial or maybe in both cases, the problem may be with the drivers that are installed, not the Access application. You may want to try uninstalling and reinstalling the device drivers associated with the scanner. Try it on a third computer and see if the results are consistent.

I use scanners in a number of databases that I have developed, but never experienced this problem.

Doug
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

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

Commented:
Yes, USB scanners often have a driver that will prefix/suffix characters as well.

<<What options in Access.  Can you elaborate?>>

Keyboard/movement options. i.e. what happens when a return is seen. etc.

Think Doug probably has your answer though.  I've run across that before.

Jim.

Author

Commented:
After additional testing - I found that it was only working intermittently at my workstation.  I think I've corrected the problem.  I recreated the barcode, assigned Code 39 Full ASCII and am now able to read the label correctly each time.  I use a barcode generator product called TbarCode.  

Thanks for the responses.

Author

Commented:
Thanks for the guidance.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial