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. Import/export specs edit feature

    Currently, the developer needs to go through the process of importing a file into a database in order to create or edit an import/export spec in the MSysIMEXSpecs table. True, the MSysIMEXColumns can be edited directly in the table, but overall, the process is not very user friendly. There needs to be functionality to create/edit import/export specs without have to pretend that one is importing an external file.

    40 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      4 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
    • integrate db split BE to cloud

      The current method to split to SharePoint List at a 365 account was a good start, but is cumbersome to set up & support. The set up of a 365 account and then learning SharePoint is a real barrier. Documentation/support for this arrangement is very scattered between Access, 365 and SharePoint.

      An integrated design whereby the Access developer can split the db with an option to put it in the cloud where the cloud is perceived as nothing but a folder would dramatically increase popularity of the product.

      Not needing a pre established 365 account (or OneDrive or DropBox), not…

      40 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  ·  Cloud  ·  Flag idea as inappropriate…  ·  Admin →
      • Coloured Tabs in Tabbed Forms

        The only way to make a tabbed form have a colour is to resort to some trick like using a coloured background behind a transparent tab or pasting an image onto it. These cause problems when moving controls around.

        It would be nice for the tab control to have the same functionality as a form where one can set the background colour.

        39 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          4 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Replace VBA with VBA.net.

          Replace VBA with VBA.net. You exist because of your customer. Develop solutions to your customers' needs, not your agenda. CUSTOMERS' NEEDS = VBA.NET! I don't understand why your company does not grasp this necessity. Good grief!!

          36 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
          • Drag & Drop for listbox

            I want to drag multiple files from explorer window onto the listbox to add the filenames to the rowsource (tried mscomctl.ocx: huge problem with other programms that register other versions of the ocx-file)

            35 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  ·  Flag idea as inappropriate…  ·  Admin →
            • Custom naming on message boxes

              When using the vbYesNo message box you can only have 'Yes' or 'No' options. I would like to be able to rename these options. Currently the only way round it is to create a form to look like a message box.

              35 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
              • Datasheet Column Header Formatting

                Currently (Access/Office 1706), the only formatting capability for column headers in datasheet view is with the DatasheetColumnHeaderUnderlineStyle property, and this only seems to work for value 8 (Double Solid). It would be great if some extra capabilities could be added:
                1. Set HeaderHeight (absolute or relative to normal row height, f.i. twice normal).
                2. Options to wrap & align text within Header.
                3. Set Background color / Font bold & color.

                Of course more comprehensive header formatting is imaginable, but these basics would already be a great improvement.

                Thanks, Hans (Netherlands)

                33 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  ·  Flag idea as inappropriate…  ·  Admin →
                • Make it easier to select and change printers

                  Especially important if user has runtime Access and/or maybe using an accde file.

                  32 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Provide an easy way to share Rich text between Access and other Office Applications

                    Access 2007 added the Rich Text control so we can store rich formatted text in Access. What it forgot to add was an easy way to share that formatted text in Excel or Word. Please add a means to share the rich text data in at least other Office apps and a easy way to strip the formmatting when exporting to formats like .csv.

                    32 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                    • Support PDF output with password encryption like Word

                      We should be able to generate reports as PDFs with a password. MS Word has an encryption option when saving a Word Doc to PDF.

                      For security reasons, more and more organizations want to have encrypted data at rest and in emails. ACCDBs support encryption, so it'd be helpful if it's PDF outputs could too.

                      It should be available from the user interface and as an option programmatically (DoCmd.OutputTo acFormatPDF).

                      32 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                      • accde should also remove the ablity to modify tables and queries

                        When one creates an accde database, Ms access 2007 SP3 up to 2016 should also remove the ability to modify tables and queries.

                        31 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          5 comments  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
                        • Editable Crosstab Control (Bound to underlying tables)

                          My idea is similar to the one called "Provide a native grid control similar to the visual studio gridview or even the old flexgrid" EXCEPT I want it to be a BOUND crosstab that is editable. This blog describes how to fake an editable crosstab, but it is a lot of work http://alisadev.blogspot.com/2009/06/how-to-fake-editable-crosstab-in.html. My best example is that for a school, they want to view the grades in a grid, but be able to edit them. Classes go down the side, Quarters go across the top, and Grades will be in the middle. When the user is hand-entering the…

                          31 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            5 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
                          • Make SQL and QBE Smarter

                            1. When a query that selects identifiable rows joins to a query that aggregates data, allow rows in the identifiable part to be updated rather than making the query non-updateable. Extend this to heterogeneous joins so if one table in the join is updateable but another is not, allow updates to the updateable one.
                            2. Stop smothering expressions with excessive numbers of parentheses. There is no reason that I can think of that would require an individual column name to be enclosed all by itself in parentheses.
                            3. Stop reformatting MY SQL strings. I have a work-around for this but…

                            31 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              6 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Allow linked tables to be set to Read Only

                              When building a system that shares its data with other systems - I've built an ERP system with Access - you often want to share certain Master data (from the HR system for example), but want to keep it that only HR can modify the data.
                              If we could set linked tables to be read only, that would remove the need for a lot of 'protectionist' coding.

                              30 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  ·  Flag idea as inappropriate…  ·  Admin →
                              • Increase the number of table references from 2048

                                With comprehensive applications, it isn't hard to get the dreaded "Can't open any more databases" error message.

                                When this message is encountered, bad things happen internally and the database should be restarted.

                                If this isn't possible, at least give us a handle so we can determine the number the system currently thinks exist.

                                29 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  ·  Flag idea as inappropriate…  ·  Admin →
                                • bring back replication.

                                  I know it's hard to believe but there are a lot of us in the world (yes, even in the United States) that must occasionally work disconnected from a network. At our site we've nursed Jet 4.0 replication along for as long as we can and now it's starting to break as MS has backed away from supporting it. We are moving to a centralized SQL database with mobile hotspots but there are some places this simply will not work reliably. We will be forced to 'roll our own' replication method or bring on significant additional SQL expertise to see…

                                  29 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Refresh table on right click

                                    Whenever I modify a table or a view in SQL server I need to go refresh the table link. Currently that means
                                    * right click a table
                                    * Select Linked table manager
                                    * Find the table I want to refresh
                                    * select it
                                    * click refresh table links

                                    I would really like it, if we could simple right click a linked table, and just select refresh to have that single table refreshed.

                                    28 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      5 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                      As part of us designing on a new Linked Table Manager dialog, we are incorporating related suggestions and requests made in UserVoice and other forums.
                                      Stay tuned.

                                    • Create a table / linked table with a size greater than 255 fields

                                      When connecting to a commercial database such as Oracle, it may be trouble if all the columns of the table are not displayed.

                                      28 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • ITEMS in Detail Section with Crosstab Queries and specified fixed headings should have option to suppress repeating

                                        Whenever an ITEM such as a heading progress bar is in the Detail section, so if you display the form as Continuous Forms, you will see a progress bar in each displayed record. It will happen whenever a Continuous Form displays more than one record.

                                        The only way to avoid this is to move the progress bar to the form header (or footer) section.

                                        Please refer to the attached design, on the very last page described in microsoft forums.

                                        https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_windows8-mso_2010/crosstab-query-to-display-all-records-according-to/b98b9372-1a83-402d-b54d-87ca5b7a7407?messageId=c8966d76-2bcd-4a49-a1cc-83cdcf71a483

                                        Either an access development enhancement to enable this would provide more flexibility to create complicated reports.

                                        Thank you kindly.

                                        28 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  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Allow Wrap Text (like in Excel) for the headings in Datasheet view

                                          Often the Datasheet heading is much longer than the values in the column under the heading. Making the column narrower (to see more columns) means I can no longer read the heading.

                                          28 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  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base