Directing to a non default printer

[Dan Graff]

Every time I attempt to print to a printer other than the
system default printer the redirection fails an the report
prints on the system printer. This is true even though I
use file/page setup/page/use specific printer. It still
prints to the system default printer.

We are attempting to utilize a second - non default
printer for special invoice paper.

How can I get this to work

 

[Albert D. Kallal]

I would first try brining up the report in preview mode, and then
file->print and then select the given printer. See if that works.

You also don't mention what version of ms-access. access 2002 and later
includes a printer object that will easily change the printer in code.

Further, you should be able to bring up the report in design mode, and in
page setup simply "save" the current printer to this report. At that point,
ms-access SHOULD ignore the default printer, and ALWAYS print to what ever
printer you saved with the report.

There is a NUMBER of bugs associated a2000 and it NOT keeping its printer
settings/layout. So, I would installed the office updates and service packs
if you are running a2000.

If you need some light weight code for a97, or a2000, then check out the
printer switch code at my site.

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

I have not tested the above code in a2002 and later...but then again...you
don't need it as printer switch control is now included.