Barcodes

  • Thread starter Thread starter lauriecking
  • Start date Start date
L

lauriecking

I am working on an Access database (2003 or 2007) where I want to
print a report that has barcodes for the item number. So if I was
looking for something on the manifest, I can just scan the barcode.

The problem I am having is that I can get the fonts with no trouble
but my scanner will not recognize it unless I have an asterick at the
start and end of the item number.

Could someone help me with this?

Thank you.
 
Base your report on a query, not the table.

In the query, add the asterisks before and after the number.

Instead of

SELECT Field1, Barcode, Field2 FROM MyTable

you need

SELECT Field1, "*" & Barcode & "*" AS BarcodeWithAsterisks, Field2 FROM
MyTable
 
IMHO You do not need to add '*' 's to the query. You should add them (via a
string string var) before and after the ID number when it will be printed in
the report. The '*' 's (control chars) are needing by the barcode reader for
reading the barcode correctly.
 
Just because the asterisks are required by the barcode reader, why does that
mean you need to add them to the variable?

There's nothing wrong with adding them through a query, so that you're not
perpetuating them throughout the database.
 
Yes,

say Your ID number is "12345", the what should be printed on Your report (in
barcode free 3of 9) is "*12345*". The two '*' 's are the start and the stop
sign, needed for a right reading.

--
Met vriendelijke groet,


Hans Heezemans
(www.iservi.com)
 
Back
Top