How to select printer with OpenReport

M

Massive850

As known if I use from within a form the command:
Docmd.Openreport "xxx",acviewnormal
the report uses the default printer for print out.OK.
But what if I want to select a specific printer and then print the report
imediatelly to this printer without opening the report first ???
It is very important for me (exm...my application) to print to a specific
printer without previewing the report first.
Is there a possible way ??????
Many Thanks in advance.....
 
A

Allen Browne

If you are using Access 2002 or 2003, you can set the Application.Printer to
the one you wish to use (from the Printers collection), and then
OpenReport(). There is an example of this technique, including getting the
report to remember to use that printer again next time, in this article:
http://allenbrowne.com/AppPrintMgt.html

The article also has links for older versions of Access.
 
M

Massive850

Thank you very much.
I tested the given example and it works fine BUT it assumes that the Report
is already open in preview mode.
I want to select a printer before prewieving the Report........
 
M

Massive850

SORRY,SORRY,SORRY Allen
The example in Access97 was exactly what I searched for !!!!!!!!!
Many Tanks !!!!!!!!!!!!!!!!!!!!!!!!
 
Top