Serialized Labels in Access

[Paula =-)]

Is there anyway to create serialized labels in Access?

I need (600) 2-line labels:

First line = the Part Number
Second line = the Serial Number that needs to start with "700" and
it'll end with "1300"

I was thinking that this should be a pretty simple task, but for the
life of me I can't seem to find any help on it!

Anybody??

TIA,
Paula

 

[Jeff Boyce]

Paula

"How" depends on "what". Labels are reports, reports are based on data.
What data do you already have?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Paula =-)]

Jeff,

I have a part number (which will remain the same) and a starting
serial number of 700. I guess I'm thinking I need to do a "mail
merge" into Word using Access for the data. I don't see a way to do
serialized labels in Word itself, may be wrong there tho. This just
seems like it should be a fairly simple task.

Thanks~
Paula

 

[Al Campagna]

Paula,
If every label has it's own unique key identifier (like a CustID
autonumber)
then you can do a Totals query behind your label report.
Since each record is unique, you should still yield 600 records.
Now... add a calculated column to the query, such as...
RecCount : 1

This will assign a value of 1 to every label

On your report, place the RecCount field (hidden), and set it's
RunningSum to OverAll

Add an unbound text control on the form, and name it [CounterSerNo].
Give this control a ControlSource of... (I'd use a "-"separator)
=700+[RecCount] & "-" & [YourSerNoValue]

which will yield...
700-F16524
701-A314276
702-T2312-19
etc....
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


Jeff,

I have a part number (which will remain the same) and a starting
serial number of 700. I guess I'm thinking I need to do a "mail
merge" into Word using Access for the data. I don't see a way to do
serialized labels in Word itself, may be wrong there tho. This just
seems like it should be a fairly simple task.

Thanks~
Paula

 

[Paula =-)]

Al,

Can't attach the serial number to the part number such as in your
"yeild" example. Each label has to look like this:

P/N B152-CI-051-B
S/N 700

Next one:

P/N B152-CI-051-B
S/N 701

And so on...

I guess I was really assuming I could create a label using the Label
Wizard where the Serial number field would be inserted into the label
itself and run 600 to the printer with each new label printed having
the next number in sequence after the starting number of 700.

Thanks~
Paula

Paula,
    If every label has it's own unique key identifier (like a CustID
autonumber)
then you can do a Totals query behind your label report.
    Since each record is unique, you should still yield 600 records.
    Now... add a calculated column to the query, such as...
        RecCount : 1

    This will assign a value of 1 to every label

    On your report, place the RecCount field (hidden), and set it's
RunningSum to OverAll

    Add an unbound text control on the form, and name it [CounterSerNo].
    Give this control a ControlSource of... (I'd use a "-"separator)
        =700+[RecCount] & "-" & [YourSerNoValue]

which will yield...
        700-F16524
        701-A314276
        702-T2312-19
        etc....
--
    hth
    Al Campagna
    Microsoft Access MVP
   http://home.comcast.net/~cccsolutions/index.html

    "Find a job that you love... and you'll never work a day in your life."


Jeff,

I have a part number (which will remain the same) and a starting
serial number of 700.  I guess I'm thinking I need to do a "mail
merge" into Word using Access for the data.  I don't see a way to do
serialized labels in Word itself, may be wrong there tho.  This just
seems like it should be a fairly simple task.

Thanks~
Paula

Paula

"How" depends on "what". Labels are reports, reports are based on data.
What data do you already have?

Jeff Boyce
Microsoft Office/Access MVP

- Show quoted text -

 

[Al Campagna]

Okay, just use the same process I suggested to generate the S/N, and let it
stand alone.
As far as the 700, you will need to store that value in a table.
After printing 600 labels, update the table to 1300, and use that value the
next time you print that particular PartNo label.

Ex. tblPartNoSerNo...
PartNo LastSerNoUsed
12345 1300
5142 450
T4132 800
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."



Al,

Can't attach the serial number to the part number such as in your
"yeild" example. Each label has to look like this:

P/N B152-CI-051-B
S/N 700

Next one:

P/N B152-CI-051-B
S/N 701

And so on...

I guess I was really assuming I could create a label using the Label
Wizard where the Serial number field would be inserted into the label
itself and run 600 to the printer with each new label printed having
the next number in sequence after the starting number of 700.

Thanks~
Paula

Paula,
If every label has it's own unique key identifier (like a CustID
autonumber)
then you can do a Totals query behind your label report.
Since each record is unique, you should still yield 600 records.
Now... add a calculated column to the query, such as...
RecCount : 1

This will assign a value of 1 to every label

On your report, place the RecCount field (hidden), and set it's
RunningSum to OverAll

Add an unbound text control on the form, and name it [CounterSerNo].
Give this control a ControlSource of... (I'd use a "-"separator)
=700+[RecCount] & "-" & [YourSerNoValue]

which will yield...
700-F16524
701-A314276
702-T2312-19
etc....
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


Jeff,

I have a part number (which will remain the same) and a starting
serial number of 700. I guess I'm thinking I need to do a "mail
merge" into Word using Access for the data. I don't see a way to do
serialized labels in Word itself, may be wrong there tho. This just
seems like it should be a fairly simple task.

Thanks~
Paula

Paula

"How" depends on "what". Labels are reports, reports are based on data.
What data do you already have?

Jeff Boyce
Microsoft Office/Access MVP

- Show quoted text -

 

[Paula =-)]

Thanks, Al, I will try that!

Paula

Okay, just use the same process I suggested to generate the S/N, and let it
stand alone.
As far as the 700, you will need to store that value in  a table.
After printing 600 labels, update the table to 1300, and use that value the
next time you print that particular PartNo label.

Ex. tblPartNoSerNo...
PartNo      LastSerNoUsed
12345         1300
5142           450
T4132         800
--
    hth
    Al Campagna
    Microsoft Access MVP
   http://home.comcast.net/~cccsolutions/index.html

    "Find a job that you love... and you'll never work a day in your life."


Al,

Can't attach the serial number to the part number such as in your
"yeild" example.  Each label has to look like this:

P/N B152-CI-051-B
S/N 700

Next one:

P/N B152-CI-051-B
S/N 701

And so on...

I guess I was really assuming I could create a label using the Label
Wizard where the Serial number field would be inserted into the label
itself and run 600 to the printer with each new label printed having
the next number in sequence after the starting number of 700.

Thanks~
Paula

Paula,
If every label has it's own unique key identifier (like a CustID
autonumber)
then you can do a Totals query behind your label report.
Since each record is unique, you should still yield 600 records.
Now... add a calculated column to the query, such as...
RecCount : 1

This will assign a value of 1 to every label

On your report, place the RecCount field (hidden), and set it's
RunningSum to OverAll

Add an unbound text control on the form, and name it [CounterSerNo].
Give this control a ControlSource of... (I'd use a "-"separator)
=700+[RecCount] & "-" & [YourSerNoValue]

which will yield...
700-F16524
701-A314276
702-T2312-19
etc....
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I have a part number (which will remain the same) and a starting
serial number of 700. I guess I'm thinking I need to do a "mail
merge" into Word using Access for the data. I don't see a way to do
serialized labels in Word itself, may be wrong there tho. This just
seems like it should be a fairly simple task.

- Show quoted text -- Hide quoted text -

- Show quoted text -