Storing Barcodes

G

Guest

We are just starting to import barcodes into an Access database. I do not
understand what is meant by "font 3 of 9 barcode" Where do I find that in
Access or Excel. Do all programs see these numbers the same, for example,
eventually I will import these to Oracle. Could that program see the number
differently?
 
J

Jeff Conrad

in message:
We are just starting to import barcodes into an Access database. I do not
understand what is meant by "font 3 of 9 barcode" Where do I find that in
Access or Excel. Do all programs see these numbers the same, for example,
eventually I will import these to Oracle. Could that program see the number
differently?

Hi Cyndi,

I have not used bar codes with Access yet, but you might want to review
MVP Tony Toews' information on the subject here:

http://www.granite.ab.ca/access/barcode.htm

Should be lots of good links there including where to download the
3 of 9 barcode font.

Good luck with your project,
 
T

Thomas Lutz

Bar code fonts do not modify the data in any way however you almost
certainly will need to change the data before you will be able to use
a bar code font with it. Code 39 bar code fonts require that you put
an asterisk both before and after the actual data that you want to
encode in the bar code. If the asterisks are not there then the bar
codes will not read. Basically they act as Start and Stop codes to
indicate the beginning and end of a bar code.

In general, bar code fonts produce extremely poor quality bar codes
that can be difficult to read and they are also usually not very
"device independent" meaning that different printers will output them
differently and you might get readable bar codes when you print to one
printer and then get unreadable bar codes when you print to a
different printer.

If you want perfectly readable bar codes no matter what printer you
print to, then you are much better off using a good quality bar code
ActiveX control that produces Windows metafile (device independent)
graphic images of bar codes.

The absolute best one on the market is from TAL Technologies. You can
download a demo of their control from the following web page:
http://www.taltech.com/products/activex_barcodes.html

The demo version of the ActiveX control comes with a sample Access
database that demonstrates how to use it to print bar codes in Access
reports. Basically you drop the control onto your report exactly the
same way you would put a textbox on the report and then "bind" the
control to a "data source" so that the bar code data is linked
directly to the control. When you print your report, you get perfect
bar codes encoding your data. You also do not have to modify your data
in any way whatsoever.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Barcodes?? 3
Newbie Update Query Question? 4
Audio? 6
print barcodes 18
Barcodes 5
Barcodes 5
Require Mouse Click 2
Format cell for barcodes 1

Top