Disabling query warnings

[Tom123]

Hello,



I would like to disable the query warnings when I run append, create table and delete queries. It needs to be disables for the sheet, not just for my copy of access, because other people will be using the database.


Tom

[June7]

This can be done if you run queries in code (macro or VBA) but not if you run them from the navigation pane.

DoCmd.SetWarnings = False
...
DoCmd.SetWarnings = True

or use:

CurrentDb.Execute "DELETE FROM tablename"

[Tom123]

I am not sure how to do that. I'm running a bunch of queries in a macro but I dont know where to put that DoCmd thing.

[June7]

I showed VBA. The SetWarnings can be done in macro. Set False before running the queries and then set True afterward.

Why are you running create table queries?

[Tom123]

I cannot find SetWarnings. Is it supposed to be in the Add New Action drop down? Because if so Its not there.

[June7]

Click the Show All Actions button on the Macro Tools ribbon Design tab.

[ssanfu]

I can't look at A2010 right now, but in A2000 you can turn off warnings for record changes, document deletions and action queries.

OPTIONS
Edit/Find tab
There is an outline "Confirm" that has check boxes for record changes, document deletions and action queries.

Access should have the same options in the backstage(??)... (FILE / Options / ....)
*** use at your own risk. ***

[June7]

Found under File > Options > Client Settings. This is an application setting that would have to be done for each user's install of Access and will affect all databases they open.

[ssanfu]

I didn't say it was a GOOD option .... just that it is available..

And I wouldn't/don't use it.....