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. access 2016 crosstab

    Crosstables should never have been removed.
    It just doesn't make sense to have to export the data to Excel and if the data changes, we need to export again.
    Please bring it back

    57 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. Intellisense/Builder Improvements

    In Access I often use the criteria Intellisense/Builder to help me get the vba string to drill down to a deeply nested subform. But Intellisense/Builder gives up about 3 forms in. It would be nice to be able to drill down further with the help of this tool.
    I am by no means an expert at Access but over time have created several useful tools over the years, with the help of many Access experts on line. I created a very comprehensive vacation calendar used by over 200 people (tied to an sql back end) for my employer prior to…

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  3. Action Query: List specific records/columns that violate index or validation

    When running an action query, if records will be 'excluded' due to index or validation, give clear info as to what records & columns are causing the issue.

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  4. Refresh tables/queries while in Query Design View

    Add a way to refresh the columns listed in tables and queries being shown in the graphical layout of the Query Design View. A right-click, hotkey, or ribbon button would be nice.

    This scenario takes place when you are designing a new query that is dependent on other tables and queries. As you are working in Design View, you realize you need to make a change to a dependent table/query such as adding or renaming a column. Without closing the current query, you go and update the dependent object and come back to the open query. Now you want to…

    13 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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).…

    363 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    16 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    -Access Product Team

  6. Enhance Union-Query architecture that total field count more over 255

    Please re-design that a Union query of MS Access deal with more over 255 source fields totaly like 1024 or 65535 fields.

    8 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add Save As... back to the Query context menu

    In earlier version of Access, when you modified a query the context menu had the choices of “Save”, “Save As…” and “Close” in the context menu. Since the ribbon was introduced, the context menu only provides “Save” and “Close”, if you’ve made a change in the query and don’t want to over write the existing one, you have to go to the File | Save Object As route to get to the “Save As..” dialog box.

    20 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow to enter criteria at the join level

    Left join categories c on c.id = p.catgoryId and p.price > 100

    This can be done in most SQL DBs, including SQL Server, but is not allowed in Access

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  9. idea for fix of a query that stops working

    When sorting a query, I've found that if after sorting I then rename the query, the query stops working. It works again if I undo sorting. It seems the query is trying to sort the data according to the earlier naming of the quwery, even after the query has been renamed.

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  11. Seamless SQL Query engine

    It is really good to have (if not at the same level) basic MS SQL query syntax with Access. I see over the years it has never been updated.

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  12. RGB Colors in Format Code for Format Property in Query Column

    It would be nice to have more choices than the named colors (Black, Blue, Green, Cyan, Red, Magenta, Yellow, White) in the format code for the Format property of a column in a query.

    For instance, we can do this:
    [Blue]$ #,##0.00;[Red]$ #,##0.00;-0-

    so that positive numbers are blue, negative numbers are red, and zero is black ... but most of the named colors are too bright to show up well.

    It would be nice if we could specify an RGB value instead of only the limited color names.

    A bonus would be for the Format FUNCTION to also pay…

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  13. Abilty to add a drop down list for a query with criteria in square brackets

    Currently in a query if you use Square brackets you can get a box to pop up asking for information when the query is run. Allow a form & combo box to be attached so it can be customised for the data to be picked up.

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

    Please add a "Jet native" Coalesce() function, similar to the one in SQL Server ! NZ() has a lot of issues, like changing the data type, being slow.
    Using iif(xxx is null;yyy;xxx) works but is cumbersome, nad nearly unusable for chains > 2

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  15. Fix query engine issue.

    The sub query, (SELECT Min(Year) FROM tblInsuredInformation AS i1 WHERE i1.RecordID = tblInsuredInformation.RecordID) AS [First Year], in the query below returns various year values that make sense for the data in the database.

    The problem is that tblInsuredInformation doesn't have a Year field. It does have a FirstYear field.

    tblPRFPolicies does have a Year field but I have verified that the calculated FirstYear column is not returning either tblInsuredInformation.Year or tblPRFPolicies.FirstYear. It could be returning Year in some records and FirstYear in other records.

    If just SELECT Min(Year) FROM tblInsuredInformation is run, MS Access prompts for the value of Year,…

    2 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  16. Access Query Designer - fix/enhance behavior of layout window

    When a query opens in MS Access designer, quite often the window (query designer form) needs to be re-sized to be larger. When I drag the bottom of the window down, PLEASE keep the results fields selected "portion" (sub-form) the same size! This will result in the top area being enlarged, which gives me more room to view the contents lists of the objects selected (most often they are tables).
    Wouldn't it be phenomenal if the table lists would also automatically extend vertically?
    I spend a lot of time resizing my query designer windows. (e.g. please automatically enlarge the top…

    7 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  17. Column Order in Queries

    Is it really necessary to re-arrange the column order when I save a query? It tells me MS Access is reducing the QBE grid entries into SQL, optimizing that syntax and when asked for it later the presentation looks scrambled. While this may be needed internally, how much harder can it be to ask the internals to remember the column order?

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  18. improve ACE / eliminate or expand limitations

    Too many queries fail for obscure reasons. E.g., a crosstab that has a subquery somewhere in it. I bet there are already open defect on a lot of these issues from the JET days. Work them! Limitations like the 32 table limitation occasionally get in the way as well.

    (Again hating to spend votes on defects, but it is what it is.)

    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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  20. non editable System Queries For Listbox etc.

    Why not enableing the user to select "selected" columns / rows via Query - always looping thru itemselected is not very easy and intuitive.

    Similar is with queries about Tables, queries, forms, reports, indizes fields (like in combobox) and Macros and all the other collections.

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base