Feedback by UserVoice

Ben Sacheri

My feedback

  1. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Ben Sacheri shared this idea  · 
  2. 183 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    49 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

    This is affecting a lot of people! Ugh.

  3. 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 commented  · 

    I'm not sure why this was happening to me, but I found a work-around. I exported all of my registry settings from this path:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\16.0\Access\Menu Add-Ins

    Then I edited the .reg file and changed all of the paths to begin with:

    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Menu Add-Ins

    and ran that .reg file. Now my add-ins aren't disappearing when Office updates are installed.

    Ben Sacheri shared this idea  · 
  4. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Ben Sacheri commented  · 

    I'm out of votes but I would like to have more descriptive error messages.

  5. 9 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 commented  · 

    I'm out of votes but I would like to have more descriptive error message that tells what column I should focus on.

  6. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

    I'm out of votes but I would like to have more descriptive error message that tells what column I should focus on.

  7. 17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

    I made a form that can tell you what how many more "databases" you can open. The max is probably 255 but after internal objects load I start with around 242. Every open table uses a connection. Every linked table uses 2 connections. The counts may not always add up as you would expect.

    Think of my form as a "gauge" to help you see how close you are to running out of connections. Using this information you can focus on which objects to optimize to use less connections.https://access.wordpress.com/2014/04/01/how-many-database-connections-are-still-available-in-an-access-database/

  8. 98 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Ben Sacheri commented  · 

    It's a no-brainer that Microsoft should add JSON support. It's an industry standard. What are they waiting for?

    Ben Sacheri supported this idea  · 
  9. 28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

    This would save me a lot of time when importing data to tables with lots of columns.

    My method of finding the column with the error is to remove groups of columns from the query, run it again to see if it still fails, and repeat until I narrow down columns to find the one generating the error.

  10. 65 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

    As a work around I assembled some code into a class module that will add features to any Listbox so the column headings will sort when clicked and the column widths are adjustable (to some degree)

    Adding the class and a few lines of code to your form will enable these features to any existing listbox. See the instructions at the top of the code:

    https://pastebin.com/JgPDwhn1

  11. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Planned  ·  3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

    Are you referring to tabbed windows of the Access MDI, or are you referring to the Tab control?

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

    Would you care to share the add-in that you created or at least provide a demonstration video?

  14. 69 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    22 comments  ·  Access (Desktop Application) » Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

    @John, You got my vote, and thanks for suggesting a work-around. I found this post after Googling this problem.

    Ben Sacheri supported this idea  · 
  15. 20 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 commented  · 

    I'm adding a suggestion that this feature work in Continuous Forms view, where the filter can vary from row to row.

  16. 1 vote
    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 shared this idea  · 
  17. 3 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 commented  · 

    Consider using ALT+D, I

  18. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri shared this idea  · 
  19. 99 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri commented  · 

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

  20. 20 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 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.

← Previous 1

Feedback and Knowledge Base