Eliminate the memory prompts when running queries

[John P]

My Access DB consists of many queries that are combined in one macro. When I run the macro I am prompted that the script will change the DB, memory, etc...which means I am prompted about 25 times just so I can click Yes. I understand that these prompts can relay important information if a problem exists, but if I am confident (or at least can live with an error) that I want to click yes for the prompts associates with the specific macro, is there a way to have the macro select YES??

Any suggestions are greatly appreciated.

John

 

[Joe4]

Set up a macro to run your query, and use the SetWarnings command = False to suppress those messages.

I.e.
1st Action: Set Warnings to False
2nd Action: OpenQuery
3rd Action: Set Warnings to True

Now, just use this macro to open the query.

 

[John P]

Thanks..that solved the problem....I love easy solutions.