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

Select Printer When Using "Printout" Method

P: n/a
I'm using the following line of code to print only the first page of a
report:

DoCmd.PrintOut acPages, 1, 1

This works fine with one limitation. It sends the report to the default
printer. Is there some way to show the printer selection window before
sending the report to the printer?

Any help is appreciated.

Apr 4 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Wayne wrote:
I'm using the following line of code to print only the first page of a
report:

DoCmd.PrintOut acPages, 1, 1

This works fine with one limitation. It sends the report to the default
printer. Is there some way to show the printer selection window before
sending the report to the printer?

Any help is appreciated.

Albert Kallal has a nice program at his web site for getting/setting the
(default) printers. I think with a slight enhancement to his program
you could do what you want.

With his method (and your enhancement), you get the printer list, parse
out the list and then select from a list box, set the default printer to
that printer, print the report, then reset back to the original default
printer.
Apr 5 '06 #2

P: n/a
Thanks Salad. I'll have a look at it.

Apr 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.