Link to home
Start Free TrialLog in
Avatar of SweetingA
SweetingA

asked on

Set printer to unanmed default printer in access vba

Is it possible on a button click to ensure the printer used is always the one selected as default in the windows settings?

This may vary from computer to computer so i would like to avoid naming the printer, instead taking the name out of the windows defaults.

Using Access 2002-2012.

Thanks in advance.
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

To handle this I set my reports to use the default printer and have never had an issue. The key is to compile the front end into a MDE/ACCDE. This way any printer changes made by the user will not get saved.

Also see:
http://office.microsoft.com/en-us/access-help/changing-printer-settings-for-a-report-in-access-HA001034553.aspx

http://allenbrowne.com/AppPrintMgt.html
Avatar of SweetingA
SweetingA

ASKER

I understand that i can set the printer but i want the vba code to seek out the name of the listed default printer on whichever computer the user logs onto.

Regards
ASKER CERTIFIED SOLUTION
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial