Lessons

Resources

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to Access 321
Get notifications when this page is updated

Intro

In lesson 321, you will learn how to work with list boxes in Microsoft Access using VBA, including adding and removing items directly and handling multi-select list boxes. I will also show you how to edit, add, and delete records using recordsets, expanding on concepts introduced in Access 320. This lesson uses Microsoft Access 2003, but most topics are compatible with older versions back to Access 2000.

Transcript

Welcome to Microsoft Access 321 brought to you by accesslearningzone.com. I am your instructor, Richard Rost.

Today's class is going to cover programming a list box, not just a bound list box that has some data from a table in it, but actually working with the list box itself, how to add items to it and remove items from it.

We are going to work with multi-select list boxes where you can pick multiple values from this box, and the only way you can get those is with VBA code.

We are also going to work more with our recordsets. We will learn how to edit recordsets. We will learn how to add and delete records and work with more information in the recordset itself.

This class follows Microsoft Access 320, which was the first in the recordset series. In this class, I will be working with Microsoft Access 2003. However, most of the material should be backward compatible with all previous versions of Access back to about Access 2000.

I strongly recommend you sit back and relax, watch the lesson one time through, then watch it a second time following along with the examples, and build the database that I build in class. Do not try to apply what you learn immediately to whatever other databases you might be working on.

The database files for this class can be found online at accesslearningzone.com/students. You will find a list of all the sample database files there. Again, it is strongly recommended that you build the databases in class that I am building.

If you have any questions about the material covered in today's class, please feel free to post a note in the student interaction forums. You will see the student interaction forums next to the video window if you are watching this class on our website or you are using our video player software and you are connected to the internet. You should see the student interaction forums pop up right next to the video player.

If you have any other Access questions, please visit the forums on the website at accesslearningzone.com/forums. We have brand new interactive forums. As of October 2008, I created all brand new forums and you can log on, check them out, and share with me, other students, and other Access experts.

And of course, I cannot stress enough: do the examples yourself. You will benefit the most by building the databases that I build in class.

Quiz

Q1. What is the main focus of this Microsoft Access 321 class?
A. Learning how to create tables and forms
B. Programming a list box and working with recordsets
C. Managing queries and macros
D. Designing reports with advanced formatting

Q2. What unique list box functionality will be covered in this class?
A. Adding charts to list boxes
B. Working with multi-select list boxes using VBA code
C. Creating drop-down menus inside list boxes
D. Exporting list box data to Excel

Q3. Which topic related to recordsets is mentioned for this class?
A. Creating recordset graphs
B. Editing, adding, and deleting records in recordsets
C. Printing recordsets directly
D. Encrypting recordsets

Q4. True or False: The material in this course is only compatible with Microsoft Access 2003.
A. True, it is exclusive to Access 2003
B. False, it is compatible with Access 97 and above
C. False, it is compatible with Access 2000 and above
D. True, but only for Access XP

Q5. What is the recommended approach to learning from this course?
A. Apply the concepts immediately to your own databases
B. Only read the provided course notes
C. Watch the lesson first, then follow along and build the sample database
D. Search for similar tutorials online and compare methods

Q6. Where can students find the sample database files for this class?
A. On the Access software CD
B. At accesslearningzone.com students page
C. Sent via email after the class
D. In the Microsoft Office help files

Q7. If students have questions about the course material, what should they do?
A. Email Microsoft tech support
B. Call Access Learning Zone support line
C. Post a note in the student interaction forums
D. Wait for the next class

Q8. Why does the instructor emphasize doing the in-class examples yourself?
A. It is required for grading
B. It helps reinforce concepts and aids in learning
C. It is mandatory to access the forums
D. It unlocks bonus material

Answers: 1-B; 2-B; 3-B; 4-C; 5-C; 6-B; 7-C; 8-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone focuses on working with list boxes in Microsoft Access. In this class, I will show you not just how to use basic bound list boxes that display data from a table, but how to programmatically control a list box using VBA. This means you will learn how to add items to a list box and remove items from it, giving you much more flexibility in how you present and manage your data.

We will discuss multi-select list boxes, which allow users to pick multiple values at once. This capability is only possible through VBA code, and I will walk you through the techniques for handling and retrieving selected values from these types of controls.

Additionally, we are going to dive deeper into working with recordsets. You will learn how to edit records, add new records, delete existing records, and manipulate recordsets to gather more information directly from your data.

This class continues the material we began in Microsoft Access 320, which introduced recordsets. For these lessons, I am using Microsoft Access 2003, but most of the concepts and procedures should work in versions going back to Access 2000.

I recommend you first watch the lesson all the way through without trying to follow along. After that initial viewing, watch the video again while working alongside me, building the database step by step just as I do. Try not to immediately transfer what you learn to your other databases. Focus instead on recreating the sample database, as this will help you solidify the core concepts.

All of the database files we'll use in class are available online at the Access Learning Zone website for students. You can find a complete list of the sample files there. Again, it's best to work directly with the files and examples I provide.

If you have any questions about what you see in class, you're welcome to post them in the student interaction forums. If you are watching on the website or using our video player with an internet connection, you'll see the forums right next to the video window so you can interact easily with me and your fellow students.

For any other Access-related questions, you can also use the main forums at the Access Learning Zone website. These new interactive forums, introduced in October 2008, are a great place to share ideas and get answers from me, other students, and Access experts.

Finally, I want to emphasize the importance of doing every example yourself. You will get the most benefit by building the databases as I do in class.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Programming a list box in Access with VBA
Adding items to a list box using VBA
Removing items from a list box using VBA
Working with multi-select list boxes
Retrieving multiple selected values with VBA
Editing records using recordsets
Adding records to a recordset
Deleting records from a recordset
Working with recordset data in Access