How to select printer with OpenReport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
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.
 
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........
 
SORRY,SORRY,SORRY Allen
The example in Access97 was exactly what I searched for !!!!!!!!!
Many Tanks !!!!!!!!!!!!!!!!!!!!!!!!
 
Back
Top