Feedback by UserVoice

Ben Sacheri

My feedback

  1. 1 vote
    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) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    Microsoft, if you decide to add this, make it an option in Access or VBE. I've been burned by this but I also really like being able to step through running code and making changes to it.

  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    I know this isn't really answering your question, but here's a tip that I bet a lot of people never knew.
    If you select an Access object from the navigation pane and drag and drop it on your desktop, it will create a shortcut to that object. Clicking the shortcut will open MS Access and then open that object. I've known this for 15+ years but have never had a need for it.
    Maybe in a pinch you can figure a way to have your batch file call START to launch the shortcut file. YMMV.

  3. 66 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) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    I am confused by how this is worded. Do you want the confidential files to remain protected or do you want Access to be able to open them?

  4. 3 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) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    +1. This should be an easy, low-hanging fix for the Access team.

  5. 4 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) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

    It's very annoying that this list isn't sorted alphabetically. This should be an easy, low-hanging fix for the Access team.
    For those wondering, it is my guess that the list items are ordered in the order the controls were first added to the form/report. I think the developer is more likely to be looking for a named control than for the most recently added unnamed control.

  6. 83 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    Great request! Having this feature would allow me to build a "survey" interface where each row could be a different question type. One question could be fill in the blank, the next could be pick a radio button, and the next question row could be checkboxes. I built a database schema for this years ago and got stuck on this part. Without tons of programming the solution was to use a single record (not continuous) view but that hurt the user experience of being able to see multiple responses at once.

  7. 2 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 →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

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

  8. 308 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    Thank you for your feedback. This work is in scope to be completed within the next few months. The Access team appreciates your patience in advance.

    An error occurred while saving the comment
    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  · 
  9. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Ben Sacheri shared this idea  · 
  10. 11 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  · 

    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  · 
  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…)
    An error occurred while saving the comment
    Ben Sacheri commented  · 

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

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

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

  13. 3 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) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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.

  14. 21 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) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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/

  15. 114 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    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  · 
  16. 35 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) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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.

  17. 67 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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

  18. 9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

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

  19. 153 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Ben Sacheri supported this idea  · 
  20. 2 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 →
    An error occurred while saving the comment
    Ben Sacheri commented  · 

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

← Previous 1 3

Feedback and Knowledge Base