Feedback by UserVoice

Ben Sacheri

My feedback

  1. 137 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    In preparation for the future, it would be nice if Microsoft would add support for this.

  2. 24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    There are ways to do this already, but I agree that a built-in method would be helpful.

    One way I do this is to create a large textbox behind all of the controls in the detail section. I create a hidden textbox control in the form header that has the current record ID as the control source. Then I apply conditional formatting to the large textbox when the record ID of the row is the same as the hidden textbox. There are plenty of examples of this available online.

    The disadvantage I've experienced with this method is extra screen flicker when changing records. I think Microsoft could add a property to the format tab of the Form Detail properties for Selected Back Color (similar to the implementation of Alternate Back Color). Their implementation should be faster and have less overhead than my method that flickers.

  3. 363 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    16 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    -Access Product Team

    An error occurred while saving the comment
    Ben Sacheri commented  · 

    Save your votes. This has already been set as [NO CURRENT PLAN] in a similar issue.
    https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/10263849-provide-a-better-sql-editor

  4. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    @David: While you're waiting you should check out this Enhanced Message Box Replacement. It's open source so you can adjust the dimensions yourself. It also supports Rich Text.
    http://blog.nkadesign.com/2008/ms-access-enhanced-message-box-replacement/

  5. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  6. 32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  7. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  8. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    Do any of the home grown progress bars update as a big query is running?

  9. 12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  10. 29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  11. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    Native support for this would be nice as part of a source control feature.

    I built an add-in that lets you select Access objects and save/load them as text files. Here's the code that handles Query objects:

    fWriteStringToFile(CurrentDb.QueryDefs("QueryName").SQL, strSaveDir & fValidFilename("QueryName" & ".sql"))

    Private Function fWriteStringToFile(strString As String, strFilename As String) As Boolean
    ' Take the passed String and write it to the passed filename.
    ' This is very simple and overwrites if the file already exists.
    ' I originally wrote this so I could export the SQL of a QueryDef object to a file.

    Const ForReading = 1, ForWriting = 2, ForAppending = 3
    Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0

    Dim fs As Object
    Dim f As Object
    Dim ts As Object

    On Error GoTo ErrorHandler

    fWriteStringToFile = True

    Set fs = CreateObject("Scripting.FileSystemObject")
    fs.CreateTextFile strFilename ' Create a file with the passed name (and path)
    Set f = fs.GetFile(strFilename)
    Set ts = f.OpenAsTextStream(ForWriting, TristateUseDefault)
    ts.Write strString
    ts.Close

    Exit_Function:
    Set ts = Nothing
    Set f = Nothing
    Set fs = Nothing

    Exit Function

    ErrorHandler:
    fWriteStringToFile = False
    MsgBox "Error #" & Err.Number & " - " & Err.Description & vbCrLf & "in Function fWriteStringToFile()"
    GoTo Exit_Function
    End Function

  12. 46 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    I would like to recommend you look at the "Access SQL Editor" add-in from Field Effect, LLC which supports:
    ◾Syntax Highlighting
    ◾Comments
    ◾Line numbers
    ◾Search-and-replace, with regular expression support
    ◾Poor Man's SQL Formatter integration
    ◾Only $5

    http://fieldeffect.info/wp/access-sql-editor-documentation/
    (I am a user, not the author)

  13. 239 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    24 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    Ebo [MSFT[

    An error occurred while saving the comment
    Ben Sacheri commented  · 

    I would like to recommend you look at the "Access SQL Editor" add-in from Field Effect, LLC which supports:
    ◾Syntax Highlighting
    ◾Comments
    ◾Line numbers
    ◾Search-and-replace, with regular expression support
    ◾Poor Man's SQL Formatter integration
    ◾Free trial. Full license is only $5.

    http://fieldeffect.info/wp/access-sql-editor-documentation/
    (I am a user, not the author)

    Ben Sacheri supported this idea  · 
  14. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    +1 for MZTools

  15. 38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    Check out the Enhanced Message Box Replacement by Renaud Bompuis. It supports HTML formatting and custom button naming. The source code is available and easy to modify.

    http://blog.nkadesign.com/2008/ms-access-enhanced-message-box-replacement/

  16. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 
  17. 31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application) » Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    Traci,

    I have created an editable crosstab based on the blog posting from Alisa. I created two YouTube videos so others could see how it works.

    5 minute quick demo
    https://www.youtube.com/watch?v=6kOVw8tLSJ8

    1 hour demonstration and troubleshooting session
    https://www.youtube.com/watch?v=paF2NVaI01s

  18. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
    Ben Sacheri shared this idea  · 
  19. 136 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
2 Next →

Feedback and Knowledge Base