Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Reading a form's underlying record's lock status

    When I create a delivery docket, there is code in the print button that ticks boxes in the relevant job record in the job table, but if the job is being viewed a different way already, then the record is locked and the boxes are not ticked. What I would like is a bit of code that would check the lock status of the underlying record so I can abort the print process with a message saying that someone else has the record open.

    I can write the rest once I know what I need to check for and how.

    Thanks in advance. )
    "Heading for the deep end"

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    There is some code for a function that does that job in this post. The idea is to open a recordset and try to edit it. If there is an error, then the record is locked.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •