Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Nov 2006
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query lock (Access 2003 sp2)

    On cmdButton_on clicl() event
    Select query returns result in two columns:
    Equipment Name and Budget
    Is it possible to make one column editable and another locked?

    So User could edit Budget numbers and unable to make accidental
    change in Equipment Name column

    Thank you
    Alex
    I tried freeze columns- but it didn't work on individual column

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: query lock (Access 2003 sp2)

    You cannot lock a queries columns. Why dont you create a form based upon your query. Then you can lock the form control Equipment Name.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: query lock (Access 2003 sp2)

    In addition to patt's reply: end users should never enter or edit data directly in a table or query, only through a form. In a form, you can control what the user is allowed to do.

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query lock (Access 2003 sp2)

    From a systems standpoint Pat and Hans are correct

    For an a quick and dirty exception you might use something like this:

    locked: Description: [strDescription] & ""
    locked: Fee: [curFee]+0
    unlocked: lngFundAcctID1

    HTH, John

  5. #5
    Lounger
    Join Date
    Nov 2006
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query lock (Access 2003 sp2)

    Guys
    Thank you very much, you are right, I tried to make it more user friendly, it is really inconvenient to play with budgets through a form - there are could be up to 100 lines to adjust based on different situations- it would be very convenient to manage it from Excel alike input

    Alex

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: query lock (Access 2003 sp2)

    <hr>it is really inconvenient to play with budgets through a form<hr>

    People use forms to make it more user friendly.

    So if your form is inconvenient it sounds like the problem is with the form you have built.

    You can make a form look very similar to Excel.
    Regards
    John



  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: query lock (Access 2003 sp2)

    Try creating a continuous form - you can make it look very much like a datasheet, yet you have complete control over data entry.

Posting Permissions

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