Removing prompts

[Mary]

I have unchecked the Action Queries box under Tools, Options, Edit/Find,
Confirm.
The other two boxes in that area are also unchecked; however, I'm still
getting prompted during a Macro when Access is about to replace an existing
table. How do I eliminate the prompts during the Macro?
Thank you in advance.

 

[Al Campagna]

Mary,
Add a SetWarnings No before the action query runs, and a SetWarnings Yes afterwards.

 

[Mary]

Where is this process performed?
Thanks,
mary

Mary,
Add a SetWarnings No before the action query runs, and a SetWarnings Yes afterwards.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Al Campagna]

Mary,
You wrote

How do I eliminate the prompts during the Macro?

A Macro can contain any number of commands.

You said you had a macro that replaces a table, so place the
SetWarnings No before the macro command that runs the replace table, or whatever you
used...
and a SetWarnings No after it.