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. DSN less connection wizard

    Please design a wizard for dns-less coonections to SQL databases. Make it easier to use Access as frontend devolpment for different situations.
    Other RAD tools have this already.

    11 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. Join desktop and web database into a single solution that renders HTML5 user interface

    When database is created it should be possible to use it as a desktop database or to publish it onto for example IIS for a web usage without any changes to it. The publishing engine should be capable of rendering forms as a HTML5 user interface. VBA functionality should be interpreted as server side and or client side VB Script. Probaly forms should be saved as XML for that purpose.

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

    I have three version of MS Access - 2013, 2010 and 2007. I need this so if I develop a DB with library references (in particular the MS Excel library) and it has to work in an earlier version of Access (so if I developed it in 2013 but it has to work in 2010) I have to open it in 2010 and make sure the references are not missing before giving it to a user. I have tried multiple times to write code that will try and remove the missing reference and add a valid one but why? These…

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    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. MouseOver Highlighting on controls and continuous forms

    Should be able to have a property for controls that can highlight when mouse passes over other than a button. Similar to Windows 10 Start menu or other Windows menus. This should also be allowed for a single row on a continuous form. Perhaps this could be a property in conditional formatting.

    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. Multiple Positioned SubForms with Sizers

    Allow a form to be MDI(or similar) so that you could place multiple subforms in a single form with framing, positioning and resizing… like Outlook

    8 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 →
  7. Improved Table Manager

    Create an enhanced table manager that allows users to specify data source (sql, access, txt etc), source table name, attached name, any passwords (encrypted or hidden) and primary keys so that the system will drop existing links and refresh as needed. You would need a couple of tables for data sources and data source tables but many developers have done this over the years and lots of examples that could be incorporated. This is used all the time.

    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 →
  8. Cache all query results locally while in Design view for forms/reports to improve performance.

    Sometimes queries can be expensive, or have errors affecting performance. Currently, if one of these expensive (i.e. very slow) queries is in a form's or control's Data source, (like a Combo Box, for example), that query can be re-evaluate repeatedly and frequently (very slowly EACH TIME) making any effort to edit or design the form a legitimate pain in the keester. Give us the option to cache these query results during development (Design View) so we can work FAST, like Access is supposed to!

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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 →
  10. Touch screen compatible lists, scroll bars, etc.

    A lot of my clients want to be able to use Access forms on a tablet or touch screen. The controls really need updated to be compatible with touch!!! The worst offenders are scroll bars with list boxes and combo boxes close behind.

    129 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 →
  11. Make SQL and QBE Smarter


    1. When a query that selects identifiable rows joins to a query that aggregates data, allow rows in the identifiable part to be updated rather than making the query non-updateable. Extend this to heterogeneous joins so if one table in the join is updateable but another is not, allow updates to the updateable one.

    2. Stop smothering expressions with excessive numbers of parentheses. There is no reason that I can think of that would require an individual column name to be enclosed all by itself in parentheses.

    3. Stop reformatting MY SQL strings. I have a work-around for this but it is iffy.…
    31 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 →
  12. Provide an easier method to return or pass property values to a dialog form

    I understand this would require a re-wickering of Access forms, but this is difficult to accomplish in Access without some serious workarounds. At least have something like a Dialogresult property as in .Net so the user can get simple values from the dialog form when closed.

    0 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 →
  13. add Align Objects Center and Align Objects Middle

    These buttons would work they way they do in other Office products.

    Also, rename Align Left|Right|Top|Bottom for objects to include the word object. Align Left, for instance, is the tooltip for 2 very different things.

    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 →
  14. Open Query in SQL View

    Please give us the ability to open a query in SQL view directly.

    Also, when designing a query, don't process the records until we go to Datasheet View.

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Permit the Properties Window to be displayed in Form View again

    In Access 2003, an object on an open form could be right-clicked | Properties chosen, and then the [Event Procedure] of the object could be displayed. This allowed the developer to open the code behind an object while the form was open and working. This was highly productive for the developer, as the code for open objects could be adjusted, tests run, and further objects adjusted and so on.
    This was removed from Access 2007+ and is a HUGE drag on developer productivity as either the form must be constantly shifted back-and-forth from Design View to Form View --losing the…

    4 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 →
  16. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add capability to call stored procedures with DAO

    Please add the capability to call stored procedures in a remote ODBC database with DAO, like it existed in the past with ODBC-Direct-Workspaces.
    Pass-Through-Queries are only a kludge because parameters have to be concatenated into the sql string.

    21 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 →
  18. Add a new operator to Group By queries

    Let's call it something like "Concat". It would concatenate values in a field instead of summing them.

    Take this query:
    SELECT Product, Concat(Color) FROM ProductColors GROUP BY Product. The result might be something like this:

    Flag Red, White, Blue
    Tractor Green, Red

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Make it easier to select and change printers

    Especially important if user has runtime Access and/or maybe using an accde file.

    39 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 →
  20. Enhance Vertical Text to turn 90, 180, 270 degrees

    Idea here is, that you should be able to turn text a) not only top to bottom but also b) flipped and c) bottom to top

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base