Print Last page of report

  • Thread starter Thread starter Heather Irvin
  • Start date Start date
H

Heather Irvin

I need to create a one-click way to printing only the Last Page of a report.

Also is there a way when previewing a report that it will automatically go
to the last page?

Any help or direction would be great!

Thanks in advance!

Heather Irvin
 
Alright I poked around and am now able to print to the last page fine...

stDocName = "RptLumpSum"
pageNumber = Reports!RptLumpSum.[Pages]

DoCmd.OpenReport stDocName, acViewPreview
DoCmd.SelectObject acReport, stDocName, False
DoCmd.PrintOut acPages, pageNumber, pageNumber

I still need to view the last page first though when pulling up a report,
any help would be great... thanks!
 
I still need to view the last page first though when pulling up a report,
any help would be great... thanks!
Click to expand...

Putting this in the form's open event will take you to the last page:

SendKeys "{F5}999~"

Others may have a better or more complete solution.
 
Back
Top