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. Add capability for telephone (#tel:+) hyperlinks in Access Tables

    Click to dial is available in many applications and all phone apps, but Access does not have the capability to create a clickable Phone hyperlink, as is done for emails. I needed to create a Maro to add this to the current phone field.

    I would like the capability to create a Phone hyperlink that automatically adds "#tel:+phone number" to the hyperlink, as is currently done for emails

    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…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Debug Compile Keyboard Shortcut

      Most Key Controls have simple keyboard shortcuts however Dubug-> Compile does not. This would make using the VBA editor just that little bit more bearable.

      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…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Access - Dynamics 365 connection unavailable after update to ver. 1711

        Hi, I was able to link to my Dynamics 365 tables with the version 1708 (build 8431.2107) but not with the version 1711 (build 8730.2165).

        So I did a rollback to version 1708 and stopped the auto updates.
        When will be again available the Dynamics 365 connection?

        Thank you!
        Walter

        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  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
        • fix broken link for contacts database intro

          fix broken link for contacts database intro

          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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
          • Navigation Control Bug Causing State Loss and VBA Project Reset

            Clicking on two different tabs of Navigation control each tab containing a subform is causing state loss in the VBA environment. Running code is reset, all static and object references are lost.

            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…)
              0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
            • Add the following ability to Power BI Desktop

              Add the following features to Power BI Desktop

              1) Update tables (via Code, Copy paste, by typing data etc)
              2) Password protect PBIX Files
              3) Allow Excel to connect to the Data model in Power BI Desktop file
              4) Introduce a UserName Function in Power Query
              5) Retire Access

              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…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Fix borders in Access 2016 to work properly!

                Borders on various MDI documents still do not work correctly on forms and datasheets for resizing with mouse (especially lower right corner). Difficult and unreliable to grab borders and border corners at all. Problem has been reported many times and is well documented on the net. Still unfixed as of 12/27/2017.

                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…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Abilty to add a drop down list for a query with criteria in square brackets

                  Currently in a query if you use Square brackets you can get a box to pop up asking for information when the query is run. Allow a form & combo box to be attached so it can be customised for the data to be picked up.

                  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…)
                    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
                  • publix

                    bagger

                    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…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Urgent. Please Fix the application crash when changing field data type for table

                      Already provided evidence to microsoft support; however, I was instructed to post here. Error easily and consistently recreated. Recent Build 1711 fails every time when creating a new table and then simply changing data type to number of large number. 1711 is unstable.

                      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…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add a share functionality built in to access and shared and live editing support

                        For this, access would need onedrive office online support, but mainly the ability to edit the onedrive file with your local access software without having to download a copy of the file itself to edit it.

                        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…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add a share functionality built in to access and shared and live editing support

                          For this, access would need onedrive office online support, but mainly the ability to edit the onedrive file with your local access software without having to download a copy of the file itself to edit it.

                          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…)
                            0 comments  ·  Cloud  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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…

                            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…)
                              0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                            • Siging VBA Code in accdb databases

                              Currently we are trying to force the option to allow only digital signed macros and don't use Trusted Path at all. This is working fine with Excel, Word, .... But not with the new Access file format.

                              Yes we can Package and Sign an Access database. But with this the code itself is not signed. See the following blog where the issue is explained in more detail:

                              http://www.codekabinett.com/rdumps.php?Lang=2&targetDoc=signing-vba-code-access-accdb

                              This is really annoying as it currently counteracts our effort to make the client systems more secure.

                              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  ·  Flag idea as inappropriate…  ·  Admin →
                              • Create a stand alone file independently version of Access or Runtime and 32 or 64 bit architecture

                                Due to the currently conflicts between versions, I think it would be necessary to create a stand alone file that can be run independently of the version of Access or Runtime and 32 or 64 bit architecture, that the user has installed!!

                                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  ·  Flag idea as inappropriate…  ·  Admin →
                                • Make 32-bit Access large address aware (LAA)

                                  Now that the 32-bit version of Outlook 2016 becomes large address aware (see https://support.office.com/en-us/article/Large-Address-Aware-in-Outlook-2016-ea0913e4-2917-4456-b0ea-935dbd57ef02), it would be great to get that for MS Access as well.

                                  (We hit the 2GB barrier every now and then when batch-exporting MS Access reports as PDF. Having 4GB support would be great. Upgrading to Office 64-bit is usually not an option in corporate environments depending on third-party add-ins.)

                                  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…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Automatically demote references the way you promote them when app is run using different version of Office

                                    Fix references to demote as well as promote (at least for Office versions). If the app doesn't work, it's on me. Just provide a meaningful message.

                                    Early binding is much more efficient and it is also easier to code because of all the intellisense available. But most environments are mixed and your policy of of not demoting references forces developers to either maintain multiple development environments or to always work in the oldest environment they need to support OR to use late binding and completely give up all the short AND long-term advantages of early binding.

                                    Please fix this. I…

                                    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…)
                                      0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Developer helpers

                                      1. Fix all the tiny dialogs to at a minimum be sizable.
                                      2. Modify the linked tables manager to sort by data source. Since you can only relink one datasource at a time it makes absolutely no sense to sort alphabetically, especially when the window is so small that you can't even read half the table names, either do this easily by sorting by data source or even better by creating a source drop down and using that to filter so the form only shows tables from a particular source. I have a sample I created for my own use…

                                      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…)
                                        0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Create a truly locked down FE format

                                        ULS was a pain and way too many people implemented it incorrectly but it did serve a function which we have lost. People who develop Access apps for others need a way to completely lock down the FE. The .accde doesn't cut it because users can still modify tables, queries, and macros. We need something that acts like the .accdr but which isn't a trick. I understand why creating an .exe is not an option but you should be able to create a "permanent" format that acts like .accdr but which can't be undone by simply renaming the file. That…

                                        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…)
                                          0 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Leave right-click menu searching options available in runtime

                                          The right-click menu on DS forms contains BOTH design and user elements. Rather than removiing the entire menu in runtime mode, just remove the design options and leave the user-friendly searching features available.

                                          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…)
                                            0 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 31 32
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base