Preventing prompts from appearing with DoCmd

[jerryk]

Hi,

In one of my forms I need to execute the following line to create a temp
table

Docmd.OpenQuery("TestQry)

When this line executes the user recieves a dialog that wants them to
confirm that running the query will update data. Is there any way to
suppress this prompt?

Thanks,

Jerry

 

[ruralguy via AccessMonster.com]

My preference is to use:

CurrentDB.Execute MySQL, dbFailOnError

which will *not* prompt with any warnings.

 

[jerryk]

Thanks you, that worked great!

My preference is to use:

CurrentDB.Execute MySQL, dbFailOnError

which will *not* prompt with any warnings.

 

[ruralguy via AccessMonster.com]

Just for the purist's out there you can also turn of the warnings but then
you loose your error messages as well and not recommended.

Thanks you, that worked great!

My preference is to use:

[quoted text clipped - 16 lines]