printing labels from a from

[Miguel Celedon]

I have a set of records in a subform.
I have one field in that subform showing how many labels do I need to print
for that specific record.
How can I make access to read that number "x", and print "x" number of
copies of the same label.

I need 3 labels for record A
I need 5 labels for record B
I need 1 labels for record C


mrpItem mrpQtyReq stdPack: numberOfLabels:
A 30 10 3
B 50 50 5
C 10 10 1

Thanks

 

[John W. Vinson]

On Wed, 13 Feb 2008 15:22:00 -0800, Miguel Celedon <Miguel

I have a set of records in a subform.
I have one field in that subform showing how many labels do I need to print
for that specific record.
How can I make access to read that number "x", and print "x" number of
copies of the same label.

I need 3 labels for record A
I need 5 labels for record B
I need 1 labels for record C


mrpItem mrpQtyReq stdPack: numberOfLabels:
A 30 10 3
B 50 50 5
C 10 10 1

Thanks

There's a handy little trick you can do for this purpose. Create a little
utility table named Num, with one Long Integer field N; fill it manually with
values from 0 through the largest number of labels you'll ever want (be
generous, even a 10000 row table is tiny).

Base your Label report on a Query. Include the Num table with NO join line.
Put a criterion on N of

< [numberOfLabels]

You can even put textboxes on the report with control sources

=N + 1

=numberOfLabels

to show that this is label 4 of 5.

 

[Allen Browne]

John's trick is the best approach.

If you need step-by-step instructions to implement it, see:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

On Wed, 13 Feb 2008 15:22:00 -0800, Miguel Celedon <Miguel

I have a set of records in a subform.
I have one field in that subform showing how many labels do I need to
print
for that specific record.
How can I make access to read that number "x", and print "x" number of
copies of the same label.

I need 3 labels for record A
I need 5 labels for record B
I need 1 labels for record C


mrpItem mrpQtyReq stdPack: numberOfLabels:
A 30 10 3
B 50 50 5
C 10 10 1

Thanks

There's a handy little trick you can do for this purpose. Create a little
utility table named Num, with one Long Integer field N; fill it manually
with
values from 0 through the largest number of labels you'll ever want (be
generous, even a 10000 row table is tiny).

Base your Label report on a Query. Include the Num table with NO join
line.
Put a criterion on N of

< [numberOfLabels]

You can even put textboxes on the report with control sources

=N + 1

=numberOfLabels

to show that this is label 4 of 5.

 

[Miguel Celedon]

I took John's idea and did this.

I made a Num table with two fields:
numberOfLabels OfPages
1 1
2 1
2 2
3 1
3 2
3 3
...
which was easy to generate in Excel. So I linked the number of labels in the
original recorset to this new table and put it as a record source to the
report. So I could have the exact number of records matching the number of
labels needed.
It work perfectly.
Thanks

John's trick is the best approach.

If you need step-by-step instructions to implement it, see:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

On Wed, 13 Feb 2008 15:22:00 -0800, Miguel Celedon <Miguel

I have a set of records in a subform.
I have one field in that subform showing how many labels do I need to
print
for that specific record.
How can I make access to read that number "x", and print "x" number of
copies of the same label.

I need 3 labels for record A
I need 5 labels for record B
I need 1 labels for record C


mrpItem mrpQtyReq stdPack: numberOfLabels:
A 30 10 3
B 50 50 5
C 10 10 1

Thanks

There's a handy little trick you can do for this purpose. Create a little
utility table named Num, with one Long Integer field N; fill it manually
with
values from 0 through the largest number of labels you'll ever want (be
generous, even a 10000 row table is tiny).

Base your Label report on a Query. Include the Num table with NO join
line.
Put a criterion on N of

< [numberOfLabels]

You can even put textboxes on the report with control sources

=N + 1

=numberOfLabels

to show that this is label 4 of 5.

 

[John W. Vinson]

I took John's idea and did this.

I made a Num table with two fields:
numberOfLabels OfPages
1 1
2 1
2 2
3 1
3 2
3 3
..

That was NOT what I suggested and is NOT necessary! Reread my message.

You can generate the same set of numbers on demand, without opening Excel or
creating a new table, just by using the (single field) auxiiliary table Num.
You're making this much harder than it really is!