P
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
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