Preventing prompts from appearing with DoCmd

  • Thread starter Thread starter jerryk
  • Start date Start date
J

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
 
My preference is to use:

CurrentDB.Execute MySQL, dbFailOnError

which will *not* prompt with any warnings.
 
Thanks you, that worked great!

ruralguy via AccessMonster.com said:
My preference is to use:

CurrentDB.Execute MySQL, dbFailOnError

which will *not* prompt with any warnings.
Click to expand...
 
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:
Click to expand...
[quoted text clipped - 16 lines]
Click to expand...
 
Back
Top