Printing 2 'copies' to a page

[Guest]

I'm trying to get away from a 2-part pre-printed pin-fed invoice form, but I
need to stick with an 8.5" x 5.5" format, and I need 2 copies.

So, I'm trying to print a 1/2 page invoice on perforrated 8.5x11 paper,
where the top and bottom are identical (the same invoice)....and, what seems
to be the hard part, if the line items extend boyond the 1/2 page, they print
on page 2, where again the top and bottom are identical.

I tried using subreports with a height of 5.4", that can't grow, but then I
lose the page 2 data. I actually get a 2nd page, but it just shows the page
1 information again.

Any help you could offer would be appreciated.

 

[Wayne Morgan]

I believe you will find this example of printing more than one copy of a
label to be handy. Treat your paper as if it is two labels, one above the
other. You will need to set up the Page Setup for the report as if you were
printing labels.

http://support.microsoft.com/default.aspx?scid=kb;en-us;299024

 

[Allen Browne]

Wayne, the logic in that knowledgebase article is faulty.

Judy will probably get away with it because she has fixed height sections,
but I could not recommend the approach. Setting the NextRecord and
PrintSection properties of the report (as that code does) relies on Access
running all the events to calculate the layout of the report. But if the
user just prints page 4, the events for pages 2 and 3 are NOT calculated,
and so the results are that Access prints the wrong stuff, i.e. what you get
on page 4 is not the same as what would be on page 4 if you printed the
entire page report.

Since the approach is fundamentally flawed, you need a different algorithm,
such as a Cartesian product in the report's RecordSource so it does generate
the correct number of labels. Example in this article:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[Wayne Morgan]

Thanks Allen,

I've used the logic in the article, but have always filtered the results
first to get what I wanted to print, so I printed everything when it came
time to print. I read your method and I think I like it better. It is
definitely simpler than the coding.