Enable Ctrl-Spacebar to Popup Intellisense in Queries
When designing queries, it would be nice if Ctrl-Spacebar could be used (as in VBA) to pop up intellisense when typing expressions, criteria, AppendTo, ...

6 comments
-
Mark Burns commented
I would request that this idea (and the the votes for it) be merged into the other requests for general improvements to the Query Designer SQL view.
here: http://access.uservoice.com/forums/319956-access-desktop/suggestions/10130526-allow-jet-ace-sql-to-support-multiple-sql-statemen
here: http://access.uservoice.com/forums/319956-access-desktop/suggestions/10263849-provide-a-better-sql-editor
and here: http://access.uservoice.com/forums/319956-access-desktop/suggestions/10159107-sql-view-add-replace-to-edit-mode -
Patrick Honorez commented
And I would LOVE if the generated SQL statements could be readable: less unnecessary parenthesis, every JOIN starting on a new line.
-
Crystal commented
Intellisense doesn't always kick in -- sometimes we have to trigger it. In VBA, we can do that with the shortcut key. Even in the Builder, intellisense is limited and it would be nice for it to be in more places for more things.
-
In A2013 (not sure about <A2013) ... isn't there already Intellisense?
Or are you saying you need Ctrl-Spacebar to pop it up ?
Or both ? -
Crystal commented
It would also be nice for intellisense to recognize aliases
-
Patrick Honorez commented
indeed, a decent editor for queries in SQL view should be warmly welcomed.