Re: Preventing prompts from appearing with DoCmd

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks you, that worked great!

"ruralguy via AccessMonster.com" <u12102@uwe> wrote in message
news:64dec0f9bc731@xxxxxx
My preference is to use:

CurrentDB.Execute MySQL, dbFailOnError

which will *not* prompt with any warnings.

jerryk wrote:
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

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com



.

Relevant Pages

  • Re: Preventing prompts from appearing with DoCmd
    ... which will *not* prompt with any warnings. ... jerryk wrote: ... In one of my forms I need to execute the following line to create a temp ...
    (microsoft.public.access.formscoding)
  • Re: disable double clicking attachments
    ... Double click a file and the app opens. ... There's no prompt to save it before the default action takes place. ... It does once you flag their attachment directory as deny execute. ...
    (microsoft.public.outlook.general)
  • Re: MAT files : MATLAB COMPILER
    ... Install MCR Utility on your machine to run the executable. ... Double click the TEST.exe file to execute it. ... METHOD 2 - Using Command Prompt ...
    (comp.soft-sys.matlab)
  • Re: How to schedule URL?
    ... Windows XP Shell/User ... "Brett" wrote in message ... This scheduled task will not execute with out the ... The directory is password protected, which results in a login prompt. ...
    (microsoft.public.windowsxp.general)
  • Re: How to schedule URL?
    ... This scheduled task will not execute with out the ... The directory is password protected, which results in a login prompt. ... Windows XP Shell/User ... "Brett" wrote in message ...
    (microsoft.public.windowsxp.general)