Change Default Printer in Windows/Office Xp (using DefaultPRT.ZIP)

[karmahum]

Hello all.

I apologize in advance if this has been addressed elsewhere, but I have been unable to find a solution.

I have been using the DefaultPRT.ZIP modules and code successfully in an Access database (2000) under a WINNT environment for a couple of years to allow the user to change printers (i.e Print to PDF).

However, a recent upgrade to Windows XP appears to have resulted in the code no longer working. I am not in need of code to bypass the Save As dialog box as I am fine with the user having to input a name and location. However, the code does not appear to work to change the default printer any longer.

Any ideas would be greatly appreciated.

Thanks,
Sean

 

[ghudson]

This command will open the print dialog...

DoCmd.RunCommand acCmdPrint

Ensure that you trap for error # 2501 [if the user clicks the Cancel button].

You can not test that command from within a module.

 

[karmahum]

Thanks.

However, I was really hoping to avoid using the print dialog.

I have found post that indicate that their is a correction to the code that needs to be made under Windows XP, however, I have not been able to find the correction.

Any one have a idea?

Thanks again.

 

[freakazeud]

Hi,
how about taking a look here: http://office.microsoft.com/en-us/assistance/HA010345531033.aspx

HTH
Good luck

 

[jonomac]

Or here for my cut down version requring only a list box on a form...

http://www.access-programmers.co.uk/forums/showthread.php?t=89632