Morning all,
Been struggling with a database ive made for a few days now.
The database is designed for multiple network users to use at once.
Im using Access' record locking feature, it's set to 'Edited Records' so it locks the record on edit.
I want it to pop up with a message box if the record they are viewing is locked.
I have this code:
Need to replace the XXXXX's with something that will detect if the record is locked or not!?
Help!
Thanks
Been struggling with a database ive made for a few days now.
The database is designed for multiple network users to use at once.
Im using Access' record locking feature, it's set to 'Edited Records' so it locks the record on edit.
I want it to pop up with a message box if the record they are viewing is locked.
I have this code:
Code:
Private Sub Option_1_Comment_Click()
If XXXXXX = XX Then
MsgBox "This Student is currently being edited by another user. Please try again later"
Else
XXXXXXXXXX
End If
End Sub
Need to replace the XXXXX's with something that will detect if the record is locked or not!?
Help!
Thanks