P
PaulHilgeman
Now that I have added users etc. to my database I get errors every time
I try to save data wether I am logged in as the admin or not.
The event is an BeforeUpdate Event that obviously runs anytime a user
tries to exit the form, by either closing or searching for a new record
when they have made changes.
The funny thing is that it worked fine before I went through the whole
users and security ordeal.
Here is the code:
**************************************************************************************
Private Sub Form_BeforeUpdate(Cancel As Integer)
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
**************************************************************************************
Any help would be apreciated. Thank you!!!!
I try to save data wether I am logged in as the admin or not.
The event is an BeforeUpdate Event that obviously runs anytime a user
tries to exit the form, by either closing or searching for a new record
when they have made changes.
The funny thing is that it worked fine before I went through the whole
users and security ordeal.
Here is the code:
**************************************************************************************
Private Sub Form_BeforeUpdate(Cancel As Integer)
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
**************************************************************************************
Any help would be apreciated. Thank you!!!!