Search and Filter for Objects
Basically to avoid wasting time scrolling through a list of objects.
Like the search box in the Navigation Pane.
For example when selecting tables and views to create linked tables. Have a search box to filter list by using a contains filter. This would be ideal if it was implemented in all places when selecting an object from a list. For example:
When choosing a table or query to add to a query
When selecting a form or report to add to a sub form/sub report
Also when typing in VBA should be able to get a list of tables or queries and then be able to drill down into the fields to insert directly into the code modules. The same with forms and reports.
I have implemented this functionality myself with add-ins and it has improved my productivity.
Mark Phillipson
shared this idea
2 comments
-
Ben Sacheri
commented
Would you care to share the add-in that you created or at least provide a demonstration video?
-
dew
commented
Basically to avoid wasting time scrolling through a list of objects.
Like the search box in the Navigation Pane.
For example when selecting tables and views to create linked tables. Have a search box to filter list by using a contains filter. This would be ideal if it was implemented in all places when selecting an object from a list. For example:
When choosing a table or query to add to a query
When selecting a form or report to add to a sub form/sub reportAlso when typing in VBA should be able to get a list of tables or queries and then be able to drill down into the fields to insert directly into the code modules. The same with forms and reports.
I have implemented this functionality myself with add-ins and it has improved my productivity