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

    79 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 →
    • Export / Import VBA IDE settings (including editor format)

      Export / Import VBA IDE settings (including editor format)

      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…)
        0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
      • Fix Access object executing

        While MS Access is executing code during the object's event, all other events of the object are locked, so they will not be fired.

        Let's say we have the Microsoft Calendar Control 8.0 ( mscal.ocx ) placed to a form and we have the code:
        Private Sub Calendar1_Click()
        Calendar1.Month = 1 + (Calendar1.Month) Mod 12
        End Sub

        Private Sub Calendar1_NewMonth()
        MsgBox "Calendar1_NewMonth event" & Calendar1.Month
        End Sub

        The sample should displays a message box when the user clicks the control. In MS Access, the message box never occurs, as the NewMonth event is called during the Click event. If the…

        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…)
          1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
        • 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 →
          • 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…)
              1 comment  ·  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 →
                • 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 →
                  • 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…

                    7 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 →
                    • 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…)
                        2 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 →
                        • 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 →
                            • 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 →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base