Print Report - Printer Options

[George]

I use a Macro to execute the print process for my reports.
The options I select in the Macro design are
1. Open Report "Name of Report"
2. Run Command, Print
3. Close Report - "Name of Report"

The reason I use the Run Command - Print, because it pops-
up the printer options menu so I can select which printer,
also the option of how many pages I want - etc

This process works but what I don't like is when the Macro
runs it pops open a blank Report and then the Printer
Options Menu Loads on top of it - which looks bad. Is
there any other way to get the printer options menu to run.

Thanks - George

 

[Steve Schapel]

George,

One idea would be to insert a Minimize action between your existing
steps 1 and 2.

- Steve Schapel, Microsoft Access MVP

 

[George]

Yes - I though of that and when I insert minimize it
doesn't print the report - instead it prints a picture of
the printer Options Menu. For some reason when the report
is minimized it seems to lose focus.

George

 

[Steve Schapel]

Good point, George.

OK, I am pretty sure this will work:
1. OpenReport "Name of Report"
2. Minimize
3. SelectObject, Report, "Name of Report"
4. Run Command, Print
5. Close, Report - "Name of Report"

- Steve Schapel, Microsoft Access MVP