Integrating a barcode scanner for a simple POS

[Imran Javed Khan]

I need to use a barcode scanner to keep track of my
inventory. I am using the sample inventory db that comes
with Access, and have added a simple Point of Sale form
and tables to it. I know need have a barcode assigned to
each inventory item and the database to be able to read
the item using a tabletop laser barcode scanner like used
in the grocerystores. Any help would be appreciated.
Imran

 

[Tony Toews]

I need to use a barcode scanner to keep track of my
inventory. I am using the sample inventory db that comes
with Access, and have added a simple Point of Sale form
and tables to it. I know need have a barcode assigned to
each inventory item and the database to be able to read
the item using a tabletop laser barcode scanner like used
in the grocerystores.

Barcodes mean

1) a means of reading them. These devices usually fit between your
keyboard and your computer and mimic someone keying in the code
directly. All you need to do in your app is a little forms design to
ensure someone can continuously feed bar codes into your app and
change the quantity occasionally.

2) A means of printing them. Choose the proper barcode and locate an
appropriate font. Place the font file on all the systems which will
be printing bar codes. On the report(s) change the font on a field to
use the bar code font. Some bar codes like having *s before and after
while others like check digits.

For more info and links see the Using bar codes within an application
page at my website at http://www.granite.ab.ca/access/barcode.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm