Selecting printer from code

[Sophie]

hi

I have buttons on my forms that cause various reports to be printed. But,
some of the reports are to be printed on one printer, and some on another
printer. Both are connected to the computer. How do I do this? It guess
it would be OK for the code to pull up the Print window, but I'd like it best
if the code can actually select the correct printer. (Lexmark E330 or Canon
i550)

Any clues appreciated.

 

[John]

You can have two reports, one set to print to one specific printer, the other
(duplicate) report set to print to the second printer. But, then you have to
maintain two copies of reports.

For a utility, take a look here:

http://allenbrowne.com/AppPrintMgt.html

John

 

[Stuart McCall]

hi

I have buttons on my forms that cause various reports to be printed. But,
some of the reports are to be printed on one printer, and some on another
printer. Both are connected to the computer. How do I do this? It
guess
it would be OK for the code to pull up the Print window, but I'd like it
best
if the code can actually select the correct printer. (Lexmark E330 or
Canon
i550)

Any clues appreciated.

Open your report in design view, then drop down the File Menu and choose
Page Setup. On the Page tab, choose a printer. This setting is saved with
the report, so next time it's opened, the printer will be ready-configured.