Save Error

[srmezick]

I added a code to one my database forms that prompts users to confirm they wish to save thier changes. However, after adding the code we are now receiving a message that prevents us from saving the changes if another user has an object open that is also connected to a table that is affected by the changes. Is there a way to fix that issue? ( The next time I see the message will update with exactly what the message says.)

[Toyman]

I added a code to one my database forms that prompts users to confirm they wish to save thier changes. However, after adding the code we are now receiving a message that prevents us from saving the changes if another user has an object open that is also connected to a table that is affected by the changes. Is there a way to fix that issue? ( The next time I see the message will update with exactly what the message says.)

Post the code you are using to save the record. I am assuming that this is an unbound form?

[srmezick]

Private Sub Form_BeforeUpdate(Cancel As Integer)
'Provide the user with the option to save/undo
'changes made to the record in the form
If MsgBox("Changes have been made to this record." _
& vbCrLf & vbCrLf & "Do you want to save these changes?" _
, vbYesNo, "Changes Made...") = vbYes Then
DoCmd.Save
Else
DoCmd.RunCommand acCmdUndo
End If
End Sub



I dont know the difference in bound and unbound forms lol <.<

[Toyman]

Private Sub Form_BeforeUpdate(Cancel As Integer)
'Provide the user with the option to save/undo
'changes made to the record in the form
If MsgBox("Changes have been made to this record." _
& vbCrLf & vbCrLf & "Do you want to save these changes?" _
, vbYesNo, "Changes Made...") = vbYes Then
DoCmd.Save
Else
DoCmd.RunCommand acCmdUndo
End If
End Sub



I dont know the difference in bound and unbound forms lol <.<

The undo command is not available in the before update event. Put the code in the after update event. The "undo" will undo the saving of the record.

[srmezick]

Thanks so much. Hopefully I wont have any more problems from that aspect of the database. Im having enough trouble with some of the other things Ive got going on for people to not be able to save information on top of it. =) Ill be back with more questions for sure. Maybe one day Ill be able to provide some answers lol.