Change Default Printer in Access 97/2000

[Leo Mansi]

I am creating a database to print different documents. When going to print
I would like it to do 3 things:

1. Record what the current default printer is.
2. Change the default printer to a specific printer.
3. When finished printing, change the default printer back to what it
originally was.

If anyone could provide code to change the default printer and find out what
the current default printer is, I would appreciate it.

Leo Mansi

 

[Jeff Conrad]

I have not tried this myself yet, but see if this information by Allen Browne helps.
There is also a link for a 97 and 2000 solution by Albert Kallal.

http://members.iinet.net.au/~allenbrowne/AppPrintMgt.html

 

[Leo Mansi]

Jeff,

The Albert Kallal solution worked! Thanks!

It works perfectly on a Windows 98 machine. On a Windows XP machine, it
sets the chosen printer as the default printer, but does not dsplay the
checkmark on the printer icon. I can live with that.

Thanks again,

Leo

 

[Jeff Conrad]

Excellent, glad to help.
Albert and Allen deserve the real thanks though.