Results 1 to 8 of 8
  1. #1
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90

    Adding Records

    In datasheet form, is there a specific way to lock (not allow edits) to one of four data fields which are not limited to list and still allow delete/add records too?

    I can find it on the form property but not at the data field level. When I set it on the form property (Allow Edits = No) I cannot add data to the left/right of existing records.

    This example might be helpful:

    PN Desc Date Color
    1212 Thing May 2010 Green
    3212 Another May 2010 Blue

    This data shows when the form is opened, I do not want the user to be allowed to edit the PN field but they are allowed to edit the other 3 fields. (At least that's the plan now)

    Sorry my example got smushed together when I submitted, hope you can figure out what I was trying to communicate.

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    In the Text Box properties, have a look at "Enabled" and/or "Locked".

    Cheers,

  3. #3
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90
    We're using a combo box for that PN field, would that matter?

    I tried changing Enabled to "No" and it turned the data gray and would not allow my cursor into the field.

    Then I tried Locked = "Yes" and it will not allow new data to be added. (The locked = yes was almost there).

  4. #4
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    The combo box might make a difference depending on where it's located; in the table (good), or in the form (bad).

  5. #5
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90
    It's on the form = bad!

    I'll move it to the table and see what difference that makes. I'll let you know.

  6. #6
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90
    Put the look-up in the table vs. the form and then changed form properties and then look up box properties - still operates the same way. I think I'm trying to do something which cannot be done.

  7. #7
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    It isn't a required field in the table, right?

  8. #8
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90
    Correct, however, I changed the field so it is now required and it still does the same thing. I really do think I'm trying something which cannot be done since it requires locking only certain records within a column.

    I'll mark this as solved but I think it was that my initial question was outside the scope of Access.

    Thanks.

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

Similar Threads

  1. Adding multiple records in subform
    By randolphoralph in forum Programming
    Replies: 1
    Last Post: 05-12-2010, 09:42 PM
  2. Replies: 2
    Last Post: 04-04-2010, 06:14 PM
  3. Adding of Fields in Different records
    By pcliaros in forum Queries
    Replies: 1
    Last Post: 03-17-2010, 02:31 AM
  4. adding records through form
    By Rayk in forum Forms
    Replies: 1
    Last Post: 01-09-2010, 07:55 AM
  5. Adding a Field Name
    By jackthedog in forum Reports
    Replies: 1
    Last Post: 07-04-2009, 08:18 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