MSAccess and barcodes

[Guest]

Is it possible to use Access to create barcodes? If so, how?

 

[Guest]

yes.
not sure what you want I use access to barcode our
recieving lables.
I created a report the same size as our lables.
to bar code the quantity, I put a text box for quantity
twice one over the other. the lower text box has regular
font(arial?), the one on top has font 3 of 9 barcode.
barcodes are just another font. you can get other barcode
fonts off the net. access comes with 3 of 9 barcode font.

 

[Fred Boer]

Dear Poul:

Yes, it is possible. You need to install a barcode font and properly format
the data. There is useful information here:

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

HTH
Fred Boer

 

[Thomas Lutz]

Access does not provide any bar code printing functionality however
there are a number of add-ins that you can use to print bar codes in
an Access report.
The easiest and the best solution would be to use a bar code ActiveX
control. You could probably use a bar code font however bar codes have
a start pattern, a stop pattern and a check digit that must be
calculated. If you use a bar code ActiveX control, these will all be
taken care of for you automatically. You can also "bind" an ActiveX
control to a data source so all you need to do is drop the control
onto your report, set a couple properties and start printing.
The best bar code ActiveX control on the market is available at the
following URL:
http://www.taltech.com/products/activex_barcodes.html
You can download a demo version of the product from the above URL and
the demo even comes with a sample Access database that demonstrates
how to use it in Access.




On Thu, 6 Jan 2005 03:35:02 -0800, Poul Erik Jacobsen <Poul Erik

 

[Guest]

Then if i use barcode fonts instead of Active X does it mean it won't take
care about the start pattern, stop pattern, check digit, etc... that would
make my barcode not correct?

 

[Arvin Meyer [MVP]]

Some barcodes don't require any special characters. Some have check digits.
The most complete explanations I've ever found is at:

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

Many of the scanner companies have instructions as well. I use Code 39 which
simply requires an asterisk as the start and end character, so I use a query
column to prepare my data for reading with the scanner, or printing:

NewID: "*" & Format([MemberID],"0000") & "*"

 

[barcodewiz]

Angus,

Commercial barcode font libraries usually come with a module /
functions that can be used to calculate and add the start/stop
characters and check digits.
For example, when using BarCodeWiz Code 128 Fonts, you would enter the
following as Control Source of your text box:
=BCW_Code128B([PartNumber])

where [PartNumber] is the barcode field from your table.

Alek Szymanski
http://www.barcodewiz.com


http://groups.google.com/group/microsoft.public.access?hl=en - Nov
15,
11:50pm by =?Utf-8?B?QW5ndXM=?= - 5 message - 5 author

 

[Davo78]

Arvin,

I have been trying to use your example to add a barcode to a report, but I
have not been able to get it to work.

Could you or anyone advise me as to the correct procedure for applying the
following to a query: NewID "*" & Format([Item],"0000") & "*"

I have only just started using queries and find them confusing.

Thanks in Advance
Davo

Some barcodes don't require any special characters. Some have check digits.
The most complete explanations I've ever found is at:

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

Many of the scanner companies have instructions as well. I use Code 39 which
simply requires an asterisk as the start and end character, so I use a query
column to prepare my data for reading with the scanner, or printing:

NewID: "*" & Format([MemberID],"0000") & "*"
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Then if i use barcode fonts instead of Active X does it mean it won't take
care about the start pattern, stop pattern, check digit, etc... that would
make my barcode not correct?