Printed Serial Numbers

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Darren DeCoste
    #1

    Printed Serial Numbers

    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
    Tags: None
    • paii, Ron
      #2
      Re: Printed Serial Numbers

      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" <ddecost2@yahoo .com> wrote in message
      news:731937d3.0 404150711.296b4 d45@posting.goo gle.com...[color=blue]
      > 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[/color]


        Comment

        Previous template Next
        Working...