Print bar code labels to Zebra printer

[Tony Girgenti]

Hello.

I am not sure if this is only a question for third party software or not so
i cross posted to the Access group.

I'm trying to determine if using Access 2000 to print bar code labels can be
done programmatically or should i look at using a third party software ?

We have it working from Word, but everytime we want to print a label, we
have to open Word. Not that big of a hassle, but it would be nice if we
could do it from Access where they do most of their work.

Any help would be gratefully appreciated.

Thanks,
Tony

 

[Arvin Meyer [MVP]]

I print membership cards with Barcode 39 on our computer society's
membership cards. Logging our meetings is as simple as a quick scan of their
card as they pass through the door on the way to the meetings. We use a
Barcode font that came with the scanner we bought, but there are free font
programs out there.

 

[Tony Girgenti]

Hello Arvin.

So, i need to get the font and allow Access to use it. I think we have it
already because we use it in Word.

Do you have any information on how to print to a label printer that prints
one label at a time in Access ? Any sample coding anywhere ?

Thanks,
Tony

 

[Arvin Meyer [MVP]]

DoCmd.OpenReport "Report Name",,,"ID =" & Forms!FormName!txtID

Opens you label program to the specific label that you are looking at on the
form and prints it to the printer saved for that label. Make sure that you
change everything to fit your names.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Thomas Lutz]

For printing bar codes from Access, you would be best off using a bar
code ActiveX control like the one from TAL Technologies at the
following URL:
http://www.taltech.com/products/activex_barcodes.html
I would recommend that you download the demo of the TAL Bar Code
ActiveX control from the above URL and take a look at the sample
Access database that is provide with the demo.
Bar code fonts generally produce very poor quality bar codes and they
are not as easy to use as an ActiveX control for most types of bar
codes.

To design a bar code label, you would use the report designer in
Access to create a small report that is the size of the labels for
your Zebra printer. You will need to first create a blank report and
then select File - Page Setup and click on the "Page" tab and tell
Access to not use the default printer and instead select the Zebra
printer. You then need to design the report to fit the labels and be
within the printer margins. It's a little tricky but not impossible.