Getting rid of confirmation "You are about to append 1 row" MS Access SQL

K

Kassimu

Joined
May 24, 2008
Messages
6
Reaction score
0
I am inserting new row on the table using the following code

Dim strSqlUpdate1 As String
strSqlUpdate1 = "INSERT INTO [Daily Fault Update]([Time Recorded], [Reason and Correction]) VALUES (Now()), 'Fault resolved on ' & [Forms]![TXFaults]![Date_Resolved] & 'Resolution being - ' & [Forms]![TXFaults]![Resolution] )"
DoCmd.RunSQL strSqlUpdate1

The code works fine exept this popup message saying "You are about to append 1 row(s). Once you click yes, you can't use the undo command to reverse changes... Are you sure.."

Is there anyway to disable this message?
 
Back
Top