Sticky Form Builder

Sticky Form Builder A “Sticky Form” is a Form that stays put! How many times have you opened up a pop-up form and had to move it to one side because it’s covering up exactly what you want to look at! It’s bloody annoying! I was pretty sure it was possible to make a Form … Read moreSticky Form Builder

Nifty Date Picker

Nifty Date Picker There are some excellent date pickers available on the internet. So why should you use mine? First of all I’ve included details of my thought processes when I constructed it, including where I went wrong! This in itself will prove useful for anyone who wants to build stuff in MS Access. It … Read moreNifty Date Picker

Subform – Time Management Matrix Example

Time Management Matrix Subform Example Time Management Matrix 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 … Read moreSubform – Time Management Matrix Example

Subform Record Duplicator

Subform Record Duplicator Subform Record Duplicator Video 1 (3:46) Nifty Access – “Subform Record Replicator” allows you to provide your user with the facility to quickly add sets of duplicate records in a subform. All they need do is specify the number of Records they want to add, select a record to copy, and hey presto … Read moreSubform Record Duplicator

Control Records Displayed in a Subform

Control Records Displayed in Subform Control Records Displayed in a Subform Video 1 (5:18) Klingest Asked — What I want to do is, that when you select a record in the subform showing “tblCalculation”, the related values from “tblSubCalculation” shall be displayed in the other subform.  How can I do that? In this video I answer … Read moreControl Records Displayed in a Subform

Sub-Forms

Sub-Forms Subforms are the best and most useful feature of MS Access. Why? Because they allow you to show related data easily. I think subforms are so important and useful that I wrote a blog about them here:- MS Access your Data with Sub-Forms Subforms can easily display parent/child related data. This is the most … Read moreSub-Forms

Adding Hobbies Transcript

Transcript of the Video:- Adding Hobbies to a Student Database Create 3 tables, tblHobby tblStudent tblStudentHobby. The construction of them will be like this, so from that information you should be able to reconstruct those tables. Now highlight tblSudent press create, create a form, close it. Give it a name frmStudent now do the same with … Read moreAdding Hobbies Transcript