Automating Selecting Printers for Report

  • Thread starter Thread starter Tarpon_Zeke
  • Start date Start date
T

Tarpon_Zeke

I have a report that several people will use. It has to
be printed on a 4 part form on a dot matrix printer.

The problem is that everyone has their own dot matrix and
it is not their default printer.

I would like to either ask them on the report pre screen
which printer they would like to go to and have it preview
to that printer

OR

A second reasonably acceptable solution would be to have
the report preview to the screen and have the file print
(CTRL-P) window show up on automatically so they can
select the printer from there. I tried the send keys
after I opened the report and that didn't seem to work.

Any ideas would be greatly appreciated.

PZ
 
Zeke:

Docmd.Runcommand acCmdPrint

will bring up the print dialog as it relates to the currently selected
object in the db window or currently previewed report or form.

If you want a little more flexibility you might take a look at our "On the
Fly Printing" classes, which you can use to run your printer selection set
up program or pop the print dialog from forms and output closed reports.

HTH
 
Back
Top