Report as object

[Fredrated]

Does anyone know how to instantiate a report through the object model?
I would like to open a report, change the printer, save the report and then
print to the new printer.

Or, even better, open a report, determine current printer, set new printer,
save, print, reopen and revert to original printer.

I can't seem to figure out how to manipulate the report in code, though.

Thanks

Fred

 

[Allen Browne]

Although it is possible to open the report in design view and assign it to a
particular printer, you are probably better off not to.

Leave it for the Default Printer. Then set the Application.Printer before
opening it. Here's an example of how to use that:
Printer Selection Utility - Users assign printers to reports
at:
http://allenbrowne.com/AppPrintMgt.html
Assumes Access 2002 or later.

 

[Fredrated]

Works perfectly (I lifted the salient code)!

Thanks again for your expert help.

Fred