Access 97 macro - update query

G

Guest

Hi,
I have created a macro to run a set of queries that I created under the
Queries tab.
My problem is when I run the update queries, It prompts with a dialog box. I
don't want to see this dialog box and I would Access 97 to go ahead and
update by default. Is this possible? I would like to know how to accomplish
this.

thanks
Kanan
 
S

Steve Schapel

Kanan,

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

Stop macro after selecting 'no' 0
How to create new Actions for Macros in Access 2007 1
autoexec macro, dialog box pops up 14
Parameterized queries in macro 1
Microsoft Access can't start the OLE Server 0
Counting multiple memberships 1
macro events 5
macro query cancel causes error 3

Top