Feedback by UserVoice

Rodger Beard

My feedback

  1. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Rodger Beard shared this idea  · 
  2. 429 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Rodger Beard supported this idea  · 
    Rodger Beard commented  · 

    Most of all, I would like to see a migration path from MS Access using SQL Server to VB 6. Starting with some sort of integration of MS Access into Visual Studio.

    But within the current VBA UI, how about style sheets to apply color coloring, auto indenting, etc. according to customizable rules? Redgate does this very well with their SSMS addin SQL Prompt.

    How about applying above to those super ugly, almost impossible to read SQL statements that display when you click RecordSource or RowSource in a form's properties or the SQL view of saved queries?

    When I want to debug anything complex,especially queries I've developed with the Design UI but need to debug in a SQL syntax window, the first thing I do is copy the source into NotePad++. Then clean it up so it's actually readable. Of course when I save my easy to read code back Microsoft usually does what it does, and the formatting gone.

    Lately I've been saving my queries in text files until I know whatever I've working on actually works right in all conditions.

    I've been a developer a long, LONG time and can't believe this is still necessary.

Feedback and Knowledge Base