Turn of question from Access when running append queries in a macr

S

sverre

Hello
When running append queries in a macro, Access asks you for each query if
you want to append x no of rows. Can you turn this feature off to make Access
run all append queries without any interuption?

Best regards
Sverre
 
S

Steve Schapel

Sverre,

Put a SetWarnings/No action in your macro, before the first of the
OpenQuery actions.
 

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 Queries in a Macro 6
Append query in macro get key violation - by itself no problem 3
Append Query Issue 0
Not prompted when running append/make-table queries? 8
Running a series of Action Queries 1
Problems with action queries in a macro group 5
Turning off action query confirmation messages 1
Automatic acceptance of append querry in macro 2

Top