Check List Extras

Update the Checklist Automatically

Demonstrate how to Fill the Checklist Automatically

Video 1  (9:18 min)

In this video I demonstrate one way of filling the Checklist sub-form automatically. I use the "After Update Event" of the text box "master description" to call the function "fCopyListToDataOnlyOnce". There's a Nifty Tip:- "Move the after update event code stub to the top of the code module window". First you need to test to see if "txtMasterDescription" is null or empty. The after update event fills the subform with data, however you can't see the data! You need to refresh the subform. I explain a problem with the Microsoft naming convention for subform controls and the solution. Basically prefix then with "subFrmWin" (subform window) - the modification explained in this video is an enhancement to the checklist and multiple checklist instructions here and here.

Add a Check List to your MS Access Database

Adding Multiple Check-list to MS Access

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:-

... ...

Checklist With Multiple Choice

Checklist With Multiple Choice

Video 4 (1:31)

This video demonstrates the use of the CallCalled class module. If you want to see in detail how the code set up, then comment in the comment section of the video. If enough people demonstrate an interest I will do an explanation.

Video 4 (1:31)

More Info on Checklist With Multiple Choice :-

... ...

Easy MS Access Checklist

  Checklist Required! Checklist Required! Video 1 (1:27) I offer a solution to a problem which might, sort of, sneak up on you when you’re developing

Read More »

Create Many Records

Create Many Records Create Many Records Video 1 (5:16) At last an opportunity to demonstrate Record Set Loops!!! I can see that this question “Generate in

Read More »

More Useful Stuff HERE:-