|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Welcome Welcome! Remove Listbox Items & Export PDF Welcome to Microsoft Access Developer Level 17. In this course we will continue working with listboxes and recordsets, including how to remove items from an unbound multi-select listbox. We will discuss exporting PDF reports for individual customers using recordsets, allowing each customer to receive their own report. Finally, we will talk about creating a custom dlookupplus function that can retrieve a list of values, such as compiling a comma-separated list of states for each sales representative. This course builds on previous developer lessons, especially recent classes focused on multi-select listboxes. NavigationKeywordsAccess Developer, multi-select listbox, remove items from listbox, export PDF report, record sets, dlookupplus function, unbound listbox, customer report PDF, loop through recordset, comma separated list, email attachments, generate PDF per record
IntroWelcome to Microsoft Access Developer Level 17. In this course we will continue working with listboxes and recordsets, including how to remove items from an unbound multi-select listbox. We will discuss exporting PDF reports for individual customers using recordsets, allowing each customer to receive their own report. Finally, we will talk about creating a custom dlookupplus function that can retrieve a list of values, such as compiling a comma-separated list of states for each sales representative. This course builds on previous developer lessons, especially recent classes focused on multi-select listboxes.TranscriptWelcome to Microsoft Access Developer Level 17, brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.In today's class, we are going to continue working with listboxes and record sets. We are going to remove items from a multi-select listbox, export individual PDF files from records in our database, and we are going to create a function called dlookupplus. We are going to continue working with multi-select listboxes, like we have been for the last couple of classes. In the first lesson today, we are going to cover removing items from an unbound multi-select listbox. That is where you have a list of items in the box not tied to a table or query. They are just stored in the box, and we are going to learn how to select multiple items and remove them. In lesson two, we are going to continue working with record sets, and we are going to see how to export a customer report that is specific to each customer to a folder on your hard drive. So customer one gets his own PDF, customer two gets his own PDF. This is great for sending out statements. You can send these out in email attachments. You can do whatever you want. Each customer gets their own customer report generated by looping through the customers in a record set and exporting each one using a report to a PDF file. Finally, in lesson three, we are going to write our own function called dlookupplus. Now the standard dlookup function lets you look up one value from a table or query. Dlookupplus lets you look up a whole list. You can bring back a list of items. For example, the example here, you have got a table that has your sales rep in it and a list of what states they cover. So you have got Joe, California. The next record of course would be Joe, Maine, Joe, New Jersey, Joe, New York. That is how a properly set up relational set of tables would have them. However, for reporting purposes, you might want to bring back a list, a comma separated list of all of the states that Joe covers. So dlookupplus will say go out to the table and look up all of the values that meet a specific set of criteria. That is dlookupplus. This class is recorded to work with either Microsoft 365 or Access 2019, but it should work going back to all versions back to I think about 2007. You will be fine. 2016, 2013, those are all good. You should have of course taken my beginner, expert, advanced, and developer classes up to at least developer one. I strongly recommend taking from developer 13 on because I do cover some stuff that is reliant upon those lessons. The multi-select list boxes of course go back a few lessons. So just take all the developer classes and you will be fine. Now it is time to sit back, relax, and watch Developer 17. QuizQ1. What is the purpose of a multi-select listbox in Microsoft Access?A. To allow users to select multiple items from a list B. To filter data in a table automatically C. To display only one item at a time D. To create new tables from selected items Q2. What is the first lesson in Developer Level 17 about? A. Removing items from an unbound multi-select listbox B. Sorting records by date C. Importing Excel spreadsheets D. Creating relationships between tables Q3. In the second lesson, what does the class show you how to do with customer reports? A. Export individual PDF files for each customer B. Print the entire customer list at once C. Email customers directly from Access D. Merge customer data with Word documents Q4. What is the benefit of exporting each customer report as a separate PDF file? A. Each customer receives their own unique report B. All reports are combined into one PDF C. PDFs are not supported in Access D. Reports are automatically sent to the cloud Q5. What is the main feature of the dlookupplus function covered in lesson three? A. It returns a list of values that match specific criteria B. It displays the total number of records in a table C. It only returns the first record that matches D. It exports tables to CSV format Q6. Why might you use dlookupplus instead of the standard dlookup function? A. To get a comma separated list of multiple results B. To update multiple records at once C. To create new tables automatically D. To import data from Excel Q7. Which versions of Microsoft Access are compatible with the techniques taught in this class? A. Microsoft 365, Access 2019, and versions back to about 2007 B. Only Access 2019 and newer C. Only Access 2003 D. Windows XP editions only Q8. What is the minimum prerequisite before taking Developer Level 17, as recommended in the video? A. Taking beginner, expert, advanced, and at least Developer 1 classes B. Completing a programming degree C. Watching unrelated courses D. Learning Excel first Answers: 1-A; 2-A; 3-A; 4-A; 5-A; 6-A; 7-A; 8-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. SummaryToday's video from Access Learning Zone is Developer Level 17, and I am your instructor, Richard Rost.In this lesson, we are going to continue our work with list boxes and record sets in Microsoft Access. Our focus will be on refining your ability to interact with multi-select list boxes, exporting data to PDF, and extending the capabilities of the Dlookup function. First, we are going to start by removing items from an unbound multi-select list box. We have looked at unbound list boxes that allow you to select multiple items not directly tied to a table or query. The items are just stored in the list box itself. Today, I am going to show you how you can select multiple items from that list and remove them as needed. In our second lesson, we will revisit working with record sets. Here, I will demonstrate how to export individual customer reports to PDF files, saving them to a specific folder on your hard drive. For example, customer one will get their own PDF, customer two gets theirs, and so on. This technique is especially useful for sending out customer statements. You can automate the creation and distribution of these reports by looping through your customers in a record set, generating and exporting a report for each one. In the third lesson, we will build a custom function called DlookupPlus. The standard Dlookup function allows you to retrieve a single value from a table or query using certain criteria. Sometimes, however, you need a list of values that all match your criteria. DlookupPlus addresses this by returning a list, such as a comma-separated string, containing all the fields that fulfill the specified criteria. For example, if you have a table showing the states each sales rep covers, instead of listing multiple rows for Joe covering different states, you can generate a single list showing all those states together, making reporting much easier. This course is designed to be compatible with Microsoft 365 and Access 2019, and it should work with earlier versions going back to Access 2007. If you are using 2016 or 2013, you are also covered. To get the most out of this class, you should have already completed my beginner, expert, and advanced series, as well as the developer classes up through at least Developer Level 1. I strongly suggest starting from Developer Level 13, since many of the concepts we are building on were introduced there, especially related to multi-select list boxes. So get comfortable and get ready to continue with Developer 17. 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 ListRemoving items from an unbound multi-select listboxWorking with multi-select listboxes Exporting individual PDF files from records Exporting customer-specific reports to PDF Looping through records with recordsets Generating and saving reports as PDFs Emailing exported PDF reports Creating a custom DLookupPlus function Returning comma-separated lists from table data Looking up multiple values with custom VBA function |
||
|
| |||
| Keywords: Access Developer, multi-select listbox, remove items from listbox, export PDF report, record sets, dlookupplus function, unbound listbox, customer report PDF, loop through recordset, comma separated list, email attachments, generate PDF per record PermaLink How To Remove Items From a Multi-Select Listbox and Export PDF Reports in Microsoft Access |
