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. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  4. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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…

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  14. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  16. search queries by date or part of the name

    for me it would be very useful to be able to search queries by date or part of the name

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
2 Next →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base