Barcodes

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

 

[Douglas J. Steele]

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

 

[lauriecking]

I will try that. I will let you know how that works out.

 

[Hans]

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.

 

[Douglas J. Steele]

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.

 

[Hans]

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)