How to print barcode

[Chlaris]

Dear all,

How to print barcode using Access ?
Thanks.

Chlaris

 

[Tony Toews [MVP]]

How to print barcode using Access ?

Barcodes mean

1) a means of reading them. These devices usually fit between your
keyboard and your computer and mimic someone keying in the code
directly. All you need to do in your app is a little forms design to
ensure someone can continuously feed bar codes into your app and
change the quantity occasionally.

2) A means of printing them. Choose the proper barcode and locate an
appropriate font. Place the font file on all the systems which will
be printing bar codes. On the report(s) change the font on a field to
use the bar code font. Some bar codes like having *s before and after
while others like check digits.

For more info and links see the Using bar codes within an application
page at my website at http://www.granite.ab.ca/access/barcode.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Thomas Lutz]

The best and easiest way to print bar codes from an Access database is
to use a bar code ActiveX control. You can use fonts as well however
bar code fonts are more difficult to use depending on the type of bar
code that you need to print. Most bar code symbologies use complex
algorithms for determining the bar/space pattern in the bar code and
they also use checksums that must be calculated so it is not as easy
as selecting the text and changing the font to a bar code font.
Anyhow bar code fonts also produce very poor quality bar codes that
may be difficult to read depending on the type of printer that you use
and the scanner that you read them with.

A good bar code ActiveX control will generate generate a high quality
bar code "vector" image and it will also perform all the calculations
for you so all you would need to do is drop the bar code ActiveX
control into your report, set the type of bar code that you want and
bind the control to the field containing the data that you want
encoded in the bar code. Beware of bar code ActiveX controls that are
wrappers around bar code fonts - they produce the same poor quality
bar codes as bar code fonts because they use fonts to produce the bar
code.

Anyhow, the best bar code ActiveX control that I know of is from TAL
Techniologies www.taltech.com
They have a demo version of their ActiveX control that you can play
with and it even comes with a sample Access database that demonstrates
how to use it in Access. It also creates the best quality bar codes
that you can get.

 

[Bob]

Hi, Chlaris,

If a Code 39 ("Code 3 of 9") type of barcode will meet your needs, a
TrueType font is the easiest and most economical method. All you have
to do is specify the Code 39 font in your report and add as asterisk
at the beginning and end. Here's a link to an article on the subject:

http://www.mecsw.com/info/appnote/app_014.html

Code 39 TrueType fonts are readily available. There are many free
versions of varying quality. Here is a link to a commercial version:

http://www.mecsw.com/software/softwarefonts.html#BBTTC39

If you need a different type of barcode (UPC, Code 128, etc.) then
things get a little trickier. If you use fonts, you will have to do
some formatting and math. It's not that hard to do, but you can avoid
the complexities and use an ActiveX control as suggested by another
poster. If you intend to use a 2-D code, then you absolutely have to
use add-in software (like ActiveX).

Best Regards,


Bob

The Barcode Software Center
www.makebarcode.com

 

[MontereySoft]

Dear all,

How to printbarcodeusing Access ?
Thanks.

Chlaris

Here is some info (Using Barcode ActiveX in Microsoft Access)


http://mdn.morovia.com/manuals/bax3/using_bax_in_access.php

 

[Thomas Lutz]

The best way to print bar codes in Access is to use a good bar code
ActiveX control. The best one on the market is available from TAL
Technologies.
For information or to download a demo, visit:
http://www.taltech.com/products/activex_barcodes.html