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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Integrate MS Access with Power Apps

    I've been looking more into Power Apps, and I think it would be great for you to work with the Power Apps team to provide a web and mobile solution to what Access can do today on the premises of a server. Because there is unfortunately no web version of Access, maybe Power Apps can help solve this problem? Ideally, we should be able to continue moving (and linking) Access data into SQL and then create a Power App on top of the "Access-created" data from SQL; essentially viewing a Power Application that looks exactly like access but online and…

    42 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →

    This is great feedback that we are actually working on providing now. Using the comments below, we’d love to hear thoughts about solely focusing on SQL as a stepping stone to Power Apps for data migration purposes, or also investing in another way for you to connect to Power Apps through the Common Data Service (CDS). This database allows you to store, share and manage your data over the web, and eventually the phone (current MS investment). CDS is also Power Apps’ central underlying storage unit, as well as the entire Power Platform team’s key investment.
    Please see following link for information about CDS, and let us know: if Access created a data export & linked table capability from our platform to CDS, would you use it?:
    https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fdata-platform-intro&data=04%7C01%7CEbo.Quansah%40microsoft.com%7C32c26c86b7fe4f3162a508d7f069896d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637242208373640123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C-1&sdata=GuvQ6o2aqKiBMs%2B1z2nvv0sNtAHNl8MPQqiOvsh0D1U%3D&reserved=0

    We will still continue to make investments in SQL connection either way, but we are also happy to…

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

    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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)

    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

    38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  5. Make it easier to select and change printers

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

    38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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)

    38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. BugFix: Combo Datatype bug

    Please fix the combo box RowSource datatype binding bug.

    The bug is as follows:
    1. Create a table [Table1] with two columns:
    - [NumberField], datatype: Number, Double
    - [TextField], datatype: Short Text

    Add 1 Row to the table:
    [NumberField] = 10
    [TextField] = "Some Text 10"


    1. Create a combo box:

    2. Set the RowSource of the combo box to this:
      SELECT NumberField, TextField FROM Table1;


    3. Add a Button to the form: [cmbErrorExample]
      Add On Click Event:
      If Me.cmbErrorExample.RowSource = "SELECT NumberField, TextField FROM Table1;" Then
      Me.cmbErrorExample.RowSource = "SELECT TextField, NumberField FROM Table1;"
      Me.cmbErrorExample.DefaultValue = "Some Text 10"
      Me.cmbErrorExample.Value = "Some Text…

    38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  8. Fix the comparison of strings with Unicode Latin Extended-D characters

    Could you please improve the handling of Unicode Latin Extended-D characters in MS Access queries and filters. Currently, chars in this range (introduced in Unicode 5.1 back in 2008) are incorrectly compared. Thus SELECT (ChrW(42786)=ChrW(42841)) AS Expr1; falsely returns a True value although two different chars are compared. The same is true for any two signs in this Unicode range. The problem only exists in Queries; in VBA Code these strings are compared correctly (except the StrComp function with vbDatabaseCompare option). See MSDN c76d9e5f-adbc-41f3-a2ed-dc25edf34a14

    37 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. improve appearance and design of Access Forms

    modern optical effects like in Windows 10 or modern webpages would heavily improve the value of created Apllications.
    Better Mouseover-Effects for Buttons, Fading Effects for Forms....
    it would be great!

    36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. When a query fails due to data type mismatch - tell us what field in the error message.

    When a query fails due to data type mismatch or some other field specific error - tell us what field in the error message.

    36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
  12. Upgrade Access SQL dialect to current ANSI standards

    MS Access's ACE SQL engine continues to run with a variant form of ANSI-89 with some ANSI-92 features while the rest of the relational database world has adopted more recent ANSI standards and at the very least fully comply to the universal, lowest common denominator standard accepted in the industry: ANSI-1992.

    Being a highly used, worldwide database for small to medium-sized shops and its popularity with the Office suite, enhancing Access's dialect to industry standards will add value to current and future users including the Microsoft brand. Even SQLite, a similar, very popular file-level database as open-source counterpart to Access,…

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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).

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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…

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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 it is iffy.…
    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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.

    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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.

    31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base