Bar Codes

[Guest]

Is there a way you can set up Bar Codes in Access?
Thanks fo any help

 

[Steve]

Consider using Barcode type 39. It's free and is added to your computer
system as a font.
Look at Zebex.com for a barcode scanner. A scanner is installed in parallel
with your keyboard and acts just like a keyboard. Rather than pressing keys,
you scan a barcode and the "value" fo the barcode is entered into the form.
For printing barcodes in any kind of a report, you use a textbox and set the
font to Barcode Type39.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Many thanks Steve. So does that mean you could set up a table with a range
of numbers from say 1000 to 10,000, produce a label report and then print
them off. I gather each label would have its own specific coding according
to the numbers in the table?

Also, I have set up a module to generate a range of numbers, approx 100,000
as follows:
Option Compare Database

Function MakeData(HowMany As Long)
Dim rs As DAO.Recordset
Dim lng As Long

Set rs = DBEngine(0)(0).OpenRecordset("tblCount", dbOpenDynaset)
For lng = 1 To HowMany
rs.AddNew
rs![CountID] = lng
rs.Update
Next
rs.Close
Set rs = Nothing
End Function

I cannot for the life of me remember what I need to type in the Bottom
(Immediate) (Ctl & G to get there )Section to generate these numbers in my
table

Thanks if you can help

 

[Tony Toews [MVP]]

Is there a way you can set up Bar Codes in Access?

Barcodes mean

1) a means of reading them. These devices usually fit between your keyboard and
your computer and mimic someone keying in the code directly. All you need to do in
your app is a little forms design to ensure someone can continuously feed bar codes
into your app and change the quantity occasionally.

2) A means of printing them. Choose the proper barcode and locate an appropriate
font. Place the font file on all the systems which will be printing bar codes. On
the report(s) change the font on a field to use the bar code font. Some bar codes
like having *s before and after while others like check digits.

For more info and links see the Using bar codes within an application page at my
website at http://www.granite.ab.ca/access/barcode.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Steve]

Hi Roger,

See response in-line.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Many thanks Steve. So does that mean you could set up a table with a
range
of numbers from say 1000 to 10,000, produce a label report and then print
them off.

The answer to your question is all you need do is set the recordsource of
the report to your table, create a textbox on your label report, set the
controlsource of the textbox to the name of the number field in your table
and set the font of the textbox to Code39.

However, why do you think you need the table of numbers?

I gather each label would have its own specific coding according
to the numbers in the table?

Also, I have set up a module to generate a range of numbers, approx
100,000
as follows:
Option Compare Database

Function MakeData(HowMany As Long)
Dim rs As DAO.Recordset
Dim lng As Long

Set rs = DBEngine(0)(0).OpenRecordset("tblCount", dbOpenDynaset)
For lng = 1 To HowMany
rs.AddNew
rs![CountID] = lng
rs.Update
Next
rs.Close
Set rs = Nothing
End Function

I cannot for the life of me remember what I need to type in the Bottom
(Immediate) (Ctl & G to get there )Section to generate these numbers in
my
table

Thanks if you can help

Consider using Barcode type 39. It's free and is added to your computer
system as a font.
Look at Zebex.com for a barcode scanner. A scanner is installed in
parallel
with your keyboard and acts just like a keyboard. Rather than pressing
keys,
you scan a barcode and the "value" fo the barcode is entered into the
form.
For printing barcodes in any kind of a report, you use a textbox and set
the
font to Barcode Type39.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)