Feedback by UserVoice

Ben Sacheri

My feedback

  1. 23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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.

  2. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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/

  3. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  4. 31 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  5. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  6. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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?

  7. 12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  8. 29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  9. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

  10. 45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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)

  11. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

  12. 36 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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/

  13. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  14. 31 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

  15. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  16. 129 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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