How to Macro (Query) in Silent Mode

  • Thread starter Thread starter Tom Lorenz
  • Start date Start date
T

Tom Lorenz

I have a make table query that I want to run un-attended.
The query prompts for an "YES" to overwrite the existing
file. Is there anyway to not be prompted for the
overwrite?
 
Just before you run the maketable query step, put in this step:

Action: SetWarnings
Expression: No

Then after the maketable query step:

Action: SetWarnings
Expression: Yes
 
-----Original Message-----
Just before you run the maketable query step, put in this step:

Action: SetWarnings
Expression: No

Then after the maketable query step:

Action: SetWarnings
Expression: Yes


--
Ken Snell
<MS ACCESS MVP>




.
Ken,
Click to expand...
Thanks for the information, it worked great!
 
Back
Top