Unchangeable field

Discussion in 'Access Table Design' started by MarianneZ, Feb 5, 2009.

  1. MarianneZ

    MarianneZ Guest

    In my table I have 2 fields that I do not want users to change. It's okay if
    Vba code changes the values, but not a user directly. Is there any way to
    enforce this?
     
    MarianneZ, Feb 5, 2009
    #1
    1. Advertisements

  2. Change the LOCKED property to YES. You can change it to NO in VBA if you
    need to make changes and then change it back so users can't. You will find
    the property in the DATA tab of the property sheet.

    Bonnie
    http://www.dataplus-svc.com

    MarianneZ wrote:
    >In my table I have 2 fields that I do not want users to change. It's okay if
    >Vba code changes the values, but not a user directly. Is there any way to
    >enforce this?


    --

     
    bhicks11 via AccessMonster.com, Feb 6, 2009
    #2
    1. Advertisements

  3. MarianneZ

    MarianneZ Guest

    I know I can do this in a form. It's in the table that I want the field to be
    readonly. Don't other people need this capability also?

    Do I need to force my users to go through a menu and a form? How do I
    prevent them from just opening the table and changing this field? Maybe even
    by accident.

    By the way, I'm using Access 2007 and DAO

    "bhicks11 via AccessMonster.com" wrote:

    > Change the LOCKED property to YES. You can change it to NO in VBA if you
    > need to make changes and then change it back so users can't. You will find
    > the property in the DATA tab of the property sheet.
    >
    > Bonnie
    > http://www.dataplus-svc.com
    >
    > MarianneZ wrote:
    > >In my table I have 2 fields that I do not want users to change. It's okay if
    > >Vba code changes the values, but not a user directly. Is there any way to
    > >enforce this?

    >
    > --

    >
    >
    >
     
    MarianneZ, Feb 6, 2009
    #3
  4. Yes, this is something many developers do.
    Use a menu and a form.
    Hide the nav pane from the users and make sure there are no options on the
    ribbon that give users the ability to open the tables directly.

    Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

    "MarianneZ" <> wrote in message
    news:...
    >I know I can do this in a form. It's in the table that I want the field to
    >be
    > readonly. Don't other people need this capability also?
    >
    > Do I need to force my users to go through a menu and a form? How do I
    > prevent them from just opening the table and changing this field? Maybe
    > even
    > by accident.
    >
    > By the way, I'm using Access 2007 and DAO
    >
    > "bhicks11 via AccessMonster.com" wrote:
    >
    >> Change the LOCKED property to YES. You can change it to NO in VBA if you
    >> need to make changes and then change it back so users can't. You will
    >> find
    >> the property in the DATA tab of the property sheet.
    >>
    >> Bonnie
    >> http://www.dataplus-svc.com
    >>
    >> MarianneZ wrote:
    >> >In my table I have 2 fields that I do not want users to change. It's
    >> >okay if
    >> >Vba code changes the values, but not a user directly. Is there any way
    >> >to
    >> >enforce this?

    >>
    >> --

    >>
    >>
    >>
     
    Jeanette Cunningham, Feb 6, 2009
    #4
  5. thanks

    plz i want help sir ,
    can u help me ..
    i want code for vb.net access database feild remains unchangable on run time

    > On Thursday, February 05, 2009 5:33 PM Marianne wrote:


    > In my table I have 2 fields that I do not want users to change. it is okay if
    > Vba code changes the values, but not a user directly. Is there any way to
    > enforce this?



    >> On Thursday, February 05, 2009 5:46 PM Jeanette Cunningham wrote:


    >> Hi MarianneZ,
    >> yes, instead of letting users type directly in the tables, give them forms
    >> to use instead.
    >>
    >> In a form, you can show the value for a field, but you can lock the control
    >> so that they can't change it, but VBA code can change the value.
    >>
    >> There is no way (that I am aware of) to prevent users from changing values
    >> in tables when they can open the table themselves.
    >>
    >> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
    >>
    >>
    >> "MarianneZ" <> wrote in message
    >> news:...



    >>> On Friday, February 06, 2009 7:17 AM bhicks11 via AccessMonster.com wrote:


    >>> Change the LOCKED property to YES. You can change it to NO in VBA if you
    >>> need to make changes and then change it back so users can't. You will find
    >>> the property in the DATA tab of the property sheet.
    >>>
    >>> Bonnie
    >>> http://www.dataplus-svc.com
    >>>
    >>> MarianneZ wrote:
    >>>
    >>> --
    >
    >>>



    >>>> On Friday, February 06, 2009 2:58 PM Marianne wrote:


    >>>> I know I can do this in a form. It's in the table that I want the field to be
    >>>> readonly. Don't other people need this capability also?
    >>>>
    >>>> Do I need to force my users to go through a menu and a form? How do I
    >>>> prevent them from just opening the table and changing this field? Maybe even
    >>>> by accident.
    >>>>
    >>>> By the way, I'm using Access 2007 and DAO
    >>>>
    >>>> "bhicks11 via AccessMonster.com" wrote:



    >>>>> On Friday, February 06, 2009 3:26 PM Jeanette Cunningham wrote:


    >>>>> Yes, this is something many developers do.
    >>>>> Use a menu and a form.
    >>>>> Hide the nav pane from the users and make sure there are no options on the
    >>>>> ribbon that give users the ability to open the tables directly.
    >>>>>
    >>>>> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
    >>>>>
    >>>>> "MarianneZ" <> wrote in message
    >>>>> news:...
     
    Jagan Salunkhe, Apr 22, 2011
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. missy

    converting regular field to lookup field - help!

    missy, Aug 8, 2003, in forum: Access Table Design
    Replies:
    3
    Views:
    106
    John Vinson
    Aug 9, 2003
  2. SueM
    Replies:
    1
    Views:
    235
    Rebecca Riordan
    Aug 16, 2003
  3. KV

    Create number field from text field

    KV, Nov 20, 2003, in forum: Access Table Design
    Replies:
    1
    Views:
    117
    Tim Ferguson
    Nov 21, 2003
  4. ron
    Replies:
    2
    Views:
    189
    Tim Ferguson
    Dec 12, 2003
  5. Laser Lu
    Replies:
    1
    Views:
    126
  6. annie

    table keys: single-field or multiple-field?

    annie, Jan 11, 2004, in forum: Access Table Design
    Replies:
    7
    Views:
    110
    annie
    Jan 12, 2004
  7. E. J.
    Replies:
    2
    Views:
    88
    E. J.
    Jan 15, 2004
  8. dc

    Making Options unchangeable

    dc, Feb 9, 2007, in forum: Access Table Design
    Replies:
    2
    Views:
    99
    Pat Hartman \(MVP\)
    Feb 9, 2007
Loading...