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 "Quick Filter" as feature on Continuous Forms

    Add the "Quick Filter" drop down menu that is on columns of a datasheet view as a feature that can be used on continuous form controls

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow report heights to be much greater than 55 cm.

    As some databases get bigger and more complex the need to report also gets more complex. If the structure of the database is very complex, the 55 cm maximum height for a report becomes insufficient and there comes a need to bodge the design by inserting lots of subreports, each with their own limitation in height. This can cause severe difficulties, particularly with page-breaks.

    Please remove the height limit.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Enhance SQL aggregate functions with DISTINCT (count distinct, sum distinct, avg distinct)

    The DISTINCT option for aggregate functions is actually missing.

    14 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 →
  4. Split screen in MS-Access

    For the development of modern and user-friendly programs a division of the window (split screen) in MS Access is desirable so that the window can be scaled user-dependent.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Make use of ACCDE much easier

    Currently it is a big problem to handle ACCDE files, if your users do have different versions of Access: Full or Runtime, 2010 / 2013 / 2016, 32bit or 64bit. Please support a "low level format" with a higher level of compatibility.

    6 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 →
  6. Read-Only Defaults for Tables and Queries

    I would like an option to make tables and queries read-only by default. This would be under Access Options, Object Designers, Table & Query design sections. Two settings:
    * Make Tables read-only in Datasheet view
    * Make new Queries read-only (Snapshot)
    Rationale: I deal with a lot of production data, and it would make my job considerably easier if I could make accidentally changing data much harder. Thanks!

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. More Controls are every time in the foreground (e.g. slider, speed) when you work with a sub form

    There are several controls that always in the foreground (eg. Speed, Slider, ..) appear and other controls can not be covered). This is very disturbing when programming.

    3 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 →
  8. Add native control for multiselect checkboxes

    Please provide a new native control for multiselect checkboxes like available in Excel for filtered columns.

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Fix Bug: Custom ribbon changes when recordset is set

    I use the uSysRibbon table and the custom ribbon works. The form it is attached to is unbound. Once the user picks a record from the combo box, I set the recordsource in code. And as soon as I do this, the ribbon CHANGES for no reason. If I bind the form, it's no problem. It is clearly the me.recordset="Select......" code that triggers this.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Multiselect-Combobox usable with SQL-Server-tables

    The multi-select-comboboxes are great, but only usable with native Access tables. Because I'm working with SQL-Server as backend, I have no use of that.
    Please make it possible to store the data within a normal text-field (e. g. as csv or XML). So it would be also possible to use it within tables of SQL-Server or other backends.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Restrict scope in endless and sub form to single record

    If you do some VBA in endless forms all changes of e.g. properties go to ALL "instances" of that form.
    So "rows" in an endless form are not separate objects and can't be handled separately.
    Conditional formatting helps (sometimes), but it's only "half of a solution".
    Like with .Parent it could be an idea to add .Record(id) to enable individual formatting and computing on single records of an endless form.

    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 →
  12. Codegenerator in class modules for property get and set/let methods

    In the VBE show a dialog where i enter the name of my private variable and the datatype to generate the two standard property methods.

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Changeable fontsize in the navigation-section for the objects

    Normally on the left side the developer can select an object. The names of them are too smal on large Screens.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Make it something better

    .Integration of real Treading
    -More and better Controls in the GUI (sample, Graphical Checkbox, Dataview with Hovereffect, multiline Headlines and integrated Imagecontrols like an Explorer
    -Autocompactfunction in Background
    -Expand maximum Databasesize
    -Autozoom of Images on Buttons
    -Button with Text and Image need a better function for positioning for the Image (like a Tab)
    - Windows without frame become a shadow
    - Transparentoption for every Control and Form (different Header, Detail and Footer)
    - new Framecontrol with Splitter
    - every Object become a identity Name so that i can used it without a long path over form and subform ...

    8 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 →
  15. Add row-id to queries

    Add a row-id field to all kinds of queries.

    1 vote
    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 →
  16. Drag & Drop etc.

    Drag & Drop function, reordering per Drag & Drop endless-formulars, time selector a' jquery - charts like in excel - outlook integration (kalendar object) ... you can take ideas from gambas3 linux there are many good objects

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

    Thank you for taking the time to post your suggestions. It is hard to respond as there are multiple items in your single suggestion.

    As for charts – we are actively looking into ways to modernize data visualization in Access.

    Stay tuned.

    Thanks,
    Michal [MSFT]

  17. Include Macro in Button Wizard for moving forms (and/or Access Application Window) from one monitor to another

    Basically, include native support for easy positioning and size of Access Application Window and Forms instead of requiring complicated API calls and code manipulation.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Improvement of SQL Azure DB maximum size (1GB) on Sharpoint Online

    My name is Yosiki-Tojo.
    I sometimes request an improvement of SQL Azure DB of Access Web.
    Now, upper limit size of this DB is 1 GB,
    This is very small of these day's business application.
    Anyone can understand that this is too small.

    Now, I have two prospects for Access Web.
    One is flower shop chain, other is clothing rental shop.
    They have large image datum for customer selection.
    However, I can't proposse Office 365 because of this limitation.

    I'll hope this limitation will be improve , such as 5GB or 10GB.
    Additional fee is OK.

    Thanks.
    Best Regards

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Make Content Fit Within the Visible Area of the Screen

    When I open a table in design mode, the windows opens and the right-hand side often goes beyond what is visible within the screen and will go behind the property explorer. This means every time I want to close the objects I have to move the object, often several times, before I can access the control box. Same goes for queries, forms...

    This is very poor ergonomics and makes accessibility very difficult. You have an available unused area (screen minus ribbon, minus nave pane, minus property sheet) use that and do not go beyond that unless I manually resize it…

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Enhanced Crosstab queries

    In crosstab queries besides count, sum, average etc., there is only the possibility to take either the first value or last value as VALUE. There is no support for concatenation of string values. It would be nice to have such a concatenation function or more generally a callback function where the user can decide how to transform the values.

    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 →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base