I wrote a code to call a module on the button click in Access form and when I click on d button, i recieve d following alerts:
"You won't be able to undo the changes this action query is about to make to the data in a linked table or tables"
and
"You are about to update X row(s)".
The code behind the button is:
Private Sub UpdateRS_Click()
Call UpdateModul.Update
End Sub
And module is:
Public Function Update()
DoCmd.RunSQL "Update tbl03 INNER JOIN tblMaster " & _
"ON tbl03.KW = tblOnd_RS.KW " & _
"SET tbl03.CAp = [tblMaster].[CAp] "
End Function
How to avoid these alert messages? I appreciate any help.
See http://www.fmsinc.com/microsoftaccess/query/action-queries/SuppressWarningMessages.htm and http://www.utteraccess.com/wiki/index.php/RunSQL_vs_Execute .
You could use
but this has multiple problems, e.g. an error could prevent
DoCmd.SetWarnings True
from running, which then could lead to disaster.Much better is: