X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Mark Locked Records, Access 2016    
post Feb 14 2018, 01:03 PM

Posts: 115
Joined: 11-January 08

Hi Guys

Many of my clients call me to say that they can't update a record on a form.
Almost always it is because someone in the company has left the record in edit mode.
They don't like Auto save on a timer.

Is it possible to mark a record on a form if it is being edited by another user, therefore record is locked?
I was thinking of maybe a small box that was coloured green if Free or red if Locked.

It's the access to the record locking information and how to interpret it that I have no idea about.

Many thanks

Go to the top of the page
post Feb 14 2018, 01:04 PM

Access Wiki and Forums Moderator
Posts: 72,985
Joined: 19-June 07
From: SunnySandyEggo

Hi Andy,

Yes it is possible and maybe there's already a demo in the Code Archive for it. If not, I am sure I have seen it discussed in the forums before, so searching for a previous topic might also help.

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    21st August 2018 - 06:11 PM