Redirecting a Printer

[DS]

When you go to print a report and the printer is off-line, how do you
tell Access to print to another printer?
Thanks
DS

 

[Roger Carlson]

Look here:
http://www.mvps.org/access/reports/rpt0009.htm

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

There is an answer given by Allen Browne in a previous post:

Use a name that matches the one in the Printers collection, e.g.:
? Application.Printers(1).DeviceName

If that returns:
HP DeskJet 930C/932C/935C
you would use:
Application.Printer = Application.Printers(1)
or
Application.Printer = Application.Printers("HP DeskJet 930C/932C/935C")

For a downloadable example of using those objects, see:
Printer Selection Utility
at:
http://members.iinet.net.au/~allenbrowne/AppPrintMgt.html

 

[DS]

Look here:
http://www.mvps.org/access/reports/rpt0009.htm

Thanks, I see how to change the printer but how do you tell Access, or
how does Access know whether the printer printed the report or if the
printer is off-line (or Broken)?
Thanks
DS

 

[DS]

There is an answer given by Allen Browne in a previous post:

Use a name that matches the one in the Printers collection, e.g.:
? Application.Printers(1).DeviceName

If that returns:
HP DeskJet 930C/932C/935C
you would use:
Application.Printer = Application.Printers(1)
or
Application.Printer = Application.Printers("HP DeskJet 930C/932C/935C")

For a downloadable example of using those objects, see:
Printer Selection Utility
at:
http://members.iinet.net.au/~allenbrowne/AppPrintMgt.html

Yeah, I know how to redirect the printer, but I don't know how to let
Access know that the report didn't print because the printer is either
broke or off-line.
Thanks
DS