Check List Extras

Update the Checklist Automatically

Demonstrate how to Fill the Checklist Automatically

Video 1  (9:18 min)

This MS Access technique is useful in many circumstances in your MS Access development

Video 1  (9:18 min)

Code & Sample dB:-

...

Checklist - How to Check ALL

Check / Uncheck ALL Check Boxes

Video 2  (9:05)

  • Demonstrate how to change all of the checkboxes from False to True and True to False.
  • Mark all the Check Boxes as true or false with a Command Button.
  • Add a Command Button.
  • Create a query based on the the table tblData.
  • Demonstrate how to create an Update Query and then extract the SQL of the query and use that in your VBA code.
  • It's best to put the spaces at the end of the SQL strings.
  • Show how to add a reference to a control on the form within your VBA code in particular a reference within the SQL statement.
  • The reference to the text box should return its "Value" by default however it's good practice implicitly reference the value.
  • To uncheck them you would change the "True" to "False" in the SQL statement.
  • Demonstrate how to pass the "true" or "false" through as a parameter in a function.

Video 2  (9:05)

Convert the Two Buttons to One - How?

In one of my early videos I demonstrate how to convert a two button system (btnLock and btnUnlock) into a one button system btnLockUnlock follow the link below for video instructions...

...

Checklist - Serial Number Collector

Check / Uncheck ALL Check Boxes

Video 3  (1:57)

This is based on the "Single" Check List example (See link below). The checklist checkbox has been replaced with a text box and is ideal for scanning barcodes into.

Video 3  (1:57)

Code & Sample dB:-

...