MSAccess and barcodes

  • Thread starter Poul Erik Jacobsen
  • Start date
G

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.
 
T

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
 
A

Angus

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?
 
A

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") & "*"
 
B

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
 
D

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

Arvin Meyer said:
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

Angus said:
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?
Click to expand...
Click to expand...
 
Top