Access database – Using barcode scanner
We have been using barcodes scanners with custom written MSAccess, VB and Web based applications for a while.
The type of barcode scanner we use just sends the string it reads as a keyboard input (used to be called “wedges” and had to be connected between the ps2 cable of the keyboard and the PC, but USB has done away with the need for this), so all you need in your appilcation is a text field that the information can be read into. You just then need to substitute the string for whatever unique reference you have for that item in your query and job done. Same process for MSAccess, VB and Web based items then. The same theory can be applied to USB swipe card readers – in fact the application has no idea where the input is coming from because it all just looks like a keyboard entry (and can be a keyboard entry if the scanner fails to read / is not present)
We have managed to use this technique with bluetooth connected barcode scanners and ones with wireless connections to base stations without any problems.
More barcode scanning ideas here.
—
Exactly, a barcode scanner is treated as a keyboard, so just design the form as if it were for text input. Anywhere you can type, you can scan a barcode. Just need to look at cursor focus to make the form open with the relevant field having cursor focus.
Creating the barcode graphic. Basically use a field in the data table and add an Active X control to form or report! See