Check List Extras
I have two video series on YouTube which explain how to build Check-Lists in Microsoft Access. The first series shows how to build a single checklist and the second series of videos expands on the information provided for the single checklist, and demonstrates how to add multiple checklists to your MS Access database.
The videos on this page apply to both the single and multiple checklist examples and provides a way of adding extra functionality To any of the checklists you create.
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.
Video 1 (9:18 min)
… …
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)
… …
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)
… …
This Video Applies To:-
… …
