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.Everyone I have talked to has advised me to avoid using macros when possible.Please can you explain and how users can overcome this issue.Hi all, I have a macro that executes ~200 queries which modify the data, create some tables etc.
I know this is possible in Excel by setting application.screenupdating =false, is there a similar way in Access?
The macro runs when the user clicks a button on a form.
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.
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.
So, I prefer Open Query action rather than Run SQL action.
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.