3/30/2008 3:20:17 PM
Access with Barcodes
By Richard Rost
Q: How do you use Microsoft Access with a Barcode reader to do inventory?
A: This is a question I actually get asked pretty frequently. Using barcodes with Access is not hard. What you need to do is find yourself a barcode scanner that simply inputs the scanned data as if someone were typing the data in at the keyboard. Using barcodes with a scanner is just a matter of designing your database properly, and then just making sure that the keyboard focus (using SetFocus) was always on the right text boxes so your scanner put the text in the right spots.
PRINTING barcodes is easy too. There are TrueType font sets that you can buy (and there are a few public domain ones I've found) that work well. Just install the font, and then use that font in your Access report in place of actual numbers. Print out on your laser printer, and enjoy.
If there is enough demand for all of this, I'll put together a special tutorial on using Barcodes with Access.
Update: I've added "Using Access with a Barcode Scanner" to the WAITING LIST under the "Microsoft Access Seminars" section. If you're interested in seeing how to do this, VOTE for this seminar on the Waiting List. If I get 4 or 5 people who are interested, I'll record the seminar.
Update: If you're looking for a good price on a simple wedge keyboard scanner, I recommend the TK-3488 from RACO Industries. Ask for Tom Adams and tell him that Richard from 599CD sent you.
Keywords: access barcode bar code barcodes