-
Run Query without prompts
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules