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)

Nifty Access YouTube Thumb Nail
Play Video

… …

More Useful Stuff HERE:-

Leave a comment

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.