Print Dialog Window

[DAN]

Does anyone know how to make the print dialog window
appear through scripting rather than to just send the
report to the default printer? Thanks.

 

[Allen Browne]

Try:
DoCmd.OpenReport "MyReport", acViewPreview
DoCmd.RunCommand acCmdPrint

 

[SA]

Dan:

If you don't want to preview the report first, then you have to use Windows
api calls. Allen has posted how to do it when previewing. If you need the
other approach, then you might take a look at our "On the Fly Printing"
classes that are on our web.

HTH

 

[Dan]

Cool, thanks for the help.

-----Original Message-----
Try:
DoCmd.OpenReport "MyReport", acViewPreview
DoCmd.RunCommand acCmdPrint


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.