Feedback by UserVoice

Access (Desktop Application)

Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Ability to link refresh linked table to a server (SQL Server or Oracle) I have no access to

    In VBA if I want to change the .connect property to a server where I have no access, the tableDef.Refresh generates an error.
    I would like to be able to relink from DEV SQL Server to PROD SQL Server before deployment even when I have no access to PROD

    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  ·  Flag idea as inappropriate…  ·  Admin →
  2. Make Access again able to import / export / transform as many file types / legacy files like it used to

    Ability to open and convert .mdb was removed in Access 2013. Put that all back

    12 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  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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  ·  Flag idea as inappropriate…  ·  Admin →
  4. Permit Access handle MultiCore PC

    Permit (from VBA?) to instruct a program to run in a specific Core; so if we have a 4core PC, we can run concurrently 4 programs.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  5. Retain Window Size When Object Opened

    When objects are opened, it would be nice if Save also saved the window size (and, optionally, placement)

    8 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  ·  Flag idea as inappropriate…  ·  Admin →
  6. Improve design speed on databases with lots of tables attached

    On some clients site I have been working, it's quite frequent to have 200 more linked tables pointing to 2 or 3 different servers (MS or Oracle). In such databases, switching forms/reports to design mode can take a minute or more, clicking in design view in a subform (or back to the main form) takes enough time to grab a coffee. It's often faster to close and reopen in the desired mode than to switch modes.This should be really improved.

    5 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  ·  Flag idea as inappropriate…  ·  Admin →
  7. Open Macros in a Narrower Window

    When the macro window opens, it is much wider than it needs to be
    If people write long comments, they can make it wider at that time.
    If the Action Catalog is displayed, the window is so wide that you can't see the scrollbar

    5 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  ·  Flag idea as inappropriate…  ·  Admin →
  8. Access Function to return Current GMT

    for proper date control, it would be nice to store a GMT date/time instead of Now() in the current time zone

    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  ·  Flag idea as inappropriate…  ·  Admin →
  9. Return Expression Builder to VBE

    Make Expression Builder available from Visual Basic Editor, as it used to be in Access 97 and before.
    Currently it can be opened only from query design view..

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Show Tools Vertically

    When the ribbons began being used, we lost the ability to display the toolbox vertically. Despite using the ribbon for several years now, I have not gotten faster at picking up the right tool quickly.

    When the toolbox could be displayed vertically, I practically didn't even have to look at the tools, I knew where they were positionally.

    It is much faster to design when the toolbox can be vertical.

    thanks

    2 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  ·  Flag idea as inappropriate…  ·  Admin →
  12. Save Last Path Used

    When Browsing for Importing, Exporting, or whatever, it would be nice to be able to have an option to use the last directory used -- even if the database has been closed.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  13. Show Columname at top of Property Sheet in Query

    It is difficult to figure out which column of a query that properties are being set for. It would be nice to show the column name at the top of Property Sheet in a Query

    thank you

    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  ·  Flag idea as inappropriate…  ·  Admin →
  14. EnableEvents

    Currently, if a database is opened through code, it requires gymnastics to avoid running startup stuff. It would be nice for Access to have EnableEvents like Excel does

    thank you

    3 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  ·  Flag idea as inappropriate…  ·  Admin →
  15. System help forms - allow resize

    Lots of system help forms (i.E. on Query the search table or the references form in VBA to search DLLs ) are far too small and the user cannot resizre them, why ? Just allow to pull them bigger would help

    3 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  ·  Flag idea as inappropriate…  ·  Admin →
  16. Code Window in Form Design

    Instead of separate window where coding takes place outside of form design, have it as a window positionable beside or below the form design.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Intellisense/Builder Recognize Table/Query Aliases

    It would be nice if Intellisense/Builder would recognize Table/Query Aliases

    2 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  ·  Flag idea as inappropriate…  ·  Admin →
  18. QAT Filter

    There are lots of commands to choose for the QAT and finding what you want can take time. It would be nice to be able to filter the choices

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. Save/Restore Workspace

    Excel has an option to save and restore the workspace, which is very convenient for opening all the files and positioning them where they were before. With Access, of course, this would be objects in the current database instead of files.

    2 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  ·  Flag idea as inappropriate…  ·  Admin →
  20. BrowseTo add parameter OpenArgs

    Why not have an OpenArgs parameter like in docmd.openform ? Would enable to react in forms based on OpenArgs - especially helpful when you want to open a form on several places with different actions.

    3 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  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base