pop up msg: table to delete...

[dastr]

Hi all,

I have created that macro in access but seem that cannot get rid of the pop up messages saying: “The existing table will be deleted…” where one needs to answer with yes and no.

I see it is a popular topic in the forums, but is it possible to include a query or so, maybe at the beginning of my macro, that would make it skip all these pop-ups?

Any help will be appreciated,
Thanks in advance.

 

[PaulO]

What I do is use the 'Setwarnings' command and set to 'No' at the beginning of the Macro and reset to 'Yes' at the end of the Macro.

That said, I'm not sure whether that command exists beyond Access 2003 versions?

 

[Sum1elsz]

I have an Access 2010 database using an AutoExec macro to update my tables using the task scheduler to open the database. I've navigated to File/Options/Client Settings and unchecked the boxes in the Confirm section (Record changes, Document deletions, Action queries) in order to turn off the pop up message boxes.