Views: 85 Size: 442.2 KB">QueryAndFormExplorer-davegri-v01.zip
Example use: The actual Download will have none of these sample objects.
Microsoft should have provided enhanced query editing functionality to Access years ago, but has as yet not done so.
Any Access database with a dozen or more queries or a few forms with various comboboxes and listboxes can become
a struggle to organize during development as changes to tables, object names, adding new lookup tables and the like occur. This
utility will consolidate the management of queries and form combos and listboxes into one place for significant
improvement of convenience and accuracy.
To use the utility, simply copy the 3 forms to your project.
An ideal way to automate the copying is to save the utilitly as a .accdt (template) file. It will then
be available via the ribbon CREATE > APPLICATION PARTS which allows you to instantly copy
template objects into your DB, new or old. Check it out; Bing or Google, it's very handy.
The Utility consists of 3 forms. The 3 forms contain all the necessary VBA for the project, so there are no code modules or macros.
The main form has 2 tabs, each containing an additional form, one for queries and the other for forms.
The 'Query Explorer' tab can speed the viewing, editing and creation of query SQL in your project.
The 'Form Explorer' tab can speed the viewing, editing and creation of SQL strings or value lists used as the
rowsource for combo boxes and listboxes on your forms. You can hover over some controls for tips.
Nothing is changed in your DB unless you click the 'Update Query', 'Update Control' or possibly 'Test the SQL' buttons.
The form sizes are optimized so that monitors with 768 vertical resolution will display without
scroll bars. It may be necessary to use CTRL+F1 to toggle the ribbon to provide needed vertical space.
I realize there might be additional functionality included in the utility such as a global search of all form control's rowsources
in the DB, but with additional functionality comes additional user interface and complexity.
In many cases, added complexity actually reduces usability for users instead of enhancing it, so I set limits.