Join Adam Wilbert for an in-depth discussion in this video Querying a list of database objects, part of Access 2013: Tips & Tricks.
…The m sys object system table presents us with an opportunity to get a dynamic…listing of all the objects within our database…by making use of some creative query criteria.…In the type field that we explored in the last movie, we…can use this normally hidden table to help end users navigate the database.…Let me show you how we can create…a dynamic combo box that instantly allows any…report to be run from the menu system as soon as they're added to the database.…For this, we're going to modify our Reports Menu, from the main…menu I'll click on Reports, and that will open main menu reports.…I'm going to right click on this and choose Design View.…
Now, what I want to do is create a combo box that…pulls out a list of our existing reports in the navigation pane.…I'll start this by going to the Design tab.…Choosing Combo Box, and then dropping one down on…our Report Menu, that'll start up the combo box wizard.…Now, in this case we're not going to be able to use…the wizard because we're going to be making use of a hidden system table.…
- Creating a kiosk experience
- Hiding the ribbon
- Creating cascading combo boxes
- Working with hidden objects
- Creating a separate back end
- Building a dynamic reporting tool
- Writing custom functions in Visual Basic
- Distributing your application
Skill Level Intermediate
1. Creating a Start-up Experience
2. Creating Cascading Combo Boxes
3. Working with Hidden Objects
4. Working with Split Databases
Creating a back end3m 44s
5. Creating a Dynamic Reporting Tool
6. Aiding the End User
7. Writing Custom Functions in Visual Basic
8. Distributing Your Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.