how to open report and print out page 2 to page3

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

help - 12 Dec 2006 03:00 GMT

how to open report and print out page 2 to page3

"docmd.openreport " can open report and print out all pages ,how can I only
print out page 2 to page 4?

Reply to this Message

fredg - 12 Dec 2006 05:25 GMT

> how to open report and print out page 2 to page3
>
> "docmd.openreport " can open report and print out all pages ,how can I only
> print out page 2 to page 4?

If the report is not opened in Preview:
DoCmd.SelectObject acReport, "ReportName",True
DoCmd.PrintOut acPages , 2, 4

If the report is opened in Preview:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.SelectObject acReport, "ReportName", False
DoCmd.PrintOut acPages , 2, 4

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message