Eliminate Prompts

G

Guest

How do I eliminate the prompts if I am running a series of queries? Prompts
such as "Would you like to append table?" Yes/No

Thanks in advance
 
G

Guest

How are you running the queries, VBA or Macro?

In VBA:
DoCmd.SetWarnings False 'turn warnings off
'Run queries
DoCmd.SetWarnings True ' turn warnings on

Always turn them back on when you are done!

Steve
 
G

Guest

Perfect!

SteveM said:
How are you running the queries, VBA or Macro?

In VBA:
DoCmd.SetWarnings False 'turn warnings off
'Run queries
DoCmd.SetWarnings True ' turn warnings on

Always turn them back on when you are done!

Steve
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SendKeys in Macro 2
Is It Possible to Control Access Warning Pop-Up Message Boxes? 6
Suppress msg from update query 5
Access 2007 can Add Database to SourceSafe 4
Create Table Auto Answer 2
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Query Prompting for Info that it shouldn't be 3
Java Security Prompts 4

Top