Feedback by UserVoice

Access (Desktop Application)

Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

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. Make the 'Compact and Repair Database' function automatic on saves

    Access file sizes grow rapidly, even if there's no database in use. PC's are fast enough to do the Compact and Repair function with very little delay in saving files. At least make it an option in the Current Database settings.

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      2 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
    • Provide an Option to Disable the Outlook Warning when using EMailDatabaseObject

      It would be useful to be able to disable the Microsoft Outlook warning that reads "A program is trying to send an email message on your behalf...".

      We currently have to use third-party application such as ClickYes by Context Magic to enable automatic emailing.

      3 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
      • SendObject - Select the sending mailbox

        For mailing, to have as option the sending mailbox and the target folder to store the email

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
        • SendObject with html template

          As Sendobject is the unique way to bypass warning security, when will MS fix the bug on docmd.sendobject with html template or provide a real exemple whom works with vba code.

          Does't work under office 2010, 2013, Office 365

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
          • Improve the Event Model

            We have to develop obscure workarounds for simple Events like MouseOver, et al. At least duplicate what is most common in other languages, like JS.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
            • Auto refresh linked tables, when front-end file moved

              Auto refresh linked tables, when front-end file moved. Relink to current folder if back-end not found.
              Best usage is to split front-end from Jet back-end.
              Often we move this 2 files to a new location, but then we have to relink manually. Imho, it would be nice to have an automation\option that detect that we moved the front-end file, and that relink to the back-end in the current new folder (the same as FE folder). Of course it should be optionally, because many times we leave the BE in the same old location on the network LAN. Thanks for reading.

              2 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
              • Create a new Comprehensive Windows Installer for Access Applications.

                Access needs a quick way to get a good solid installation of Back-end and Front-end databases including a registry edit for Trusted locations and versioning.
                It should also include the ability to:
                Add Icons,
                Add Desktop and other shortcuts,
                Allow user to accept an ELUA (End User License Agreement)
                Run simple scripts,
                Install with full windows trust. (maybe with a certificate?)
                An uninstaller.
                A check for updates function.
                Install support files into specified folders.
                Read simple system values and react accordingly (eg if 64bit systems then install 64 bit ODBC Driver)

                Also it would be nice if it could notify…

                64 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  2 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                • Remind to ownership automaticly

                  We have defined the ownership in database and input it e-mail, so i suggest if we could remind each others when the take is going to overdue date automatic by email

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                  • Please provide integration with a Mobile device for Capturing Images & storing them directly into a field

                    Hello Team,
                    It would be great if we can have a method to directly capture a picture using our mobile phone and have that picture stored directly in the Access database in a specified field. This can help in many industries not just Human Resources.

                    Thank you in advance

                    3 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                    • Create a distribution mechanism

                      This is for applications that use Access as a front-end to SQL Server.

                      Create a distribution mechanism in Access where:
                      - Developers can release a new version with a version number
                      - It automatically creates a secure accde and places it on a file server
                      - When a user copy of an accde starts up, the current version can check for a new release
                      - If a new version exists, Access closes, the new version is copied, and the new accde restarts

                      I have existing code for much of this for my main applications. But I have to rely on…

                      4 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add Aggregate UDF type to VBA

                        Currently writing a UDF to operate on a single record when placed in the formula for the field definition is easy; however there is no way to write a UDF that shows up in the aggregate 'Total' drop down box of a group by query. An example usage would be making a 'JoinASC' UDF which would concatenate all of the aggregated data of the grouped records for the field it was applied to.

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                        • EXCEL Import via Drag an Drop

                          Make it possible to import / link an Excel File/Table via Drag and Drop into MS Access.
                          Drag it from Excel - Drop it to e.g. an *accdb.
                          MS should asks: Import or Link ... an then do it.

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                          • Try to solve the Error 3828 when exporting data from a query to Excel

                            I have code exporting data from queries to Excel. All lines but one works. The last line gives the error 3828.
                            "Cannot reference a table with a multi-valued field using an IN clause that referers to another database"

                            The code line is like this:
                            DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "DeliveriesThisMonth", PathToEXTAB, True, "Deliveries"

                            But there is no multi-valued field in any of the tables.

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                            • Allow VBA to set DIsplayControl on linked tables consistently

                              Setting the "DisplayControl" property on a field of a linked table using VBA works.

                              You can read the value back using VBA, even after closing, compacting and reopening the database.

                              Dragging the field onto a form uses the correct control.

                              However, the interface still shows the value "Text Box" until manually changed by the user.

                              Code:
                              With CurrentDB().TableDefs("TABLE").Fields("FIELD")
                              Set prp = .CreateProperty(strProperty, "DisplayControl", acComboBox)
                              .Properties.Append prp
                              Set prp = Nothing
                              .Properties("DisplayControl").Value = acComboBox
                              End With

                              ' You can do this in the immediate window and the value is 111 (acComboBox)
                              Debug.Print CurrentDB().TableDefs("TABLE").Fields("FIELD").Properties("DisplayControl").Value

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Automating Tasks  ·  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…

                                8 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  Automating Tasks  ·  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…

                                  8 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add "Site" to the "Move to Sharepoint Site Issues" table

                                    When moving tables to SharePoint, on error, Access creates a *somewhat* nice table with Issue, Reason, Object Type, Object Name, Field Name ... but no info on the SharePoint side! hmm... someone dropped the ball on THAT! :)

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Ability to view the Field list in the VBA Code Module

                                      When you are in the VBA Code Editor, and you want to refer to a field on the form, you have to flip back to the form to find the field name before you can use it.

                                      It would life so much easier if the field names were listable in the code module in the View option as per the Object Command on the Form's Design View.

                                      23 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Create APIs for existing email methods and other "canned" wizards

                                        The existing email mechanics for sending emails to create/update data are nifty, but problematic.

                                        1) they are so limited in terms of automatically enabling complex data handling and customized business rules - especially if attempting to inter-operate with other enterprise-level systems, like SAP or Dynamics as the final data repository. For example... wanting email approval of a work order or PO...the updates to the enterprise systems will require significant coding and implementation of business rules specific to the organization, but the email handling itself is relatively trivial.

                                        2) the lack of ANY API accessibility in the email send/reply process, especially…

                                        8 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Can we have an AutoExit capability?

                                          If I (as a developer) want certain events to happen when the database is closed, I have to go through setting up code in a hidden form that executes when Access shuts down. This works but is sneaky and clumsy - especially when one is asked to maintain someone else's work and that person is no longer with the client. A simple cure is to allow an automated AutoExit macro that runs on close, exactly like Autoexec runs on open. And, like Autoexec, the proposed AutoExit will not run if we hold down the Shift key when closing the database.

                                          10 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            2 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base