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

Steve and Stuart,

Thanks for the help.

Works like a champ!!!

I appreciate the assistance.

Brad



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Thursday, November 15, 2012 4:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.