|
-
Jan 11th, 2005, 05:41 PM
#1
Thread Starter
Hyperactive Member
How to determine if the current record is locked?
In Access, I set the RecordLocks property of my form to "Edited Record". User-1 starts editting a record, but goes to lunch for 2 hours, leaving the form openned.
User-2 browses to that record, but when trying to edit, the RECORD SELECTOR shows it cannot be editted because it's locked by the hungry user. Everything works well.
I will now remove the record selector... How can I warn my user that he won't be able to edit that record? If he tries to edit the record, he'll end up with an error - which is normal. I would like to know how I can determine, by code, wheter or not the current record is LOCKED - I would then be able to disable some functionnality on that form (buttons and so on, which I don't want the user to use until the record is not locked anymore).
It wouldn't be as accurate if I would just wait for User-2 to try a modification and catch the error resulting from that.
I was expecting something like "msgbox Me.CurrentRecord.locked". (roughly)
Thanks
Last edited by Krass; Jan 13th, 2005 at 07:00 PM.
Reason: now UN-resolved.
Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|