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
Not prompted when running append/make-table queries? 8
Append query in macro get key violation - by itself no problem 3
Turning off action query confirmation messages 1
running queries from a macro 4
Invalid Argument - Append Query 1
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO 30
Parameterized queries in macro 1

Top