mute macro

[souris]

I have an AutoExec macro to download data when user open the database.
Because the macro append data to my local table, it always give user warning
message while open.
Is it possible that I set mute macro which may run the macro without popup
message box?

Any information is great appreciated.

Souris,

 

[Steve Schapel]

Souris,

Put a SetWarnings/No action in your macro before the action (presuably
OpenQuery) that does the Append.

 

[souris]

Thanks millions,

Souris,

Souris,

Put a SetWarnings/No action in your macro before the action (presuably
OpenQuery) that does the Append.