New VBA IDE Features
VBA Native line numbering
Adding line numbers is something that is a pet peeve. Line numbers should be Native and error trappable by default without having to add them manually.
VBA Accessible Call Stack
A way to read from the call stack, function/sub names in order accessed, times accessed...etc
VBA Custom Toolbars to allow custom Macro/Function Calls
If I could add my ow custom functions as a toolbar button and have my toolbar exportable and importable for others to use. As opposed to a full Add-In.
VBA button and/or right click to open SQL Editor
Frequently I need to use an SQL editor to evaluate or build a SQL String and it takes time clicking through to a query then changing that over to an SQL editor screen.
This could be eleviated with a quick access button or right click method from ANYWHERE. Almost any commandbar could benifit from this added functionality.
VBA Higher Level Access
BeforeDatabaseClose() event Please!
Collection level events that provide information about groups of entities. An example would be a public onEntityOpen(byval ObjectName as String) Event that fires for all objects of a certain type.
So Before a form/Report etc opens and runs it's own onOpen event you could run a higher level procedure to capture or set data without having to add any code at all to the forms onOpen Procedure.
Obviously it would know very little about the object being opened but none the less I can see uses for such a procedure.
James Lee commented
Several of these ideas exist at https://officespdev.uservoice.com/forums/224641-feature-requests-and-feedback/filters/top?category_id=164751 and the others shouldn't be combined into a single request.
Sorry, my comment should say "This is *not* quite what the OP asked for..."
These are all very good ideas.
This is quite what the OP asked for, but there is an "SQL View" button available for the Quick Access toolbar. File > Options > Quick Access Toolbar > Select "All Commands" > Find "SQL View" alphabetically in list > Double-click "SQL View" to add to Quick Access Toolbar. Once this button is added to the QAT, you can select any query in the Nav Pane and then click the button to open it directly in SQL view (assuming the QAT is visible). Alternately, you can use the keyboard shortcut Alt + V + Q (assuming full shortcut menus are enabled).
However, including an "SQL view" option in the right-click context menu for queries would be fantastic.