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

Button In Form Which Allow To Select The Printers Available At Ur Pc

100+
P: 101
Hi,
I know this is the simple problem for experts so i will get reply quickly.
I have project in MS Access.
In that I have a form in which I want to put the button.
When we click on this button it will show me the the same window as when we click on print in file menu.
So when that window appear I can select any printer available on my PC.
Thanks
Dec 13 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,392
You'll want to take a look at the Application.Printers collection.
Dec 13 '07 #2

100+
P: 101
Ya its like that whenever i click on that button it will show me new small pop up window like when we click on print in file menu or press CTRL+P.So from that popup window i can select any printer so i have more option instead of i have to print on default printer.
Thanks for ur reply.
Dec 13 '07 #3

Rabbit
Expert Mod 10K+
P: 12,392
Right, the application.printers collection holds all the information on the printers for that computer.
Dec 13 '07 #4

100+
P: 101
I generate the list for printers but after selecting one from list then i have to click on button.
So i want to know what code i have to put on click event of button.
Dec 13 '07 #5

Rabbit
Expert Mod 10K+
P: 12,392
To set the printer you use
Expand|Select|Wrap|Line Numbers
  1. Set Application.Printer = Application.Printers(Index)
  2.  
Dec 13 '07 #6

Post your reply

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