Printing Specific Pages of a Report

[oop94]

Hello again,
I have a report that is 3 pages long. When users check out a form and click the print button, the report is printed (I have a macro doing the work on the background). I was wondering if there is a way that the macro would ask the user which pages of the three he or she wants to print, before it sends it to the printer.
Thank you ahead of time!

 

[rjoubert]

You could open the report in preview mode rather than sending it directly to the printer. That way, when the users select File - Print, they have the option to specify which page(s) to print.

DoCmd.OpenReport "YourReport", acViewPreview

 

[rjoubert]

Oops...I guess I should pay attention to what forum I'm in. Is your report in Access? Is your code in Access VBA?

 

[oop94]

It's in Access . . .

 

[johnwm]

...then you'll do better to ask in one of the numerous Access forums, rather than VB6 forum. Try the 'Find a Forum' search at the top of the page.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller