|
||||||
|
Report Listbox By Richard Rost 3 years ago Using the On Double Click Event. Open Record. Learn how to make a listbox that's got all of the reports you need to print on a regular basis. All your users have to do is click on a report and then click on a "print" button, and voila. There's your report. Nice and easy to maintain and update, too. Avery from Mesa, Arizona (a Gold Member) asks: Is there a way I can create a list box or a combo box that displays a list of the available reports in my database. I don't need all of them, just a handful. I'd like to make it easy for the users to pick one and click a button to print it. I also don't want to have to add buttons to a menu every time I make a new report (which is often). Help? MembersI'll show you how to do the same thing without having to maintain a table. We'll loop through the Reports collection in VBA and use that to populate the list. I'll show you how to add a Description property attribute to a report for the display text. Fun stuff!
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! What Course?This isn't covered in any of my courses! New stuff! LinksRelational Combo Box: https://599cd.com/RelationalCombo
|
||||||||||||||||||||||||||||||||||||||||
| |||
Keywords: TechHelp Access selecting a report from a listbox, report combo box, listbox of available reports, report drop down list, AccessObject, Application.CurrentProject.AllReports, Containers, Documents, CurrentDB PermaLink Report Listbox in Microsoft Access |