Access 97 macro - update query

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Kanan,

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