Sub-Forms

Sub-Forms

Subform - Intro

Subform - Intro

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 matrices. 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)

… …

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 »

More Useful Stuff HERE:-