Nifty Access Barcodes
Barcodes
Bar-codes along with a bar-code scanner can be a very useful feature to add to your database.
You can quickly scan in serial numbers from mass deliveries of items / components. Bar codes are also very handy for managing the repair process of an item returned for repair. For example, by recording a repaired item’s serial number, you can retrieve useful information like how many times the item has been returned.
BARCODE’s are very easy to add to your MS Access Database. You can add a barcode font, See “Access All In One” Video 2 (5:41) Below, and wherever the bar-code number appears, it will automatically be replaced with a barcode.
The Barcode scanners themselves plug directly into your USB port, no setup, away you go! They work just like a keyboard. Here’s a Wireless Example.
Barcode Scan – Demo
Video 1 (01:19)
In this video I’m testing barcode input for a till system (point of sale system). Notice that if you scan the product barcode a number of times, it updates the number of products the customer has purchased.
I went further with the development and added the facility for removing a product in cases where a product was accidentally scanned in.
Barcodes – MS Access – (Northwind)
Video 2 (5:41)
This is an excellent video here from “Access All In One” – Hacking Northwind 01 – Using Barcodes In Access.
See my video VBA Beginner – Setup the Northwind dB – Nifty Access, which provides instructions on how to install the “Northwind Traders” sample database from Microsoft.
