Access (Desktop Application)

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Stop randomly omitting text in reports

    Sometimes, MS Access reports silently omit lines of text. This bug exists since at least Access 2007, and it's very annoying -- customers have to manually double-check every invoice to make sure that everything important has actually been printed.

    The bug is well-known (see, for example, StackOverflow questions 10612364 and 14716048, SuperUser question 455782, MSDN thread 648dd3a2-28c1-4f0d-853c-ef932c58519f, or Microsoft Support Cases 114032111284860 and 115072312971316), but, apparently, has not been considered important enough to be fixed.

    20 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)

      Thanks for reporting.
      We will add this bug report to our backlog and see that it is prioritized and handled.
      In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

      Thanks,
      Michal [MSFT]

    • Restore Pivot Tables to Access!

      I work at a major US airline. I have been charged with creating major database work using MS Access. Pivot tables are vital to the amount of varied data with which we work. Pivot tables are vital...please restore.

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
      • Sell Works again. Office is too much for me and I only need what was in Works.

        I loved Works. I could do anything I wanted with it.
        I don't work in a position to use all that is in Office.
        In my home, Works does everything I need.
        M. Craft

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
        • Add Pivot Charts back to Access.

          The original Pivot tables and Pivot Charts in Access 2007 were very easy to use and a great benefit to builders and users. I am still using 2007 for that very reason, since I have many applications that rely on the pivot functionality and I am a great believer in graphical representation using Pivot Charts.

          696 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)

            Thanks everyone for voting and supporting this suggestion.
            As you are all aware, Pivot Charts and Pivot Tables have been removed from Access 2013 because the technology they relied on was deprecated (Office Web Components).

            Voting and commenting on this suggestion (and on this https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/11510094-put-pivot-tables-back-into-access-surely-a-databa) has been very valuable to us to distill the requirements and needs.

            Since Pivot Charts as we all know them, will not come back to Access, we are updating the status accordingly and would like to encourage you to continue and use your free votes to support other suggestions.

            Thanks,
            Michal [MSFT]

          • 1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
            • 3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
              • Discontinue this garbage

                Discontinue this garbage. What were you thinking ? Can't even execute a really simple SQL statement. That's after clicking on 17 buttons to get to the Query Text Editor. Did you design Access to be bad and cumbersome on purpose ? My blood is boiling ! You have no Idea ! I so regret buying this rubbish. Never again !

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                • Provide a native Treeview control

                  The Treeview control is an extremely powerful way to display related and hierarchical data in a nodal fashion. I have built application for years using the vb Treeview common control. These applications could not be successful without it. There is certain data such as a computer folder and file structure that would be nearly impossible to comprehend without it., However, the non native Treeview require serious knowledge of Access and VBA to use successfully. Also portability has always been a problem. A native control with some features that make binding data simpler (possibly a wizard), would really expand what the…

                  257 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)

                    Hello TreeView Supporters,

                    Thanks for the information!

                    We know that one of the issues that users had with the TreeView control was around 64bit support. Just wanted to let you know Microsoft will have a solution released for that soon.

                    Thanks,
                    Michal [MSFT]

                  • Enable multiple versions of Access to co-exist on the same machine.

                    Enable multiple versions of Access to co-exist, side by side, on the same machine without ill effects.
                    Just like there can be multiple versions of Visual Studio, SQL Server, etc. Currently, to work in different versions of Access we need to maintain a separate machine (physical or virtual) for each version of Access.

                    82 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      9 comments  ·  Other  ·  Admin →

                      Hi Alphonse,
                      It is not clear what is the problem you are encountering. Going through the comments other Access users left here, didn’t help figure it out as well.
                      To the best of my knowledge there shouldn’t be an issue with running multiple versions of Access on the same machine, so I’m closing this request.
                      If you feel strongly about it and can provide more information, please create a new request.

                      Thanks,
                      Michal [MSFT]

                    • If you are not going to be fully committed to developing and improving Access- Make it Open Source

                      A least bring in the top developers to have a serious discussion the Many issues with Access.

                      16 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Admin →
                      • Put Pivot Tables back into Access. Surely a database should be able to analyse data, including text fields. This cannot be done in Excel.

                        Put Pivot Tables back into Access. Surely a database should be able to analyse data, including text fields. This cannot be done in Excel which can only handle numeric data. Our business uses them extensively and currently we cannot find an alternative.

                        324 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                        • Put the ADP file option back into Access 2013 and beyond...

                          ADP's provide a simple connection to SQL server. In addition, Forms and reports have properties that simplify retrieving data.

                          95 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                          • Integration of vb.net for programming

                            Nativ Support for SQl Server

                            65 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Admin →
                            • Add the facilities and features of Power Query and Power Pivot to Access as an add-in module

                              Power Query is supercharged with Extract, Transform, Load features. The Access Import features are getting way old.

                              31 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  Admin →

                                Thanks Amanda for suggesting.
                                We are reviewing similar requests (for example https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/11156427-include-the-ability-to-connect-to-new-data-sources).
                                However, it will be valuable to understand which new data sources and functionalities are appealing (in the other suggestion/new specific suggestion).

                                I’m updating the status to ‘no Current Plan’ so that you can reuse your votes.

                                Thanks,
                                Michal [MSFT]

                              • 2016 SQL Edit bug: If there is a Where and no group by, can not edit without Error 1001

                                Can not make any change to the SQL (even adding a space and taking it out) for any SQL with a WHERE clause but no GROUP BY. For example, to put a DISTINCT after the SELECT.

                                2 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)

                                  Thanks for reporting.
                                  We will add this bug report to our backlog and see that it is prioritized and handled.
                                  In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

                                  Thanks,
                                  Michal [MSFT]

                                • 3 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)

                                    Thanks for reporting.
                                    We will add this bug report to our backlog and see that it is prioritized and handled.
                                    In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

                                    Thanks,
                                    Michal [MSFT]

                                  • PNG transparency bug in MS Access 2003,2007,2010,2013 and if not also in the 2016 version?

                                    Take this message to explain the error in the transparency of PNG.
                                    This bug is crawling from the first version of MsAccess PNG transparencies disappear when sent to the printer, if anyone solved this problem please tell him that I do or how to solve it, probe with Msacccess 2013 and continues the bug ... today is 01/16/2016 ....
                                    Leo Poster and websites, observed in the examples that come out and check on my little exercises, which is possible in the new Access 2010 version include pictures in various supported formats (.jpg .png .gif etc, etc) in forms and reports,…

                                    15 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Reports  ·  Admin →

                                      Thanks for reporting.
                                      We will add this bug report to our backlog and see that it is prioritized and handled.
                                      In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

                                      Thanks,
                                      Michal [MSFT]

                                    • Fix Bug with Min and DMin aggregate functions in presence of zero-length strings

                                      If there are zero-length strings in a text field of a table, then Min and DMin may return wrong results. I have described this in detail here:

                                      https://social.msdn.microsoft.com/Forums/en-US/dc948ff4-c5cc-4159-9f97-f04b72ac30c6/access-false-results-with-min-and-dmin-aggregate-functions-on-text-fields-in-the-presence-of-zero?forum=accessdev

                                      Microsoft Support has confirmed that this is a bug.It is still present in Access 2016.

                                      Matthias Kläy

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)

                                        Thanks for reporting.
                                        We will add this bug report to our backlog and see that it is prioritized and handled.
                                        In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

                                        Thanks,
                                        Michal [MSFT]

                                      • FIX BUG: runtime error when resizing subreports in a report using VBA

                                        If you have a report that needs to resize a subform control containing a subreport for each record, you'd like to change the subforms width and height properties in Format event procedure. In preview this leads to a runtime error "not enough system resources".

                                        Changing the size in Load event procedure works properly. But you can't have indivual sizes for each record.

                                        I encountered this issue in Access 2010.

                                        3 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)

                                          Thanks for reporting.
                                          We will add this bug report to our backlog and see that it is prioritized and handled.
                                          In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

                                          Thanks,
                                          Michal [MSFT]

                                        • BUG: Find and Replace Access 2016 and 2010

                                          There appears to be a bug within Microsoft Access on at least 2016 and 2010 release versions.

                                          When doing a Find and Replace on a Field, the first record is acted upon twice in certain circumstances.

                                          When Highlighting the Entire Column or just one cell, the first cell of the field, or the one cell chosen gets acted upon twice by the find and replace after hitting Replace all.

                                          I can provide screen shots upon request, but you should be able to reproduce this easily using

                                          1
                                          21
                                          312

                                          and doing a find On 1 and replace with 1L

                                          you…

                                          3 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)

                                            Thanks for reporting.
                                            We will add this bug report to our backlog and see that it is prioritized and handled.
                                            In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

                                            Thanks,
                                            Michal [MSFT]

                                          ← Previous 1 3 4
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base