atreidies
asked on
Action Query Notifications
After turning off confirmation for "Record Changes", Document Deletions" and "Action Queries" in the Edit Find tab under options, when running make-table, update and append queries you still get pop-ups to answer yes/no to. CAn these pop-ups go away as well? I want to run these types of queries without having to answer "Yes" i actually want to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you can use an ADODB connection and .Execute the command. You won't see the warnings that way, either.
ASKER
i added that to the OnActivate event for the form is there a way to set it to False for the entire application
Once you set
DoCmd.SetWarnings False
it stays that way until to set it back to true.
The potential problem with leaving it set to False is that errors you'd like to know about don't display either -- adds or updates that fail.
Dim con As New ADODB.Connection
With con
.Open CurrentProject.Connection
.Execute "delete from table1 where ID=6" => no warnings here, but you will get messages if the statement fails
.Close
End With
Set con = Nothing
DoCmd.SetWarnings False
it stays that way until to set it back to true.
The potential problem with leaving it set to False is that errors you'd like to know about don't display either -- adds or updates that fail.
Dim con As New ADODB.Connection
With con
.Open CurrentProject.Connection
.Execute "delete from table1 where ID=6" => no warnings here, but you will get messages if the statement fails
.Close
End With
Set con = Nothing