|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Welcome Welcome! Multi-Select Lists & Debugging VBA Welcome to Microsoft Access Developer Level 15. In this course we will focus on multi-select list boxes and debugging. We will review what has been covered about list boxes in previous classes, talk about moving active and inactive customers between two list boxes, passing controls as parameter values, using multi-select options, and key properties and methods like ListCount, ItemData, Selected, For Each loops, and DBExecute. We will also discuss debugging in Microsoft Access, including error handling, using the Immediate window, setting watches and breakpoints, and recommendations for prerequisites and where to ask questions. NavigationKeywordsAccess Developer, multi-select list box, list box vba, debugging vba, move values between list boxes, error handling vba, dbexecute, itemdata, selected property, listcount, for each loop, point of sale system, test taker database, watches breakpoints
More InformationTranscriptWelcome to Microsoft Access Developer Level 15 brought to you by AccessLearningZone.com. I am your instructor, Richard Rost. Developer 15 is going to focus primarily on multi-select list boxes and debugging. Now, we have spent a good amount of time covering list boxes in past classes. In Beginner Level 8, we built static list boxes, which just have a single list of values in them. In Expert Level 4, we built relational list boxes, where you can base the data in the box off of a table or query. In Advanced Level 5, we learned how to move values from one box to another using macros. In Developer 10, we learned how to use VBA and SQL to populate our list boxes. Then, in Developer 10, we used list boxes in our Test Taker database. Today, we are going to beef that up a little bit and build a similar example to Advanced 5, but it is going to be on steroids. We are going to see how to move active and inactive customers between two different list boxes. This time, I am going to teach you how to pass a control as a parameter value. We are going to learn multi-select list boxes where you can select multiple options from the box and then do something with it. You can use code to select options in the box. We will learn about ListCount, ItemData, Selected. We will learn about For Each loops, and I will teach you about DBExecute. And yes, I know I went backwards when I wanted to do the list box stuff first. Lesson 2 is going to cover debugging. We have done some debugging before with On Error Resume Next, but a lot of you have been asking for more lessons on debugging. Here, I am going to teach you how to set up your own error handling, display error messages, use the Immediate window, set up watches and breakpoints, and lots more. I am using Access 2019, the Office 365 edition. I should probably change that slide. They recently renamed Office 365 to Microsoft 365, their subscription option. It is the same thing, different name. I would recommend for prerequisites that you at least have those top five classes there. The Test Taker Developer 10 is necessary. I do recommend you take all my classes in order, but if you are skipping around, you should know list boxes before you get to the multi-select stuff. These four classes on top here would be handy, at least. And, of course, I recommend the class before this, Access Developer 14. One of the major reasons I decided to go into multi-select list boxes is because we are going to use them a lot for developing our Easy Access POS, the point of sale system. Even if you are not building the POS with me, there are lessons in Developer 14 that everyone can benefit from. I suggest you take Developer 14 before Developer 15. If you have questions pertaining to the material covered in today's class, you can post them on the page for this class. If you scroll down to the bottom of the page under the video, you will see all the other questions and comments that other users have posted. You should see a form something like this. Yeah, I change it every time. It basically looks like this: type in a subject and your comments, hit submit, and it will go right on the course page. I try to answer questions online as often as I can, and there is Alex and a bunch of other people who do a great job of helping me out. That is where I recommend you submit any questions you have. You can also hit the subscribe button and get notified anytime anyone else posts a question about this class, too. That is great for updates or if I post any addendums or extra files, that kind of stuff. If you have a general question about Access or any other topic, you can go to the forums and post it there. I try to keep stuff in the course pages relevant to that class. That is what the forums are for. There is Word, Excel, Outlook, all that stuff. There is also my TechHelp page. If you need help right now with a project and you are stuck, and you do not want to wait for a forum reply, you can send it to my TechHelp page. If you need consulting advice or any of that kind of stuff, here is my email address, but again, I prefer you use one of the previous methods. So, sit back, relax, and click on the link below to start Lesson One. IntroWelcome to Microsoft Access Developer Level 15. In this course we will focus on multi-select list boxes and debugging. We will review what has been covered about list boxes in previous classes, talk about moving active and inactive customers between two list boxes, passing controls as parameter values, using multi-select options, and key properties and methods like ListCount, ItemData, Selected, For Each loops, and DBExecute. We will also discuss debugging in Microsoft Access, including error handling, using the Immediate window, setting watches and breakpoints, and recommendations for prerequisites and where to ask questions. QuizQ1. What is the primary focus of Access Developer Level 15? A. Multi-select list boxes and debugging B. Creating reports and forms C. Database security D. Custom ribbon design Q2. In which class did you learn to build relational list boxes based on a table or query? A. Beginner Level 8 B. Expert Level 4 C. Advanced Level 5 D. Developer 10 Q3. Which of the following is true about multi-select list boxes? A. They allow you to select multiple options and perform actions with them B. They only allow a single value selection C. They can only be used with static values D. They do not support VBA code interaction Q4. Which VBA concepts will be covered in relation to list boxes in this course? A. ListCount, ItemData, Selected, For Each loops, and DBExecute B. Creating custom menus C. Upsizing to SQL Server D. User-level security Q5. What is a new technique you will learn in this course regarding list box controls? A. Passing a control as a parameter value B. Sorting values alphabetically only C. Exporting list box data to Excel D. Using macro-only solutions Q6. What will Lesson 2 of this course primarily address? A. Debugging techniques in VBA B. Building navigation forms C. Formatting reports D. Compacting and repairing databases Q7. Why does the instructor recommend completing Developer 10 before taking this course? A. It includes the essential Test Taker database project B. It teaches forms and reports C. It covers Access web apps D. It focuses on SQL Server migration Q8. What major upcoming project will frequently use multi-select list boxes? A. Easy Access POS (point of sale system) B. Membership mailing system C. Inventory barcode generator D. Scheduling calendar Q9. What is the preferred method for posting questions about material covered in this class? A. Posting on the course page under the video B. Emailing Richard directly C. Commenting on YouTube D. Using the TechHelp page exclusively Q10. What tool can you use if you need immediate help with your Access project? A. TechHelp page B. Course comment section C. Forums only D. Wikipedia Answers: 1-A; 2-B; 3-A; 4-A; 5-A; 6-A; 7-A; 8-A; 9-A; 10-A 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. SummaryWelcome to Microsoft Access Developer Level 15 from AccessLearningZone.com. I am your instructor, Richard Rost. In this class, our main focus is on working with multi-select list boxes and learning more advanced debugging techniques. Throughout the previous courses, we have covered list boxes in several different ways. In Beginner Level 8, we set up static list boxes that simply display a set list of values. Then, moving up to Expert Level 4, we worked on relational list boxes, which pull data dynamically from tables or queries. In Advanced Level 5, I showed you how to transfer items between list boxes using macros. Later on, in Developer 10, we used VBA and SQL to populate list boxes, which we then used in our Test Taker database. Today, we are going to take those skills further. We will build a solution similar to what we created in Advanced Level 5, but this time it will be much more robust. Specifically, I am going to show you how to move active and inactive customers between two list boxes. One of the new skills you will pick up is passing a control as a parameter value. You will also learn how to work with multi-select list boxes so users can pick multiple items at once and perform batch operations. I will teach you how to work with properties such as ListCount, ItemData, and Selected. We will go over using For Each loops in this context, and I will explain the DBExecute method. This time, I decided to focus first on these enhanced list box features before addressing debugging. In Lesson 2, we turn our attention to debugging. We have covered On Error Resume Next before, but many of you have requested a deeper dive into error handling. In this lesson, I will walk you through setting up your own error handling routines, displaying error messages, using the Immediate window, and working with watches and breakpoints, among other techniques. I am currently demonstrating all of this in Access 2019 using the Office 365 edition, though Microsoft has since rebranded Office 365 as Microsoft 365. Only the name has changed - the product is essentially the same. I recommend you complete the first five prerequisite classes, especially the Test Taker Developer 10 lesson, before starting with this course. Ideally, you should work through my classes in order, but at the very least, make sure you are comfortable with list boxes before moving into the multi-select features in Developer 15. Of course, I also suggest completing Access Developer 14 just before this one. Learning about multi-select list boxes is very important for future projects, especially if you are planning to build the Easy Access POS (Point of Sale) system with me. Even for students not interested in the POS system, there are valuable lessons in Developer 14 that I believe everyone can benefit from before moving on to this level. If you have questions as you go through this material, the best place to ask is on the course page. At the bottom of the page, beneath the video lesson, you will see where you can submit your questions or comments. Your question will appear on the page, and I or another member of our community, like Alex and others who help out, will try to answer as quickly as possible. There is also an option to subscribe for notifications when new questions or updates are posted for the course. If you have more general questions unrelated to this specific lesson, you can use the main forums, which cover Access, Word, Excel, Outlook, and other topics. For urgent project help, you may use my TechHelp page to request assistance, and for consulting or other advice, you can reach me by email. However, I prefer that you use the appropriate support channels first. I encourage you to relax and get ready to learn. When you are ready, proceed to Lesson One. 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 ListBuilding multi-select list boxes in Access Moving items between two list boxes Passing controls as parameter values Selecting multiple options in list boxes Using code to select options in list boxes ListCount, ItemData, and Selected properties Using For Each loops with list boxes Using DBExecute in VBA Debugging Access VBA code Setting up custom error handling Displaying error messages in VBA Using the Immediate window for debugging Setting up watches and breakpoints in VBA List box applications in point of sale systems Primary Topics
multi-select list boxes, VBA debugging, error handling, passing controls as parameters, Access forms, list box manipulation Secondary Topics
list box events, troubleshooting, forum usage |
||
|
| |||
| Keywords: Access Developer, multi-select list box, list box vba, debugging vba, move values between list boxes, error handling vba, dbexecute, itemdata, selected property, listcount, for each loop, point of sale system, test taker database, watches breakpoints PermaLink How To Use Multi-Select List Boxes and Debug Your VBA Code in Microsoft Access |
