Results 1 to 4 of 4
  1. #1
    Havvix is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2012
    Posts
    2

    Multiple checkbox filtering & Clearing


    Hello I have 2 questions,

    1. I have a table with 5 check box columns, I would like to filter the records that have no check marks in any of the columns, but keep the records if there it is checked off in any of the columns. Is this possible? I am a beginner with access.
    2. Is there a way to removed checked entries all at once so i have a clean slate to use for a different report?

    Thank you in advance

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    1. Try criteria under each yes/no field: =True
    Put each criteria on separate OR criteria rows

    2. Run UPDATE query to set each yes/no field to False
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Havvix is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2012
    Posts
    2
    Thanks that did it, Is there a way to keep the report from changing after I make it? I made a report and ran the Update query but it delete all the information from the report

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Options:

    Save the report as a PDF.

    Change your database structure so report can be recreated without having to reselect the yes/no fields for each record.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Multiple Filtering Questions
    By Datech in forum Forms
    Replies: 1
    Last Post: 04-23-2012, 03:01 PM
  2. Clearing Checkbox on New Record
    By rossi45 in forum Programming
    Replies: 5
    Last Post: 04-16-2012, 05:30 PM
  3. Insert Multiple Checkbox Values to one Textbox
    By dshillington in forum Programming
    Replies: 1
    Last Post: 12-28-2011, 10:10 AM
  4. Replies: 1
    Last Post: 08-09-2011, 11:13 AM
  5. Multiple filtering options in vba
    By eww in forum Programming
    Replies: 2
    Last Post: 09-28-2010, 01:46 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