By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,616 Members | 2,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,616 IT Pros & Developers. It's quick & easy.

choose a printer

100+
P: 158
I've been looking around and found several solutions, but the only one that i have not found yet is where a user presses the "print" button on a form and microsofts Print Dialog Box comes up to choose a printer. Any ideas on how to do this?

Thanks
Matt
Sep 11 '08 #1
Share this Question
Share on Google+
5 Replies


Megalog
Expert 100+
P: 378
Allen Browne has a little add-in for download, that lets a user select which printer he/she wants to use, you can check it out at:
http://allenbrowne.com/AppPrintMgt.html

Or, you can use the native Print box dialog simply by sending the shortcut keys:

Expand|Select|Wrap|Line Numbers
  1. SendKeys "^p"
Sep 11 '08 #2

100+
P: 158
Allen Browne has a little add-in for download, that lets a user select which printer he/she wants to use, you can check it out at:
http://allenbrowne.com/AppPrintMgt.html

Or, you can use the native Print box dialog simply by sending the shortcut keys:

Expand|Select|Wrap|Line Numbers
  1. SendKeys "^p"
I found his solution, but i was wondering if there was anyway to get the print options box to pop up and let the user select the printer that way?
Sep 11 '08 #3

NeoPa
Expert Mod 15k+
P: 31,442
Try using :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.RunCommand(acCmdPrint)
or :
Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunCommand acCmdPrint
Sep 11 '08 #4

100+
P: 158
Try using :
Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunCommand acCmdPrint

Worked like a charm! Thanks NeoPa!
Sep 11 '08 #5

NeoPa
Expert Mod 15k+
P: 31,442
No worries Matt :)
Sep 11 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.