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..

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

Thanks JYA for showing me the link.

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

Once again thankyou all

Thanks JYA for showing me the link.

DoCmd.SetWarnings(WarningsOn) for earlier versions

Dear gailoni,

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

Thanks