Hello,
Hows it going people....so...its this annoying msg:
Data has been changed
Another user changed record and saved them before you.
Re-edit the record
"Another user" is me clicking the button that updates all records at once. Next thing i do is try update indivisual records (everything through the same form on the same table) and i get this msg...i can hit okay and continue no problem...but i need this annoying popup to go away...how?
both updates act on same records, i need someway to tell the first one that its done and now go away..lol...how do i do this?
All of the operations performed use SQL statements. code:
-
-
Private Sub cmdEdit_Click()
-
DoCmd.RunSQL "UPDATE tMainDiscount " _
-
& "SET [Discount Level] = " & strDisc _
-
& ", [Date Revised] = #" & dateTime & "#" _
-
& " WHERE [Customer Number] = " & longCust _
-
& ";"
-
End Sub
-
-
-
AFTER RUNNING THIS CODE ^ and then moving
-
onto the one below is the only time i get the msg.
-
both act on same records...
-
-
-
Private Sub cmdDiscount_Click()
-
-
'UPDATE DISCOUNT LEVEL
-
CurrentDb.Execute "UPDATE tMainDiscount " _
-
& "SET [Discount Level] = " & strDisc _
-
& " WHERE [Customer Number] = " & longCust _
-
& " And [PGR] = '" & strPGR & "'" _
-
& ";"
-
-
'TIME STAMP FOR THE UPDATE
-
DoCmd.RunSQL "UPDATE tMainDiscount " _
-
& "SET [Date Revised] = #" & dateTime & "#" _
-
& " WHERE [Customer Number] = " & longCust _
-
& " And [PGR] = '" & strPGR & "'" _
-
& ";"
-
-
-
DoCmd.Requery "lstPGR"
-
End Sub
thanks
