In Production

This course is now in production. Enroll now to join in while these lessons are being developed and give your feedback!

Resources

Topics Covered

In Lesson 1, we will learn about multivalued fields (MVF), what they are, how to use them, and why you should avoid them at all costs. Yes, they're on my Evil Access list.

In Lesson 2, we will learn how to read the values from an MVF using a recordset loop. We'll also see how to programmatically add values to a multivalued field.

In Lesson 3, we will replace the MVF with a proper junction table. We'll learn how to loop through all of the customer records and export the MVF data to the junction table. We will create a text box to display the items as a comma separated list, like an MVF does.

In Lesson 4, we will learn how to create a popup form with a multi-select list box to modify the data in the new MVF replacement (junction table). You could do this just with a list box on the main form, but I like the popup. :)

In Lesson 5, we will learn more cool stuff. Coming soon...

Enroll Today

Enroll now so that you can participate with us as the videos are posted.

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, more...