Ms access turn off screenupdating
You can increase the speed of some procedures by keeping screen updating turned off. Insert Paragraph After End With If x Mod 50 = 0 Then Active Document. When screen updating is turned off, toolbars remain visible and Word still allows the procedure to display or retrieve information using status bar prompts, input boxes, dialog boxes, and message boxes. The Screen Updating property controls most display changes on the monitor while a procedure is running. Don't forget error handling & turn the screen on before you try to msgbox an error or exit the sub.
There may also be a way to execute a macro from VBA using the Do Cmd method, but I'm not familiar with doing that.
I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.
Ms access turn off screenupdating comments