Barcode Scanners In Access
Posted on 2015-01-25
A user has requested using a barcode scanner in an Access 2003 app that we developed for them several/many years ago. About 10 years ago I developed a VB app that used a bar code scanner to read the tag on inventory items. It was a pretty simple set up, the scanner just populated the 'Serial Number' field on the entry screen. No actions were initiated other than that. That's my total experience with BC scanners.
Now, I am being asked questions like 'What font should the barcode be in?' and "What scanner should we order?" and I have no idea.
Anyone have experience using scanners with an Access app? What bar code font should be used, what barcode scanner equipment to use and how does the equipment interface with the Access app?
From what I have gathered there are keyboard wedge scanner or USB scanners. How do the two differ in functionality? Where does the keyboard wedge scanner connect to the hardware?