Access - Set warnings set to no - not working

I have a database - where i have setwarnings macro as 'no' - but I am still receiving pop-ups.

Therefore, when I re-run queries with pre-existing tables - I get the pop-ups "Are you sure you want to replace."

Please advise why this is not working.

Thank you.
exp vgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
uncheck  action Queries check box

office button > access Options > Advanced > Editing   --- look for CONFIRM
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
exp vgAuthor Commented:
Thanks Rey - where is the action Queries check box.
0
Dale FyeCommented:
Personally, I cannot think of a good reason for using the docmd.SetWarnings method.  This method is fraught with potential for catastrophie and should be avoided if at all possible.

Instead of using that method to hide warnings associated with Delete, Append, and Update queries, I would strongly recommend that you adopt the database, and querydef Execute methods.

Currentdb.Execute strSQL, dbfailOnError    ' used for action queries
currentdb.Querydef("queryName").Execute dbfailonerror

The 'dbFailOnError' option used with the execute method will cause an error to be raised if the action query fails for any reason, which you can then trap in your error handling routine.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rey Obrero (Capricorn1)Commented:
@exp vg,


what version of access are you using?

here is the image for A2010

x
0
Rey Obrero (Capricorn1)Commented:
you can set by clicking on

File > Options > Client Settings
0
Dale FyeCommented:
Although you can do what Rey is recommending, I strongly recommend against that as well.  When running queries manually, it is advantageous to have the warnings popup, just in case you got your where clause wrong and are about to delete or update 100's of records instead of 5 or 10.
0
exp vgAuthor Commented:
Thank you both. At this point - I have tested and automated the database as much as possible - so just need to ensure that the pop-ups do not appear.

Let me please give this a try and get back to you.
0
exp vgAuthor Commented:
Here is an update - my Action Queries was already unchecked.

When I click on the Office Button (I take this is the button at the bottom left of the screen) - I do not see Access options to complete this step.

The issue I am having is that when I run the database with all included Queries and Macros without flaw or error, the pop-ups do not arise.

However, if there is one mis-step (i.e mis-labeled data source, etc.) and the database operations are stopped pre-maturely, when I try to relaunch the database again, I get the pop-ups "The table X will be replaced" Yes/No, etc.

Is there a way to suppress the pop-ups after database operational completion has been disrupted, and I have to restart?

Thank you.
0
Rey Obrero (Capricorn1)Commented:
"Access options "  is at the lower right corner  of the Menu beside Exit Access
0
exp vgAuthor Commented:
Then I have it - I have gone to Access Options - Client Settings - Confirm - unchecked Action Queries.

However, the pop-ups still appear if the database operations is disrupted.

Please advise.
0
Rey Obrero (Capricorn1)Commented:
I can't certainly know what causing the pop-ups without seeing your db.

just make sure that if you set the warning message in vba

docmd.setwarnings 0

' run your codes here

'set the warning back to true
docmd.setwarnings -1
0
exp vgAuthor Commented:
Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.