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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Msg: You are about to append..... 5
Get rid of "You are about to delete 1 row(s) from..." message 5
getting rid of warning dialog 4
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Getting rid of "You are about to append..." in DoCmd.RunSQL 3
How do I get rid of... "You are about to update 1 row(s)" 4
Need VBA Help to Append! 12
You are about to append X row(s) 2

Back
Top