Results 1 to 2 of 2
  1. #1
    Mister-B is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    31

    Check if record on form is locked with VBA

    Hi there,

    the title says it all. I would like to use a command button to check if the current record on my access form is locked by another user. The DB is split with the back end on a netwrok server and each user has their own copy of the the FE.

    I am thinking along the lines of

    If Me.CurrentRecord.Locked = True Then....

    Thanks


    Regards
    Martin

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    not an area I've played around with, but a quick google found a number of links - this one is probably the most promising

    http://etutorials.org/Microsoft+Prod...d+and+by+Whom/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 08-18-2018, 10:23 AM
  2. how to check if computer is locked
    By live2ride in forum Access
    Replies: 5
    Last Post: 10-22-2012, 01:40 PM
  3. Form locked - won't allow new record
    By mhart in forum Forms
    Replies: 4
    Last Post: 02-22-2012, 02:46 AM
  4. Check if file is locked
    By AKQTS in forum Programming
    Replies: 4
    Last Post: 08-10-2011, 03:23 PM
  5. Replies: 1
    Last Post: 02-12-2010, 01:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums