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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Fix Confirmed Bug: Report Controls Jump Elsewhere When Moving

    In Access 2010, 2013, 2016; when a report in design view exceeds a certain size overall (this has nothing to do with the 22" section maximum), try to move any type of control in the lower sections and it suddenly jumps elsewhere.
    This has been confirmed in forum post https://social.msdn.microsoft.com/Forums/office/en-US/a2db2cd7-f02b-4317-a663-e6a4dbb78cb9/report-controls-jump-elsewhere-when-moving?forum=accessdev. This post contains a link to a sample database that demonstrated the problem.
    It has also been confirmed via a support incident with Microsoft. The technical lead called it 'an Regression, an product defect' and asked that I post it here. It continually baffles me that when bugs are…

    33 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  ·  Flag idea as inappropriate…  ·  Admin →

      Thank you for reporting this behavior.
      We added it to our ‘To Investigate’ list and will update the status once we know more.

      Thanks,
      Michal [MSFT]

    • Create Add-In Store

      I think it would be a great idea to create an add-in store that would allow for developers to offer tools like V-Tools, the FMS Suites, Smart Indenter, and other VBA Add-ins in a centralized, official, and user-friendly location.

      Current add-ins are only available by searching the web, and many results are either outdated, defunct, or unsafe.

      6 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
      • data connector sql server

        ADD SQL SERVER AS A DATA CONNECTOR - The Access team is currently evaluating the use of data connectors in Access, (https://youtu.be/j5UAv4yY5RY?t=2155), and we need your support to get them to include SQL Server as an option! PLEASE VOTE for this idea, every vote counts!

        558 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…)
          45 comments  ·  Flag idea as inappropriate…  ·  Admin →

          Thanks for posting and supporting.
          We reviewed this ask and suggestion and will take into account when planning improvements for the existing SQL connector.

          This item will be closed for voting, but you can add comments to show your support and share ideas.

        • 14 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…)
            Reviewed  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • Enable seamless integration with Excel objects

            In light of the items requesting return of Pivot*** objects (https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/10284183-add-pivot-charts-back-to-access) being rejected, I want to suggest an alternative that I hope is much simpler to implement and would bring better experience:

            Ability to seamlessly embed Excel objects, be they tables, charts, pivotcharts, pivottables, directly inside Access.

            This already exists but it is very awkward, outdated, and includes unwanted things (e.g. Excel's chrome, the spreadsheet itself and so forth). This solution should allow us to define an Excel object using Access data and show it as if it was just a normal Access control. It should allow us…

            175 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…)
              8 comments  ·  Flag idea as inappropriate…  ·  Admin →

              Thanks for suggesting and supporting this idea.

              The team has reviewed and will take into consideration when planning future Access features and capabilities.

              This item will be closed for voting, but you can add comments to show your support and share ideas.

            • Please can we have the linked Table Manager available for the Runtime.

              When you are installing the Database on a Client's Network, the Server or Shared Drive will have a different Path to the Development PC System.

              This makes it very difficult to install a System on a Client's PC where there is not a full copy of Access.

              25 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…)
                Reviewed  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Fix longstanding bug where conditional formatted controls can always receive focus

                Fix longstanding bug wherein a control with conditional formatting and properties Enabled = No and Locked = Yes can receive focus. Controls without conditional formatting applied and properties Enabled = No and Locked = Yes cannot receive focus or have their contents selected.

                8 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…)
                  Reviewed  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                • 4 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…)
                    Reviewed  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Please find a way to create 508 Accessible reports and export them as 508 compliant pdf files.

                    Right now, there is no way to easily create a 508 compliant document from a database. I have to create a temp table, run code to strip out any rich text, export it as a text tab delim file, program Adobe to import this text file into a 508 compliant document, and then go back to the database, get the photos needed, and copy paste them into the PDF. The 508 wave is crashing down on us, and the inability for Access to handle this requirement is frustrating!

                    4 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…)
                      Reviewed  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Switch between objects with Ctrl + Tab

                      In previous versions of Access it was possible to switch between objects with Ctrl + Tab. Please reactivate this feature. Strg + F6 is not an ergonomic shortcut.

                      137 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…)
                        Reviewed  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • GUI contrast

                        You have to improve the contrast used within the GUI. Whether it be in the VBE or Nav Pain (sorry I meant Pane), when you select an object and the open it, you can't make out which object was selected. It is horrible. And much worse on laptop and tablets. It should pop out at the user. I should need to scroll, move up and down to figure out what is currently selected as is presently the case.

                        5 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…)
                          Reviewed  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Access 2016 Dragging Queries into Macros crashes Access

                          When creating macros in Access 2016 if you drag a query into the macro into white space it works fine and adds the query however if you happen to drag it over another query access with crash, no errors or anything just crash out.

                          I recreated the issue in our environment with a blank database to remove any other variables that our production databases may inject to the issue and I get the same behavior.

                          I've also tested on a fresh windows install with Office 2016 installed from the office 365 portal.

                          Users on the access for developers forums were…

                          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…)
                            4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Fix form border widths in Access 2016 under Windows 10

                            I don't know if this is a general problem with Office 2016, or if it is specific to Windows 10 users, but I find that sizable MDI forms in Access 2016 have a single-pixel border that is very hard to grab with the mouse.

                            The form borders show as a single-pixel red line, and have no difference in appearance regardless of the mode of the form, whether the mode is "no border", "dialog", "sizable" or "thin". The border appears the same in design mode.

                            I've tried this on a couple of different computers running Office 2016 under Windows 10, and…

                            247 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…)
                              73 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →

                              I apologize for an honest mistake with updating the status to Done.
                              We did fix a similar issue with Query design and Relationship window, but haven’t fixed this one.

                              Again – sorry for the mix-up.

                              Michal [MSFT]

                            • Improve Access programmability

                              There are many new technologies available that Access cannot take full advantage of because it's either in .NET or requires JavaScript.

                              Excel has a JavaScript API being developed and expanding. Using JavaScript would allow for richer integration between desktop and web apps where appropriate.

                              On the other hand, native access to .NET framework would provide access to many other components that Access can leverage for automation.

                              What we can't do is just stay behind in COM world - COM ecosystem is shrinking and we need a solid integration support especially when our Access application only requires a small part to…

                              450 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…)
                                Reviewed  ·  11 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                              • Who is using the Database?

                                On a shared network with a backend/frontend configuration, (or even in a single-shared-file arrangement), please provide a tool that tells us who has the database open.

                                74 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…)
                                  Reviewed  ·  5 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
                                • Text Boxes Should Have Visible Spell Checking

                                  This should be an option for text boxes to have spell checking highlight words that aren't in the dictionary. Similar to Word or filling out text boxes in web browsers, the visible indicator of typos is important. Running F7 to launch the spell checker afterwards is not the same or as helpful.

                                  35 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…)
                                    Reviewed  ·  3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Fix a new issue in 2016 ... email a report... file attachment no longer works.

                                    when using the email command with an open report, the outlook new email dialog box opens but the file is no longer attached. this appears to have been lost with the most recent update of the office 365 in mid December 2015.

                                    5 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Please allow users to disable the hyperlink popup that says "Some files can contain viruses or otherwise be harmful to your computer..."

                                      Please allow for users to suppress this popup, it's an incredible annoyance when you have to click it hundreds of times a day.

                                      106 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…)
                                        11 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Create and promote a website for Access developers to list their applications and services.

                                        MS already has a website for Access MVP's, but other ISV's, VAR's and developers who are not MVP's need a centralized place for consumers to search for a solutions provider. MS can provide a disclaimer on this website stating they're not responsible or endorsing any particular listing.

                                        .. And while you're at it, create a separate category or page for "Access Marketing" ideas so that we don't have to mix these kinds of ideas with product improvements.

                                        59 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…)
                                          10 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                                          Thanks for posting and for the interesting conversation.

                                          Without taking an active part in this discussion, or making a corporate statement, I’ll just say that the Access team values our MVPs and their on-going contribution to both the product team and the broader community.

                                          as for Frank’s suggestion – it’s a great one, and we’ll look into it. Thanks!

                                        • Incorporate Power BI as an Add-in to New version of Access 2017

                                          Since Pivots & Charts have been removed from Ver 2010 onwards, its been a big problem for us consultants to provide charting and pivoting features to our customers. These are features simply adored by our customers due to their ease of use. But after looking at Power BI I feel since its from the same Microsoft family the Access Team should consider incorporating it in their Next Product Planning process.

                                          494 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…)
                                            30 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                            Thanks for posting and voting.
                                            Integrating Power BI with Access is one of the things we believe will add value to Access developers and users. We are looking into ways to support that.
                                            Keep voting if this is important to you – it will increase the likelihood of it getting in the product.

                                          ← Previous 1
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base