Perform an Inventory by Scanning Barcodes into a Table Question

[Tom]

Can someone point me into the correct direction?

I have an Access 2K database and I want to add the capability to take an
inventory by scanning Barcodes from our products. Ultimately, I should be
able to create a report and be able to Export the results to provide to the
customer.

TIA!

 

[John W. Vinson]

Can someone point me into the correct direction?

I have an Access 2K database and I want to add the capability to take an
inventory by scanning Barcodes from our products. Ultimately, I should be
able to create a report and be able to Export the results to provide to the
customer.

TIA!

You'll need software to link the barcode scanner to your keyboard -
such software routinely comes with the scanner. As far as Access is
concerned, the text coming from the scanner looks like it's coming
from the keyboard - you would set focus to the textbox and scan it.
The value in the barcode would be put into the textbox and then stored
in the table.

If you want to print barcodes, you'll need a compatible barcode font.

John W. Vinson [MVP]

 

[barcodewiz]

Hi Tom,

Please take a look at BarCodeWiz Barcode ActiveX Control, which is a
plug-in that can be used in Access for printing barcodes. The demo
comes with Access examples which show how to print barcodes as well as
scan them into a form.

http://www.barcodewiz.com/msLanding.aspx

If you have any questions, don't hesitate to ask.

Alek Szymanski
http://www.barcodewiz.com

 

[Tony Toews [MVP]]

You'll need software to link the barcode scanner to your keyboard -
such software routinely comes with the scanner.

You may need to configure the scanner for the bar code but AFAIK you
seldom never need to install software on the PC. Well, maybe some
driver software if it's a USB scanner. But if it fits between the
keyboard and the keyboard jack on the computer then no software should
be require.

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

 

[Tom]

OK, thanks for the reply.

The program is already printing Barcodes. We use TrueType Barcode fonts
and we have an Excel file that generates the Barcode Strings from the
actual Barcode number.

 

[Tom]

Thanks for the reply.

You may need to configure the scanner for the bar code but AFAIK you
seldom never need to install software on the PC. Well, maybe some
driver software if it's a USB scanner. But if it fits between the
keyboard and the keyboard jack on the computer then no software should
be require.

Tony

 

[Tom]

Thanks for the reply. I will take a look.

Hi Tom,

Please take a look at BarCodeWiz Barcode ActiveX Control, which is a
plug-in that can be used in Access for printing barcodes. The demo
comes with Access examples which show how to print barcodes as well as
scan them into a form.

http://www.barcodewiz.com/msLanding.aspx

If you have any questions, don't hesitate to ask.

Alek Szymanski
http://www.barcodewiz.com

 

[John W. Vinson]

The program is already printing Barcodes. We use TrueType Barcode fonts
and we have an Excel file that generates the Barcode Strings from the
actual Barcode number.

Good... reading is the easy part and you have the hard part done!

John W. Vinson [MVP]