Bar Code Printing

[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

 

[Steve]

Start with the following tables:

TblDonor
DonorID
<<Donor Information>>

TblDonorItem
DonorItemID
DonorID
ItemDescription
DonatedDate
SoldDate

Your barcode should have the value of DonorItemID. DonorItemID tells you
everything about the item.

Use Code39 barcode. Google for Code39 to learn about it and it's free to
download. Once downloaded, you need to install it as a font in Windows.
Check out Zebex.com for barcode scanners.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Fred Worthington]

Thanks, Steve. That helps.

Start with the following tables:

TblDonor
DonorID
<<Donor Information>>

TblDonorItem
DonorItemID
DonorID
ItemDescription
DonatedDate
SoldDate

Your barcode should have the value of DonorItemID. DonorItemID tells you
everything about the item.

Use Code39 barcode. Google for Code39 to learn about it and it's free to
download. Once downloaded, you need to install it as a font in Windows.
Check out Zebex.com for barcode scanners.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)