Split a Large MS Access Datasheet in to 3 Smaller Datasheets You’ve got a large “VERTICAL” List of Data in datasheet form, you might prefer to have it spread out across the screen instead of constantly having to page up and down the list. In this set of videos I demonstrate two ways of implementing … Read more
Spell Checker Popup Form Nifty Spell Checker PopUp Form Nifty Spell Checker Pop-Up Form Video 1 (1:42) This video demonstrates the spell checker pop-up working Video 1 (1:42) https://www.youtube.com/watch?v=a3T8Xw9BVag … … Nifty Spell Checker – Setup Nifty Spell Checker – Setup the Pop Up! Video 2 (4:29) In this video I demonstrate how to download & install the … Read more
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 … Read more
Subform Record Duplicator 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 you’ve got a load of … Read more
Control Records Displayed in Subform There are various ways you can display how records are sorted in a Form. I’m fond of directly accessing a forms record source with an SQL Statement, an alternative would be to use the filter property. I have done a few videos on the filter property which you could probably … Read more
Sub-Forms Subforms can easily display parent/child related data. This is the most common and useful feature. They can also show standalone data, often filtered with combobox(s) and other controls. But wait a minute actually we are not talking about a subform here, there’s no such thing as a subform, what you’ve actually got is a … Read more
Easy Search Criteria More years ago than I care to remember, I created this Search Form. It was one of my first Adventures into MS Access VBA. Later, when I was looking for a subject which I could use as a way of introducing people into the world of VBA, it was this Search Form … Read more
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 more
Northwind Problem and Solution If you use the Northwind database as a basis for your business application then there is a problem that you should be aware of. The sample Northwind database supplied by Microsoft provides some excellent insights in how you should program an MS Access application. However if you decide to use it … Read more
Many to Many Relationship – 3 Video’s In their simplest form Many to Many relationships are just two columns in a table. The first column representing one side of the Many to Many Relationship and the other column representing the other side of the many to many Relationship. In this particular example we have students … Read more
