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. Major bug in all versions of Access: handling of ESCAPE key

    n all versions of Access that I am aware of, going back at least to Access 2000, the escape key cancels queries (whether select, update, append, etc.), and recordset operations (running in VBA).

    On the surface this may be fine, but there is a major bug in the implementation: Access "listens" for the escape key regardless of whether it has the focus or not.

    So for example, if you have a long running append query and then open Excel, Word, Outlook, or even your browser (any software, presumably), and hit the Escape key to cancel an action in that other…

    29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. New Linked Table Manager – Suggested Improvements, Fixes, and Relative Path Relinking

    Suggested Improvements & Fixes for the NEW Linked Table Manager (now available to Office 365 Insiders and Office 2019):

    First, I want to say I really appreciate the new Linked Table Manager in Access (as available for Office 365 Insiders and Office 2019) and it's many incredible improvements. However, I have some suggestions to improve usability, address issues and add functionality to it:


    1. Remove / Clarify Repeated Relink Table prompts when Change Data Source Path

    Clarify "Do you want to relink the selected tables in the new data source" as for optional table renaming and replace "Cancel" button for Relink…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  3. data connector sql server

    ADD SQL SERVER AS A DATA CONNECTOR - The Access team is currently evaluating the use of data connectors in Access, (https://youtu.be/j5UAv4yY5RY?t=2155), and we need your support to get them to include SQL Server as an option! PLEASE VOTE for this idea, every vote counts!

    554 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    45 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Fix Confirmed Bug: Report Controls Jump Elsewhere When Moving

    In Access 2010, 2013, 2016; when a report in design view exceeds a certain size overall (this has nothing to do with the 22" section maximum), try to move any type of control in the lower sections and it suddenly jumps elsewhere.
    This has been confirmed in forum post https://social.msdn.microsoft.com/Forums/office/en-US/a2db2cd7-f02b-4317-a663-e6a4dbb78cb9/report-controls-jump-elsewhere-when-moving?forum=accessdev. This post contains a link to a sample database that demonstrated the problem.
    It has also been confirmed via a support incident with Microsoft. The technical lead called it 'an Regression, an product defect' and asked that I post it here. It continually baffles me that when bugs are…

    33 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  5. Enable seamless integration with Excel objects

    In light of the items requesting return of Pivot*** objects (https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/10284183-add-pivot-charts-back-to-access) being rejected, I want to suggest an alternative that I hope is much simpler to implement and would bring better experience:

    Ability to seamlessly embed Excel objects, be they tables, charts, pivotcharts, pivottables, directly inside Access.

    This already exists but it is very awkward, outdated, and includes unwanted things (e.g. Excel's chrome, the spreadsheet itself and so forth). This solution should allow us to define an Excel object using Access data and show it as if it was just a normal Access control. It should allow us…

    172 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Distribute Access apps on windows store

    So that Access apps will run on Windows 10 S. I am following the launch of Windows 10 S with great interest. I am writing to this forum today to find out what the Microsoft best practice is for migrating Access applications complied to work with Microsoft Access run time (or some other method) to Windows Store apps (aka Windows platform apps) that could be offered in the Windows Store and would run on Windows 10 S and all versions of Windows 10? Since most Access apps are used within an organization it is likely that most Access Windows Store…

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Continue and extend backend functionality from AWA in Access Desktop

    Given the fact a decision on AWA has been taken, here's I think what the development team should do. 1. Make AWA datamacros available in Access Desktop 2. Extend with support of Update/Create/Delete Queries in the query designer. 3. Explode functionality by making datamacros that return just one value available as functions within expression builders of queries and datamaros 4. Support the database qualifier in front of tablenames the way it is already available in SQL-Server between databases. this way users can integrate AWA managed and non-AWA managed very easily. (integration with CLR SQL-server projects and other tools that generate…

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Enhance the SQL Editor

    Some features would be good to developers:
    1) Tabbed SQL Query Windows - allow user to create a query window without binding to a query object (like we do in SQL Server)

    2) Format the query field with highlighting, identation, colors and make possible to even resize the font size. .

    3) Allow intellisense to get [table].[field] list (in A2013 we have it in Query Designer but no in SQL mode)

    4) Split the window in SQL Query and result pane - and make it possible to see result in table or text format (like we have in SQL Server).…

    329 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  9. Improve Access programmability

    There are many new technologies available that Access cannot take full advantage of because it's either in .NET or requires JavaScript.

    Excel has a JavaScript API being developed and expanding. Using JavaScript would allow for richer integration between desktop and web apps where appropriate.

    On the other hand, native access to .NET framework would provide access to many other components that Access can leverage for automation.

    What we can't do is just stay behind in COM world - COM ecosystem is shrinking and we need a solid integration support especially when our Access application only requires a small part to…

    447 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  10. Provide a native Treeview control

    The Treeview control is an extremely powerful way to display related and hierarchical data in a nodal fashion. I have built application for years using the vb Treeview common control. These applications could not be successful without it. There is certain data such as a computer folder and file structure that would be nearly impossible to comprehend without it., However, the non native Treeview require serious knowledge of Access and VBA to use successfully. Also portability has always been a problem. A native control with some features that make binding data simpler (possibly a wizard), would really expand what the…

    500 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    40 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Incorporate Power BI as an Add-in to New version of Access 2017

    Since Pivots & Charts have been removed from Ver 2010 onwards, its been a big problem for us consultants to provide charting and pivoting features to our customers. These are features simply adored by our customers due to their ease of use. But after looking at Power BI I feel since its from the same Microsoft family the Access Team should consider incorporating it in their Next Product Planning process.

    494 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    34 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Upgrade the Date Picker

    Please give us a full featured built-in date picker which allows quick pick of a month and year and which can be interacted with through VBA.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for posting.

    The team has reviewed this ask (and other related suggestions) and we will add it to a ‘Customer Wish List’.
    It will be prioritized and added to our backlog.

    Closing this item so you can get your votes back. You can continue to add comments to show your support and share your ideas.

    Thanks,
    Michal [MSFT]

  13. Zoom ... Design View for Forms/Reports and Form View, Report View

    It would be really nice to ZOOM the Design View for forms and reports ... and also Form View, with a slider.

    For example, Print Preview has a zoom slider in the lower right.

    Also, Report View should be able to interpret Ctrl-Mousewheel since so it can really be more like a web page

    201 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Checkbox Alignment

    When creating forms and reports, checkboxes should be centered in the space, not aligned at the upper left

    93 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Reviewed for future consideration  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  16. Access 2016 Dragging Queries into Macros crashes Access

    When creating macros in Access 2016 if you drag a query into the macro into white space it works fine and adds the query however if you happen to drag it over another query access with crash, no errors or anything just crash out.

    I recreated the issue in our environment with a blank database to remove any other variables that our production databases may inject to the issue and I get the same behavior.

    I've also tested on a fresh windows install with Office 2016 installed from the office 365 portal.

    Users on the access for developers forums were…

    16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Create and promote a website for Access developers to list their applications and services.

    MS already has a website for Access MVP's, but other ISV's, VAR's and developers who are not MVP's need a centralized place for consumers to search for a solutions provider. MS can provide a disclaimer on this website stating they're not responsible or endorsing any particular listing.

    .. And while you're at it, create a separate category or page for "Access Marketing" ideas so that we don't have to mix these kinds of ideas with product improvements.

    59 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for posting and for the interesting conversation.

    Without taking an active part in this discussion, or making a corporate statement, I’ll just say that the Access team values our MVPs and their on-going contribution to both the product team and the broader community.

    as for Frank’s suggestion – it’s a great one, and we’ll look into it. Thanks!

  18. GUI contrast

    You have to improve the contrast used within the GUI. Whether it be in the VBE or Nav Pain (sorry I meant Pane), when you select an object and the open it, you can't make out which object was selected. It is horrible. And much worse on laptop and tablets. It should pop out at the user. I should need to scroll, move up and down to figure out what is currently selected as is presently the case.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Reviewed for future consideration  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Relinking a Data Source, Table Name refresh confusing

    The prompt that you receive when relinking to a data source regarding relinking table names seems inconsistent and confusing. If you end up trying to relink a data source and choose the same data source as original, you do not get a prompt. If you choose a different source, you get a prompt which asks whether you want to relink the selected tables. If you choose NO then it does refresh the links to each of the tables. If you choose YES you get prompted for the name of each table. If you are relinking to the same source, you…

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  20. The Linked Table Manager is not an option in a database with no Linked tables

    Since it now has an Add button, I do not see why this should be the case. Thus, for now, adding a link to your first table needs to be done the old way – through New Data Source.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base