Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Record Or Form Editing Control

Discussion in 'Information Technology' started by GL, Nov 9, 2005.

  1. GL

    GL
    Expand Collapse
    Guest

    Hi

    I would like to control record editing in a multi user data base.
    Record editing in that specific application is performed only through forms.
    Do I have to set record locking, form locking, or both?
    How can I do it programmatically?

    Thanks

    GL
     
  2. Loading...


  3. OP
    [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    You can open the form as readonly. Place a command button that requires
    being clicked to edit the record.

    Docmd.OpenForm "Formname", ,,,acFormReadOnly

    In the Onclick:
    me.allowedits = True

    In the after update for the form
    me.allowedits = false

    --
    Steve Clark, Access MVP
    http://www.fmsinc.com/consulting
    *FREE* Access Tips: http://www.fmsinc.com/free/tips.html


    "GL" <GL@discussions.microsoft.com> wrote in message
    news:9C97CB44-2153-48E5-9DFB-5742B8583996@microsoft.com...
    > Hi
    >
    > I would like to control record editing in a multi user data base.
    > Record editing in that specific application is performed only through
    > forms.
    > Do I have to set record locking, form locking, or both?
    > How can I do it programmatically?
    >
    > Thanks
    >
    > GL
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page