Label report printing error

[Guest]

I have set up 4 reports (the same 52 records on each reports-varied slightly)
for labels (Avery L7162 - 16 per page) using the label wizard. I have used
the MS office help for code on how to skip mailing labels and print multiple
copies-see link below.

http://support.microsoft.com/default.aspx?scid=kb;en-us;95806&Product=acc

This function works fine when I run any of my labels report. However, when i
enter 0 labels to be skipped and 16 multiples-therefore giving me one record
on each page and 52 pages in total-and I then only want to print a specifc
page eg pages 2-2 or 52-52 or 30-30, I ALWAYS get a print out of what is
record/page 49 in the print preview.....

Can anyone explain this??

Alternatively and preferably I would be looking at putting all the criteria
on one form to enter information before generating the report. I do need some
help on what and how should to intergrate the code that I have used in the
link above and code to select one or multiple records to print for...

Thanks in advance

 

[Allen Browne]

Emily, it is not possible to get this to work as advertised.

Any code that relies on the form events across multiple pages is unreliable.
You can use the code in that article to skip the initial labels, as long as
you don't tell it to skip more labels than there are on a page. But the
other side of the article, using the report events to repeat the section
won't work, exactly as you found.

What happens is that the report events are not triggered for all the
intervening pages when you print only some pages of the report, and so you
end up with the wrong results.

For an alternative approach, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html