Macro turn off screenupdating

Rated 4.90/5 based on 722 customer reviews

One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.

What method (action) are you using to execute your queries in the macro? I use the following Macro Options: Action: Open Query View: Datasheet Data Mode: Edit I would like to have each query saved with a different query name, so that I can modify them easily.Ed Sorry, looks like it's as simple as Application. Here is a clip from a good help page by Tony D'Ambra.The url is Ed : Resize Form Controls You can use the Inside Height and Inside Width properties of an Access form to dynamically resize controls at run-time.What method (action) are you using to execute your queries in the macro?[/size][/font] Try the following steps and let me know what happens: If it does not do the trick in a macro setting, I will show you how to accomplish it with just a few lines of VBA code. Before running your macro, make sure that the checkbox for confirming action queries is unchecked. Modify your macro to sandwich the Open Query action between the Set Warnings On = No and Set Warnings On = Yes actions as shown.

Leave a Reply