Subform – Time Management Matrix Example

Time Management Matrix

This example demonstrates how you can can use “Instances” of a Form multiple times. You place the copies on the main form as “Sub-Forms” It’s an interesting way of programming, and with this technique you can quickly develop Forms with exceptional properties and uses with very little coding…

Subform Example

Subform Example

Video 1 (3:50)

Regarding multiple copies of the same form, I do understand this method of building databases, that is creating duplicates of the same form with minor alterations to serve a slightly different functions. And it is probably an acceptable process when you are designing, however you should endeavour to use the same form many times. Instead of creating multiple duplicates with slightly different functionality, what you do is add the different functionality with VBA code. This is demonstrated in the video on Subforms. The video shows a main form that appears to have 4 subforms on it, however it only has one subform modified with VBA code to perform four slightly different functions. This idea is demonstrated in the form of a Time Management Matrix. I give a brief explanation of the Time Management Matrix. I show how to add a new task. I also demonstrate how to move tasks between the different sections. I give a quick review of the VBA code in the module behind the form. 

The “Time Management Matrix” sample dB used in this Video is available for Download Here:-

Video 1 (3:50)

Play Video

… …

Leave a comment