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: 131
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: 74,503
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.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    23rd February 2019 - 08:27 AM