General discussion

  • Creator
    Topic
  • #2286504

    Access question

    Locked

    by rcoolman ·

    Probably a simple question for someone:
    Say you have an Access database (2000 – 03) with one table T1 and a form F1 which displays all of the data in T1 and is editable. Say T1 has a field that is of type check box. How can I put a command button on F1 that will clear the check boxes for all the records? Please keep the answer simple – am fairly new at this Access stuff. – Thanks!!!

All Comments

  • Author
    Replies
    • #2730603

      Reply To: Access question

      by cptomlly ·

      In reply to Access question

      You can do this with an update query. Create an to create an update query, select “Create Query in Design View”. Select T1 as the table to include. Right click on the query design window, and choose “Query Type>Update”. Then choose the checkbox field and in the update box enter “false”. Then simply call this query from your command button Click() routine.

      Hope this helps

      • #2730558

        Reply To: Access question

        by rcoolman ·

        In reply to Reply To: Access question

        Thanks! That does the trick! I am trying to learn Access and its amazing what is intuitive, but I hadn’t even noticed that there were other query types. Thanks again!

    • #2730557

      Reply To: Access question

      by rcoolman ·

      In reply to Access question

      This question was closed by the author

Viewing 1 reply thread