BAR CODE in Access 2002

[D.M]

In the main form, near the field X (unique personal number for example
2901977100035) I want to add button who is going to print that number in bar
code format EAN 128 on the printer label A4.
If you know how am I going to do this, please contact me on this newsgroup.
Thanks

 

[Arvin Meyer]

Make a report using a Bar Code Font to run on the label printer. Use a
standard where clause in the open report code for your button:

DoCmd.OpenReport "MyLabel", , "IDfield = " & Me.txtID

substituting the appropriate field and control names.

A good place to get bar code information is:

http://www.adams1.com/pub/russadam/share.html

They can also point you to where you can get barcode fonts for EAN 128
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Thomas Lutz]

For printing bar codes from Access, you would be best off using a bar
code ActiveX control like the one fromTAL Technologies at the
following URL:
http://www.taltech.com/TALtech_web/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.