Remove modal popups in make-table query (1 Viewer)

[jewels]

I need to be able to run a number of queries where some of the queries are make-table queries. What I don't want is to have is all the messages that come up during the creation of the table ie deleting existing files and showing the number of records created to place in the file. Is there a way to block these messages?

 

[Sergeant]

Use
DoCmd.SetWarnings False
...code...
DoCmd.SetWarnings True

You should have error intervention that will turn the warnings back on.

CmdBtn_Click_Error:
DoCmd.SetWarnings True
...deal with error...
Exit Sub

 

[RuralGuy]

Hi jewels,
Use CurrentDB.Execute YourSQL, dbFailOnError and you do not get all of the warnings but you will get errors for your error handler if any occur.

 

[jewels]

thanks

Thanks for your help. Thats works well.

 

[RuralGuy]

Glad to help!