Printing 2 'copies' to a page

  • Thread starter Thread starter Guest
  • Start date Start date
G

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, 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
 
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.
 
Back
Top