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 PowerQuery to ACCESS

    PowerQuery is the best improvement for collecting data for Excel since many years. I would love to use it in Access too, without using Excel.
    I would like to extract data from SAP, WEB, CSV-Files, collect all files from a folder, de-pivot files... Any ETL job PowerQuery supplies für Excel, but directly in Access!
    (I posted this two years ago using other words)

    588 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…)
      47 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Bring Access to the year 2017

      OK, enough of COM controls and VBA programming. The controls need a complete overhaul that look like and act like year 2017 controls not 1981 controls. We need more controls that you would find in .net interface. The chart control, datashets and almost all other controls need to be moved out of the COM world. Creating a dashboard in near impossible with the current controls and layout handling.

      Also VBA is ok but very limited compared to .net. Both are your products why not integrate them.

      We need a true grid control, better comboboxs, true PDF support, better and attractive…

      17 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…)
        3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
      • Fix rendering of VBA UserForms with Parent controls (eg. Frames) in Access 2003+ file formats

        The Access 2000 mdb format supports VBA UserForms with normal and parent controls, but all database formats beyond Access 2003 (ACCDB) only render UserForms that do not include Parent controls.

        Being able to reuse UserForms across VBA hosts is a very useful way of reusing code and User Interfaces, but a runtime error (Error 75) occurs when trying to render a UserForm in an ACCDB database format, when there is a Parent control (such as a Frame or MultiPage control) present.

        Parent controls enable rich functionality and more intuitive UI, but Access fails to render the forms, with an error…

        24 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  ·  Forms  ·  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 →
            • 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 →
                • 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 →
                  • 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 →
                    • 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 →
                      • Create PDF-File with merge function

                        Create more than one PDF-File from the Report and merge the PDF-File to one PDF-File

                        18 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…)
                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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 →
                          • 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 →
                            • 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 →
                              • Package accdr with the runtime

                                Please make Access package the runtime with mde/accde/accdr into a standalone EXE like VFP and RBase to avoid the annoying setup and version conflict and make it a truly stand alone app.

                                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  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
                                • Keep trusted location and file across Access version

                                  When a user trust a file or location, it should be unecessary to re-trust the file or location again after update to new version of Ms Access.

                                  Two problems with this behaviour:
                                  1) As mentionend, it is strange for the user having to re-trust Access Application after it is trusted on previous version
                                  2) I use automation to run utility Access file from main Access app. They reside in same, trusted location as main app. If New version of Access breaks trusted location, then it will not help if user Accepts the main app as trusted - the utility apps…

                                  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…)
                                    1 comment  ·  Automating Tasks  ·  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 →
                                      • 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 →
                                          ← Previous 1 3 4 5 31 32
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base