Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ans303

  1. ans303

    Lock a specific field on a new record only using Access 2003

    This is working exactly as I asked, and now I realize it is too restrictive. How can I relax it to NOT lock until a certain amount of time has elapsed, for example, don't lock until five days from the add date? I have a field called Add Date that is set to Now() as the default when you add a...
  2. ans303

    Lock a specific field on a new record only using Access 2003

    I am well thank you.
  3. ans303

    Lock a specific field on a new record only using Access 2003

    It seems to be working now. I drug down a new DO Staff Combo Box and started it over and it works. Thanks.
  4. ans303

    Lock a specific field on a new record only using Access 2003

    Thank you for responding. I appreciate it. Do I leave the After Update Event on DO Staff? It still seems to have problems and turns the second line yellow: Private Sub Form_Current() If Not IsNull(Me!DO_Staff.Value) Then Me.DO_Staff.Locked = True Else Me.DO_Staff.Locked = False End If...
  5. ans303

    Lock a specific field on a new record only using Access 2003

    I want to lock a specific field on a new record using Access 2003. The name of the field is DO Staff. DO Staff is a combo box. I want to lock DO Staff on a new record so it cannot be changed after it is saved. What is happening is after I do this one time DO Staff is locked for all...
See more

Part and Inventory Search

Back
Top