setwarnings in a macro for access 2007

[Sofa King]

Is there an equivalent to SetWarnings in Access 2007 Macro's as in 2003?

 

[Steve Schapel]

Sofa,

It sounds like you need to click the 'Show All Actions' button on the
macro design ribbon.

 

[Rachael]

I am having the same problem, but clicking on the 'Show All Actions' button
changes nothing. I assume another field should appear in the Action Arguments
section, but nothing happens when the 'Show All Action' button is selected.

This file is in a trusted location, so I'm not sure what the problem is. Any
ideas?

Thanks,
Rachael

 

[Steve Schapel]

Rachael,

Can you please say more specifically what the problem is? An example?

 

[Rachael]

I have a database that was created in Access 2000. I am now working on it in
Access 2007. The database is in a trusted location.

I created a macro that runs a series of simple update queries. When each
query opens, I am prompted to allow the query to update data in the table - I
click "YES." I am then prompted to allow the query to update however the
number of rows the update applies to - I click "YES." This continues for each
query in the macro.

The only action arguments are Query Name, View and Data Mode. There is
nothing about the Set Warning. When I select Show All Actions in the Design
tool bar, nothing happens. I want this macro to run the queries without
prompting me for each one.

What am I missing?

 

[Steve Schapel]

Rachael,

You need to enter a SetWarnings/No *action* in the macro, prior to the
first OpenQuery action.

 

[Rachael]

Okay, color my face several shades of red! I tried to do this at the
beginning, and I must have overlooked the setwarnings action in the list,
because I didn't see it and thought it was no longer set here in the 2007
version of Access.

Thanks for setting me straight. Have a great week!