+ Reply to Thread
Results 1 to 4 of 4

Can i Lock Individual Records

  1. #1
    Webtekr
    Guest

    Can i Lock Individual Records

    Hello ,

    I want to lock some records individually can i do that If yes please tell me how??

    Thanks

  2. #2
    J.wills
    Guest

    Re: Can i Lock Individual Records

    You need to add an extra field to the record and set it to boolean type. give it a meaningful name and set the default value to True

    Now each time you visit the record in single form view you can toggle the allow edits option to according to the record status.

  3. #3
    Webtekr
    Guest

    Re: Can i Lock Individual Records

    can you tell me the code by which i can lock individual records..............

  4. #4
    Forum Administrator ExlGuru's Avatar
    Join Date
    03-17-2009
    Location
    India
    MS-Off Ver
    2003,2007
    Posts
    222

    Re: Can i Lock Individual Records

    Go to the form properties and you will see an option Allow Edits set this to No.

    An alternative is to use VBA to set the controls that can't be edited

    Me.FieldA.Enabled = False
    Me.FieldA.Locked = True

    and vice verca to swith the edit mode back on.

    This option is the better option as it will allow you be selective on what fields can or cannot be edited.
    ExlGuru

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1