Run Query without prompts

[gailoni]

I have code that executes three quueries(created table query, update query and append query). The code is working fine executing the queries however I want to do away with the prompts.

Eg. When I run the created table query I am rpompted to confirm that the existing table will be deleted & a new one created.

How can I do away with this prompts and just execute the queries without the prompts??



Please help me on this..

[jya]

Below is a link I came across on another forum. I think you can also uncheck a confirm setting, but I don't recall where you find it with older Access versions.

http://www.access-programmers.co.uk/...able+prompting

[gailoni]

Thanks JYA for showing me the link.

DoCmd.Setwarnings (WarningsOn) for earlier versions of Access.

Once again thankyou all

[gailoni]

Thanks JYA for showing me the link.

DoCmd.SetWarnings(WarningsOn) for earlier versions

[Ahmed Elalfy]

Dear gailoni,

You can also do the following steps:
Tools --> Options --> Edit/Find -- > remove check box in (Confirm .. Action queries)

Thanks