print only a specific page of a report

[jessedh]

I want to code a command button to print only the second to last page of a report that I run every day. btw, the report varies from 5 to 500 pages. Fun stuff....

Any ideas how to?

Thanks!
Jesse

 

[Bry12345]

The button should invoke DoCmd.Printout

The Printout method has arguments that allow you to set a Print Range.

DoCmd.PrintOut [printrange][, pagefrom, pageto]
[, printquality][, copies][, collatecopies]

See this for details:

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D2/S5A1B7.asp

- - - -

Bryan