Printed Serial Numbers

[Darren DeCoste]

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

[paii, Ron]

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