If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to print a page in between of every report page?
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/tutorials...ses-avail.aspx |
#2
|
|||
|
|||
How to print a page in between of every report page?
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 Brian Hawks wrote: 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/tutorials...ses-avail.aspx |
#3
|
|||
|
|||
That would work, but only for the end of each invoice.
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 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 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/tutorials...or-for-ne.aspx |
#4
|
|||
|
|||
That would work, but only for the end of each invoice.
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 Brian Hawks wrote: 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 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 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/tutorials...or-for-ne.aspx |
Thread Tools | |
Display Modes | |
|
|