printing a page as the last page of a report

[drctx]

i'm wanting to print a term of sales page as the last page of a report. i can't think of a way to do it. does anyone have any ideas?

 

[cghoga]

if you are not previewing the report, create a separate report.
print it after you print the first report.

DoCmd.OpenReport "Report1"
DoCmd.OpenReport "Report2"

if you are previewing the report, try including it as a subreport in the main report footer.

Hope this helps.

 

[dhookom]

You could place all the information in the Report Footer section. I would probably enter the terms into a table and then make a subreport based on this table. Then add the subreport to the main report footer.

If you want to change your terms, you edit data rather than going to the report design.

Duane
MS Access MVP

 

[drctx]

i tried putting a subreport in the report footer and when i view the report it shows the subreport with page header and footer. how can i turn the page header and footer off on the last page?

 

[dhookom]

You would probably need code in the Page Header and Footer sections:
Cancel = ([Page]=[Pages])
This requires you to have at least a control that displays the [Page] on each page (could be hidden).

You could also try:
Cancel = ([Page]=[Pages])
Me.MoveLayout = False

Duane
MS Access MVP

 

[drctx]

thanks, that helped a lot! i does what i want now, i just need to play with the subform length so i can get everthing on one page.

 

[drctx]

i figured it out. i used the pageheader and pagefooter properties to not display on the same page as the reportfooter.

Reports![zzReportsale3 - WORKING].PageFooter = 2
Reports![zzReportsale3 - WORKING].PageHeader = 2