Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Hinding Print Report Dialog Box

Status
Not open for further replies.

ChiSoxFan

Programmer
Aug 30, 2005
4
US
I've created a VBA function that runs multiple reports and exports them as text files.

However, when each report runs there is a "print" dialog box box that appears and shows what page it is printing (some reports have over 100 pages).

Is there a way to "hide" this dialog box from the user?

I currently have DoCmd.SetWarnings False in a different function. Do I also need it in the same function where the reports are ran? Or is there another setting I need to use for this?

Thanks,
ChiSoxFan
 
You could just turn off screen updates altogether...

Code:
Application.Echo False

Just whatever you do don't forget to turn it back on, especially in your error handler and end of the procedure.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top