[AccessD] Is There a Way to Invoke the Windows "Print Dialogue" from VBA code?

Private Sub cmdRequeryAndPrint_Click()
DoCmd.Requery
DoCmd.RunCommand acCmdPrint
End Sub


On 15 Nov 2012 at 15:23, Brad Marks wrote:

> All,
> 
> We have a small report (1-5 pages) that is printed very frequently.
> 
> The primary user has two monitors.  She has a purchased application
> system shown on one monitor for data entry.
> 
> She uses the second monitor to view the small report  (built with Access
> 2007).  This works nicely.
> 
> The Access report has a button to "Refresh" the data (DoCmd.Requery).
> This also works nicely.
> 
> Every once in a while, the user will change the data in the purchased
> application system and forget to push the refresh button on the Access
> report.  When this happens, the data shown on the printed report is not
> up to date.
> 
> Currently, to print the report, the Windows "Print Dialogue" is invoked
> from the "Big Round Button" (top left).  This dialogue gives the user
> the ability to print multiple copies and/or to print select pages.  
> 
> I would like to add a button to the report to (1) refresh the data (2)
> invoke the Windows Print Dialogue.
> 
> Is there a way to do this with VBA code?
> 
> Thanks,
> Brad
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>