Check List Extras

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.

Add a Check List to your MS Access Database

Adding Multiple Check-list to MS Access

Video 1  (9:18 min)

Nifty Access YouTube Thumb Nail
Play Video

… …

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)

Nifty Access YouTube Thumb Nail
Play Video

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)

Nifty Access YouTube Thumb Nail
Play Video

… …

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)

Nifty Access YouTube Thumb Nail
Play Video

… …

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.