Results 1 to 3 of 3
  1. #1
    b-ballstyle is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    9

    Disable query field?


    Is there a way to disable a query field (Not only hide it), so when I run the query and see the datasheet view, it doesn't take charge of that field and doesn't display it. I would like to be able to trigger (Enable/disable) some fields with a button or a check box maybe? Is it possible?

    Example:
    Picture 1 : The "Production Center" field is enabled
    Picture 2 : The "Production Center" field is disabled (I just removed it from the query)
    Attached Thumbnails Attached Thumbnails 1.jpg   2.jpg  

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    I Query Design View - there is a check box under each of the fields you selected for the query. If you uncheck it - the field will not display when you run the query.

    Is that what you needed?

  3. #3
    b-ballstyle is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    9
    No because that will only hide it from the datasheet view but I want to disable it.. The thing is, I'm using 4 tables to make that query .. Take a look at it maybe you will understand more why I cant just hide it.
    Attached Thumbnails Attached Thumbnails Query.jpg  

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

Similar Threads

  1. Disable Field?
    By tylerg11 in forum Forms
    Replies: 4
    Last Post: 01-31-2012, 02:30 PM
  2. Disable field edit in form
    By cdilly17 in forum Forms
    Replies: 3
    Last Post: 07-12-2011, 10:13 AM
  3. Enable or Disable Field in Forum
    By lolos66666 in forum Forms
    Replies: 5
    Last Post: 03-13-2011, 05:30 PM
  4. Replies: 9
    Last Post: 12-17-2010, 11:44 AM
  5. Function to Enable/Disable Field
    By swalsh84 in forum Programming
    Replies: 5
    Last Post: 11-04-2010, 02:48 PM

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