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?