Report as object

  • Thread starter Thread starter Fredrated
  • Start date Start date
F

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
 
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.
 
Works perfectly (I lifted the salient code)!

Thanks again for your expert help.

Fred
 
Back
Top