Print to Default Printer

[bsc0617]

I have an Access 2007 split database. The users have a local copy of the front end on their desktop. The users are located in various buildings and cities. Whenever they print a form (which opens a report), it prints to the printer that I used during development. How can I change it to print to their default printer. I have googled, read and tried to follow the code provided in several posts. I am not very experienced in VBA, so I need lots of detail or the simplest method possible. Any help is appreciated.

[pbaldy]

Check in Page Setup on the Page tab.

[ItsMe]

Sometimes I use VBA to print on a common printer using the printer's name. You might want to check there too and verify you did not hard code a specific printer. Your VBA to print a report to a User's default printer should look like this.

DoCmd.OpenReport "rptSampleReport", acViewNormal

[bsc0617]

Page setup is only going to list printers that I have access to. How will this help the user's local copy?

[bsc0617]

I cannot find anywhere where the printer is hard coded. It defaults to the application printer, which is the printer I used during development. Since the print button goes directly to the printer, the user does not have an option to change the printer. The users are in various locations and cities, and have access to different printers. I was hoping I could include some code on the cmdPrintRecord that would select the default printer instead of the application printer.

[pbaldy]

Page setup is only going to list printers that I have access to. How will this help the user's local copy?

You didn't look, did you? There's a setting for default or specific; you want to make sure it's on default.

[bsc0617]

You are right. I did not look. Thought I knew what I was talking about. How silly of me. Read your post last night and couldn't wait to get to work to try it. You are a genius. I have been struggling with this for days. I have googled, read and tried to dicipher and modify lots and lots of good code from numerous posts and examples, but haven't been very successful. Just learning VBA - as I go. Thanks a million!!!!

[pbaldy]

Happy to help!