Feedback by UserVoice

Ben Sacheri

My feedback

  1. 2 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 commented  · 

    I am out of votes but I agree that pass-through queries should be visible in the Linked Table Manager.

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

    Here's a video by Karl Donaubauer where he demonstrates the issue and shows ways to work around this problem. Our plea is for Microsoft to make this feature built-in to Access so no hack is needed.

    https://youtu.be/JTTsyNzY_i8

    Ben Sacheri supported this idea  · 
  3. 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  · 
  4. 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  · 
  5. 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.

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

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

  8. 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/

  9. 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  · 
  10. 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.

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

  12. 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?

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

  15. 80 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  · 
  16. 23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 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.

  17. 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  · 
  18. 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

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

← Previous 1

Feedback and Knowledge Base