How to print a page in between of every report page?

  • Thread starter Thread starter Brian Hawks
  • Start date Start date
B

Brian Hawks

I'm fairly inexperienced with Access, but I was asked if there would be any way to solve a problem. My company prints product invoices using access reports. Terms and Conditions pages are now required to be put on the back of said reports. The detail section of the report prints a list of all of the items on an invoice, and sometimes they take up more than one page. I have been trying to use a subreport containing the terms and conditions page and setting it visible and invisible whenever an invoice page ends. The problem I am now having is that one item of the invoice is put under the terms and conditions page because the subreport and the item are in the same detail band if I use the subreport's force new page, and if I use a manual page break in my main detail section a new page is created, but no information from the rest of the items is shown. Is there any other way I can accomplish this?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Free Online Courses Available for Eggheadcafe.com Users
http://www.eggheadcafe.com/tutorial...8-fc3cf6855293/free-online-courses-avail.aspx
 
You might try adding a group based on the invoice number and put the Terms and
Conditions in the group footer. Set the group footer to print on a new page
by setting Force New Page property to Before Section.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
That would work, but only for the end of each invoice. I should have clarified that I need the terms and conditions to be printed behind EACH page of the invoice. That is why I was assuming I would have to put something in the detail section, since it is the section that is creating the new pages. Any other ideas I could try?



John Spencer wrote:

You might try adding a group based on the invoice number and put the Terms
06-May-10

You might try adding a group based on the invoice number and put the Terms an
Conditions in the group footer. Set the group footer to print on a new pag
by setting Force New Page property to Before Section

John Spence
Access MVP 2002-2005, 2007-201
The Hilltop Institut
University of Maryland Baltimore Count

Brian Hawks wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Crypto Obfuscator for .NET - Product Review
http://www.eggheadcafe.com/tutorial...f8-f5fd987fafb1/crypto-obfuscator-for-ne.aspx
 
Sorry, nothing comes to mind.

I thought about using the page number with Mod 2 and using that to print the
terms page, but that would probably fail since you have a sub-report printing.

Something like
Private Sub Report_Page()
If Me.Page Mod 2 = 0 Then
Me.txtTerms.Visible = True
Me.cPageBreak.Visible = True
Else
Me.txtTerms.Visible = False
Me.cPageBreak.Visible = False
End If
End Sub

Perhaps ;you can find a way to redesign the report so it is not using a
sub-report. It is often possible to get the same printout results using
grouping and sorting instead of using a sub-report.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top