Print single page 2

[dcurtis]

I have a report I want to print just page 1 of. I tried using the DoCmd.PrintOut command, but haven't figured out where to put it.

I want the user to still be able to hit the print button that is on the tool bar by default, but then have it print just page 1.

Thanks in advance for any help.

----
Access 2002 on a mixed Windows OS network.

 

[CosmoKramer]

Try:

DoCmd.PrintOut acPages, 1, 1

Hoc nomen meum verum non est.

 

[dcurtis]

Where do I put it?

 

[CosmoKramer]

In the On Click event of a command button, put code something like this:

DoCmd.OpenReport "YourReportName", acPreview
DoCmd.PrintOut acPages, 1, 1
DoCmd.Close acReport, "YourReportName"

Hoc nomen meum verum non est.

 

[dcurtis]

Is there a way to allow previewing on the screen, but then when it's printed restrict it to page 1?

There are times when the users need to view the whole report, but when it's printed only need the 1st page. I don't want them to have to manually make it print page 1 every time (most don't know how, and those who do usually forget to set it).

 

[CosmoKramer]

This is the only way I know how to automate the printing of selected pages. Maybe someone else can help with the overriding of the print dialog box Print Range default.....

Hoc nomen meum verum non est.

 

[dcurtis]

Thanks for your help. Have a star for your time.