Eliminate Prompts

M

meyerryang

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
 
S

SteveM

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
 
M

meyerryang

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

Append Crosstab Query to Existing Table 0
Get rid of Microsoft AutoUpdate 0
Disable Access Update Records warning 2
Not prompted when running append/make-table queries? 8
Query Prompting for Info that it shouldn't be 3
ASK Field Formatting 1
Office 10 Crosstab query with Parameters 0
Error on Access Query 10

Top