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. 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 →
  2. Make it possible to stop Access Desktop from being an Automation Server so that security is improved

    Currently, if a user has Access running, much of what is meant to be secured can be accessed from another program, e.g. Excel, via Automation. This is not good.

    19 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 →
  3. Provide a better link to Outlook especially for adding appointments

    I have always wanted to be able to add appointments to Outlook via the link to the PST file using an append query.

    9 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. 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 →
  5. Table column count to the same than in SQL Server

    It makes it much simpler to create applications if 254 column restriction is not applied like in Access. Unfortunately in Engineering system I can't avoid using more than 254 columns. Computer speed is not anymore a problem so why to have that limit.

    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 →
  6. 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 →
  7. MsgBox Custom Choices

    With MsgBox, we can process vbYes, vbNo and other built-in choices ... it would be nice to be able to have 3 custom choices ... ie: vbCustom1 and vbCustom1Caption, vbCustom2 and vbCustom2Caption, vbCustom3 and vbCustom3Caption,

    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 →
  8. 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 →
  9. Enable Ctrl-Spacebar to Popup Intellisense in Queries

    When designing queries, it would be nice if Ctrl-Spacebar could be used (as in VBA) to pop up intellisense when typing expressions, criteria, AppendTo, ...

    10 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 →
  10. Ability to Show Property Sheet and Field List at the Same Time

    This is not new ... just missed! We used to be able to show the Property Sheet and Field List at the same time ... I miss this a lot!

    12 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 →
  11. When switching back to design view from the IDE, select the last selected design object.

    When multiple forms are open and you go into the VBA IDE and then switch back to the GIU view, the object that was selected is no longer selected or the object that thew the VBA error is no longer selected. Furthermore, you can't just select the object from the tabs. You first have to select another object before you can select the one you want.

    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 →
  12. Easier way to backup data

    Please add a standard way to backup your tables to an external database ( file or SQL) on time or in the case of a certian event.

    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 →
  13. Make it possible to properly hide the Navigation Pane

    Currently this can be made visible programmatically from an external program via Automation.

    10 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. Ability to link refresh linked table to a server (SQL Server or Oracle) I have no access to

    In VBA if I want to change the .connect property to a server where I have no access, the tableDef.Refresh generates an error.
    I would like to be able to relink from DEV SQL Server to PROD SQL Server before deployment even when I have no access to PROD

    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 →
  18. Make Access again able to import / export / transform as many file types / legacy files like it used to

    Ability to open and convert .mdb was removed in Access 2013. Put that all back

    12 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 →
  19. 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 →
  20. Permit Access handle MultiCore PC

    Permit (from VBA?) to instruct a program to run in a specific Core; so if we have a 4core PC, we can run concurrently 4 programs.

    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