By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Printed Serial Numbers

P: n/a
I am trying to create an application in Access that I will be able to
print bar code labels. A stumbling block that I have hit is the Serial
Number on the bar code. I would like to be able to read the Serial
number from a Customer table. This serial number just starts at 10000
and goes up. This number is incremented everytime a label is printed
and I am printing 2 copies of each label, each with the same serial.
But during any one print job I can be printing anywhere from 2 to over
100 labels. After the print job is done I would like to store the new
serial number back to the table.

I need to be able to print the number on the label along with this
number with a leter front of it. ie Serial = 12345 and also A12345
(Barcoded with Data Identifier).

Would anybody have an easy way of doing this.

Thank you for your help, it is greatly appreciated.

Darren DeCoste
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Properly the most reliable method would be to generate the serial numbers in
a temp table and use that as a source for the labels.

"Darren DeCoste" <dd******@yahoo.com> wrote in message
news:73**************************@posting.google.c om...
I am trying to create an application in Access that I will be able to
print bar code labels. A stumbling block that I have hit is the Serial
Number on the bar code. I would like to be able to read the Serial
number from a Customer table. This serial number just starts at 10000
and goes up. This number is incremented everytime a label is printed
and I am printing 2 copies of each label, each with the same serial.
But during any one print job I can be printing anywhere from 2 to over
100 labels. After the print job is done I would like to store the new
serial number back to the table.

I need to be able to print the number on the label along with this
number with a leter front of it. ie Serial = 12345 and also A12345
(Barcoded with Data Identifier).

Would anybody have an easy way of doing this.

Thank you for your help, it is greatly appreciated.

Darren DeCoste

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.