Lessons

Members

Members we'll learn how to open and edit family members without using the list items edit form button. We'll create our own button and the events that go with it which I think is much better. The list item edit form button is unreliable.

Members will learn how to double click on the combo box to open up the helper type form to the specific helper type ID, make any changes such as adding a new value, and then when they close that form it will update the combo box. Well then add a password and make the password sticky so it remembers that you're a manager for the rest of this Access session.

Members will learn how to open the helper form from a control on the subform and have it return the value entered or selected. Then we will also display the person's age next to their date of birth.

No extended cut, but here's the database file:

Database Download - Gold Members

No extended cut, but here's the database file:

Database Download - Gold Members

No extended cut, but here's the database file:

Database Download - Gold Members

Info

In this series of videos, we will be building a database for tracking association members in Microsoft Access. This database will be suitable for a wide range of organizations, including churches, educational institutions, social clubs, and more. If there are specific features or types of databases that you would like to see, please let me know in the comments.

This is Part 2 of my Microsoft Access Association Database. In this video we will continue laying out the tables that we need and we'll layout the forms for the database.

This is Part 3 of my Microsoft Access Association Database. In this video we will modify the TechHelp template that I use for most of my databases. We'll change the customer table over to a person table and see what other items in the database that effects that we have to then change. We'll build an update query to set some default values for existing records. We'll see how to do a global find and replace in VBA code. And we'll build the rest of the tables in the database which will be easier now that we have a great road map to follow from the first couple of lessons.

This is Part 4 of my Microsoft Access Association Database. We will convert the old customer form over to the new person form and add whatever fields we have to. We'll learn how to make Control Tip Text and use the Locked property. We will add a family combo box to select which family this person belongs to. We will create a family form with a combo box to select the head person of that family. We'll modify the row source of the combo box to only show people in that family. This will involve changing the SQL statement and using an OnCurrent event in the form.

This is Part 5 of my Microsoft Access Association Database. In this video we will build the family member list which shows a list of the family members in that family. This will be a list box on the family form. We will create a list items edit form button to add or remove members. Then we will make a family list form much like the person list form and a button to open that from the main menu. Then we'll make it so you can jump to the family from the person form and vice versa.

This is Part 6 of my Microsoft Access Association Database. In today's video we're going to work on the helper form and the helper type form. These allow you to create lists of lists so you don't need a million tiny tables in your database for lists of things like gender, occupation, ethnicity, and so on.

This is Part 7 of my Microsoft Access Association Database. In this video we're going to build the combo boxes on our main forms to select helper data based on the specific type of data we need to pick for that combo box.

This is Part 8 of my Microsoft Access Association Database. IIn today's video we are going to build the demographics form and show you how to switch between the context subform and the demographics sub form by clicking on a label that will change the subform's SourceObject property.

This is Part 9 of my Microsoft Access Association Database. In today's video we are going to make a major revision to one of the features of the database. We're going to replace a single family that a person can belong to with a group table that will allow us to put people into multiple groups including families, companies, interests, and more.

This is Part 10 of my Microsoft Access Association Database. In today's video we are going to make a series of nested forms so you can see the group types then the groups in each type and then the people in each group. We're going to do this using nested continuous sub forms which are really cool.

This is Part 11 of my Microsoft Access Association Database. In today's video we are going to add a subform to select groups (including families, companies, interests, and so on) from the main person form. Will also add a combo box to filter the group type in that subform.

Pre-Requisites

FastTips

What's Next

Part 12: Coming Soon!

Learn More

FREE Access Beginner Level 1
FREE Access Quick Start in 30 Minutes
Access Level 2 for just $1

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates

Resources

Diamond Sponsors - Information on our Sponsors
Mailing List - Get emails when new videos released
Consulting - Need help with your database
Tip Jar - Your tips are graciously accepted
Merch Store - Get your swag here!

Questions?

Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, associations, groups, schools, memberships, churches, temples, donations

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Change CustomerT to PersonT, Update Query, Global Find & Replace in VBA Code, Build Rest of Tables

FastTips Access Fast Tips Change CustomerT to PersonT, Update Query, Global Find & Replace in VBA Code, Build Rest of Tables

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Person Form, Control Tip Text, Locked, Family Combo, Family Form, Head of Family Combo, OnCurrent Event, Change SQL RowSource

FastTips Access Fast Tips Person Form, Control Tip Text, Locked, Family Combo, Family Form, Head of Family Combo, OnCurrent Event, Change SQL RowSource

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Family Member List, List Items Edit Form, Family List Form

FastTips Access Fast Tips Family Member List, List Items Edit Form, Family List Form

FastTips Access Fast Tips Helper Type Form, Helper Form, Lists of Lists

FastTips Access Fast Tips helper type combo boxes, password

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Demographic Form, 1-to-1 Relationship, More Helper Combos, Switch Subforms, SourceObject

FastTips Access Fast Tips Demographic Form, 1-to-1 Relationship, More Helper Combos, Switch Subforms, SourceObject

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, major revision, putting people into groups, families, companies, interests, many to many relationships, m2m

FastTips Access Fast Tips major revision, putting people into groups, families, companies, interests, many to many relationships, m2m

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, group type form, group form, put people into groups, nested subforms, nested continuous forms

FastTips Access Fast Tips group type form, group form, put people into groups, nested subforms, nested continuous forms

FastTips Access Fast Tips group subform on person form