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. 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!

    349 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…)
    • Allow CTRL+A to select all text in a query's SQL View

      Pressing CTRL+A should select all text in a query's SQL View. It does not work in Access 2013.

      My current work-around is an AutoHotkey script.

      10 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…)
      • Give us a new dll - MSJSON.dll

        Currently to work with XML objects from API calls we have an object model from referencing MSXML6.dll that make iterating through the response easy. With JSON we can only get strings of data that we have interpret. If you created MSJSON.dll for us we could manipulate JSON data as easily as XML and make life easier for developers dealing with API calls.

        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…)
        • Continue and extend backend functionality from AWA in Access Desktop

          Given the fact a decision on AWA has been taken, here's I think what the development team should do. 1. Make AWA datamacros available in Access Desktop 2. Extend with support of Update/Create/Delete Queries in the query designer. 3. Explode functionality by making datamacros that return just one value available as functions within expression builders of queries and datamaros 4. Support the database qualifier in front of tablenames the way it is already available in SQL-Server between databases. this way users can integrate AWA managed and non-AWA managed very easily. (integration with CLR SQL-server projects and other tools that generate…

          7 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…)
          • Please bring back Dynamic Charts and Pivot Tables

            Hello, some of the features that have been dropped on Access from the 2013 version is a frustrating fact.
            Specifically, I'm talking about the PivotTables and PivotCharts.
            I developped for my company two applications that manage the commercial activity and another for the management of operational risks.
            This feature (PivotTables and PivotCharts) had been very useful for reporting in the 2007 and 2010 versions.
            Now this feature is no longer supported and our IT Department has migrated the Office to the 2016 version, I am really stuck.
            Please take into consideration this request and consider the possibility of its reactivation.

            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…)
            • 9 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 →
              • scroll wheel

                The scroll wheel should work for data tables and other all the other screens that may have a scroll bar on the side. Is it being overridden by individual controls hogging focus ? Please allow user control if it isn't there (quick search, nothing found).

                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…)
                • Linked Table Manager: select all tables from same back end

                  One of the biggest pains is when you have multiple back ends and Linked Table Manager (LTM) prompts you at every table. When you have lots of links and multiple back ends, it's a pain to go through and select all from only one back end.

                  Idea #1: Click on a single table in LTM, then click a button: "Select all tables from same back end." Voila! Now you can update that single back end, and then move on to the next one.

                  Idea #2: Sort the tables by back end. Not as convenient as Idea #1, but would still…

                  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…)
                  • Access 2016 relationships

                    Trouble with 1 to many relationships. There are many ways to connect the different tables in a medium Access relationship. Is there any possibility of a Microsoft Manual. I already have the best 2 third party manuals I consider the best (Access Bible and Access 2016 for Dummies) One to smart and one doesn't cover all I need. Is there anything between? I've probably put 15 hrs. into this monster on my on with the UTUBE videos hel.

                    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…)
                      1 comment  ·  Admin →
                    • Distribute Access apps on windows store

                      So that Access apps will run on Windows 10 S. I am following the launch of Windows 10 S with great interest. I am writing to this forum today to find out what the Microsoft best practice is for migrating Access applications complied to work with Microsoft Access run time (or some other method) to Windows Store apps (aka Windows platform apps) that could be offered in the Windows Store and would run on Windows 10 S and all versions of Windows 10? Since most Access apps are used within an organization it is likely that most Access Windows Store…

                      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…)
                      • 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…)
                        • Provide an option to turn off hyperlink warnings as they are unsightly and we know what we are linking to.

                          Remove the enable contents as it is a nuisance.
                          Default the form to centralize on the screen and pop up. It can be changed if required.
                          Have a default of zero on text fields as it seems to allow changes to occur without losing previous data.

                          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  ·  Admin →
                          • 10 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…)
                            • Expand the maximum Form width

                              Recently I got a new monitor with a resolution of 3440 x 1440. I wanted to create a Form that uses the entire Screen width. I failed because the Specifications only allows a width of 57,79 cm (which in this case corresponds to about 2200 pixels). This was completely sufficient for decades but with these screens nowadays…

                              7 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…)
                              • Improve Performance of One-to-One Joins with SQL Server

                                Generally working out some of the glitches encountered when working with SQL server would be great, but one of the most irritating ones I've been running into is when doing an INSERT via a datasheet or form which involves both sides of a one-to-one join in Access. The INSERT fails because Access doesn't retrieve the primary key value of the first side of the join written, so when it goes to write the second side it fails because there is a null value in the primary key on the second table.

                                There are a few awkward workarounds, such as using…

                                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…)
                                • Utilize indices in processing tables cached locally by Access when linked to Sharepoint lists (data uploaded from Access)

                                  Have the Jet engine utilize the table indices that were in the tables uploaded to Sharepoint and now cached locally (Acces 2010 and newer). That will dramatically improve performance for larger tables.

                                  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…)
                                  • ACCESS 2016: Addition of Scanning feature to Forms

                                    Handy and useful feature: Access Form will serve as great tool to have documents scanned into its perimeter.

                                    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…)
                                    • enhance chart controls

                                      Charts: make the charting function in access as good as excel

                                      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…)
                                      • 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…)
                                          1 comment  ·  Admin →
                                        • Add auto-complete to fields based on existing data

                                          WHen entering a new record (or editing an existing record), why not allow the user to turn on an auto-complete, which would compare the characters typed with existing data entered for that field in other records?

                                          It would be useful and reduce mistakes in databases which use a limited number of values for specific fields (eg address databases)

                                          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…)
                                          ← Previous 1 3 4 5 25 26
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base