label printing

[Guest]

I have a 2003 report that prints labels three across and several dow. If
there are only a few labels to print and some of the labels on a page are
alrady used, how do I print the labels on an existing label sheet to spots
where the labels have not been printed to before.

 

[Allen Browne]

See:
How to skip used mailing labels and print duplicates
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;299024

Note the that duplication process in that article is faulty.
The skip part works.

 

[Guest]

thanks,

did the trick

 

[Guest]

Allen, thank you for the reference. This helped a lot on my generic labels
as well. I have a question on modifying the functions in this reference,
though. I have an Events module that pulls a group of accounts; one field is
the number of badges to print for each account ("txtNumbOfBadges"). Is there
a way to modify the function so that LabelCopies& has the value of this field
rather than a user-input box?

Thanks!

Ross

 

[Allen Browne]

Yes, you can modify the code to do that, but the entire approach to
duplicated labels explained in that article is faulty.

For an explanation of what's wrong with it, and an alternative approach that
does work see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[Guest]

Tremendous! Thanks.

Interestingly, I tried my feeble hand at the code using NextRecord/MoveNext
in the Format property. I was able to get multiple labels - it never stopped
repeating! I was using a Do Loop and made sure to have my exit within the
loop. I input a message box to notify me/confirm that the loop had exited;
when the message box appeared and I clicked on OK, ***the code re-entered the
Do Loop!!!***.

The only thing I can think of is that I was trying to get 3 labels for one
record, and my label report had four text boxes. Since I was in the Format
property of the detail section, the code was trying to run on each text box
because I had to click 12 times before the code would stop and the report
would appear.

Thanks again for your help.