jtr209
asked on
Acces "Run Query" Macro
I would like to create a macro or some sort of VBA which will allow me to run a series of queries within an access DB.
The goal being to start the process then be able to walk away from my machine while the queries run in sequence.
Is there a somewhat simple way of accomplishing this?
Thank you for your help.
The goal being to start the process then be able to walk away from my machine while the queries run in sequence.
Is there a somewhat simple way of accomplishing this?
Thank you for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<No Points wanted>
But Please note what armchair_scouse states:
"in case one of your queries has a problem, or using query transactions, which allow multiple changes to be rolled back if any of the separate queries fail. "
...This is almost inevitable when a "Series" of queries is run.
But Please note what armchair_scouse states:
"in case one of your queries has a problem, or using query transactions, which allow multiple changes to be rolled back if any of the separate queries fail. "
...This is almost inevitable when a "Series" of queries is run.
ASKER
Thank You
docmd.setwarnings false
.
.
.
docmd.setwarnings true
That way the process won't stop waiting for your response.
Scott C