Feedback by UserVoice

I suggest you ...

← Access (Desktop Application)

Enhance the SQL Editor

Some features would be good to developers:
1) Tabbed SQL Query Windows - allow user to create a query window without binding to a query object (like we do in SQL Server)

2) Format the query field with highlighting, identation, colors and make possible to even resize the font size. .

3) Allow intellisense to get [table].[field] list (in A2013 we have it in Query Designer but no in SQL mode)

4) Split the window in SQL Query and result pane - and make it possible to see result in table or text format (like we have in SQL Server). So, we can click on "execute/run" and see both panels.

Thanks!

271 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    Allan John Neros shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    7 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • isladogs commented  ·   ·  Flag as inappropriate

        Also allow users to move direct to SQL view from the ribbon rather than first selecting design view

      • Bruce commented  ·   ·  Flag as inappropriate

        I wish they'd take out the thing that vomits unnecessary parentheses all over my WHERE clauses.

      • Mark Jaskula commented  ·   ·  Flag as inappropriate

        Pitty this won't go anywhere. You can always use SSMS to create your queries and then use passthrough SQL queries using something like the following hack:

        Dim qdf As DAO.QueryDef
        Set qdf = CurrentDb.CreateQueryDef("")
        qdf.connect = "ODBC;Database=tsfe;FileDSN=C:\settings\tsfe.dsn;"
        qdf.sql = queryStr
        qdf.ReturnsRecords = True
        qdf.ODBCTimeout = 0
        Set SQLOpen = qdf.OpenRecordset
        Set qdf = Nothing

      • Dolly commented  ·   ·  Flag as inappropriate

        We asked numerous times to enhance the SQL editor and they all been shot down. Just not going to happen any time soon, if ever!

      • RaymondC commented  ·   ·  Flag as inappropriate

        Complicated queries with multiple outer joins often require sub-queries. While this can be done in the SQL window, it would be nice if there was a way to do this in the designer window.

        It would also be nice if you could create SQL Server pass-through queries in the designer window and not just manually in the SQL window (or in code).

      • Mark Burns commented  ·   ·  Flag as inappropriate

        this request duplicate the basic point of at least 2-3 other requests already posted.

      Access (Desktop Application): Queries

      Feedback and Knowledge Base

      (thinking…)