Control print from VBA (Access 97)

[Thomas Zimmermann]

Is it possible from VBA to control which printer a report is send to? The
"DoCmd.OpenReport", always sends the job to the standardprinter, but I want
to be able to specify an alternative printer from code.

Any suggestions? Thanks in advance.

[Allen Browne]

At design time, you can specify a printer for the report through:
File | Page Setup | Page

If you need the end user to be able to select one of their printers and
nominate it as the default for the printer, you can do that in Access 2002
and 2003 by assigning a custom property to the report, and setting
Application.Printer before opening the report. There is a downloadable
example of how to do that in:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html

The article also has links to Albert Kallal's solutions for previous
versions of Access (97 and 2000).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Thomas Zimmermann" <thomas@zinformatik> wrote in message
news:42***********************@news.sunsite.dk...

Is it possible from VBA to control which printer a report is send to? The
"DoCmd.OpenReport", always sends the job to the standardprinter, but I
want
to be able to specify an alternative printer from code.

Any suggestions? Thanks in advance.