Barcode printing and tracking

[Fred Worthington]

Greetings:

I am looking for advice regarding bar code label printing with Access. My
non-profit organization receives donated items that are sold in our store.
I want to track this inventory by attaching a bar code label to the
merchandise when it is received so the donor will receive proper credit when
the item is sold. Ideally, the barcode will contain the donor's information
as it is entered into the database. Then, it would be nice if scanning the
barcode on the item would bring up the donor's record from the database
(sort of a two-way operation). Can anyone give me a few tips on the best
way to do this (software, hardware, report configuration, etc.)?

Thanks . . . Fred

 

[Fred Boer]

Dear Fred:

You can use an simple "wedge" type barcode scanner. These scanners use a
"splitter" cable and share the keyboard port on the computer. The scanned
barcode is sent to the computer as if it had been typed at the keyboard. So,
no special software is required. Barcode labels can be printed using a
barcode font. I use a Dymo Labelwriter to generate barcode labels.

There is lots more information here:

http://www.granite.ab.ca/access/barcode.htm

HTH
Fred Boer

 

[Fred Worthington]

Thanks, Fred. That helps.

Dear Fred:

You can use an simple "wedge" type barcode scanner. These scanners use a
"splitter" cable and share the keyboard port on the computer. The scanned
barcode is sent to the computer as if it had been typed at the keyboard. So,
no special software is required. Barcode labels can be printed using a
barcode font. I use a Dymo Labelwriter to generate barcode labels.

There is lots more information here:

http://www.granite.ab.ca/access/barcode.htm

HTH
Fred Boer