Print multiple mailing labels in Access 2003 or 2007

[Patrick Sewell]

I have come across the following KB from Microsoft that has helped me to
print a fixed number of copies of the labels that I wish to print. This
works pretty well.

http://support.microsoft.com/kb/299024

However, I would like to include a field in my table for the number of
copies I want of each label. For example, if each record in my table
contains the information for a given label, one field in that record should
contain the number that represents how many of that type of label I want to
print. Each record may contain a differnt number in this field. I want all
records to print the appropriate number of times when I print the label
report.

How can I modify the code in the above KB to make this happen? Let's assume
that the table is named MyTable and the label report is named MyLabels and
the field in MyTable that contains the number of copies is called Quantity.

Any assisntance is greatly appreciated!

Thanks!

Patrick Sewell
(e-mail address removed)12.co.us
Network Administrator
Monte Vista School District
Monte Vista, Colorado USA

 

[Boyd Trimmell aka Hi Tech Coach via AccessMonster.]

Patrick

ACC: How to Repeat Report Records a Specified Number of Times
http://support.microsoft.com/kb/179288

Hope this helps ...

 

[Boyd Trimmell aka Hi Tech Coach via AccessMonster.]

Also here ia another way the is very easy to do

print different number of labels for each record
http://www.utteraccess.com/forums/s...e=m&olderval=&oldertype=#Post1179173&bodyprev
=

There is an attached example.

I have come across the following KB from Microsoft that has helped me to
print a fixed number of copies of the labels that I wish to print. This
works pretty well.

http://support.microsoft.com/kb/299024

However, I would like to include a field in my table for the number of
copies I want of each label. For example, if each record in my table
contains the information for a given label, one field in that record should
contain the number that represents how many of that type of label I want to
print. Each record may contain a differnt number in this field. I want all
records to print the appropriate number of times when I print the label
report.

How can I modify the code in the above KB to make this happen? Let's assume
that the table is named MyTable and the label report is named MyLabels and
the field in MyTable that contains the number of copies is called Quantity.

Any assisntance is greatly appreciated!

Thanks!

Patrick Sewell
(e-mail address removed)12.co.us
Network Administrator
Monte Vista School District
Monte Vista, Colorado USA

--
Boyd
Hi Tech Coach
http://www.hitechcoach.com

Message posted via AccessMonster.com