Brad Marks
BradM at blackforestltd.com
Thu Nov 15 15:23:17 CST 2012
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