How do I immediately call up the printer dialog window when I open an Access report?
Posted on 2008-10-23
I am developing an Access (adp) project as a front end to a SQL Server database.
I have created an Access Report to print a customer order, and I can open this report from the underlying Form containing the customer order.
I have the Report displayed in "Print Preview" mode where the user can then select the printer icon to launch the printer dialog window. I would like to edit the Report's "On Current" procedure so that the printer dialog window is automatically opened when the Report is displayed.
This would make life easier for the operator and hopefully also solve another slight problem. I try to keep the underlying Order Form "modal" so that users don't wander off-track. Unfortunately this prohibits the user from interacting with the Report when it is opened. If I open the Report in "popup" and "modal" modes I can work with the report but lose the printer icon.
How do I call the print dialog window?
Many thanks. Colin.