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

    2. Create a combo box:
    - 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…

    32 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    31 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Replace/remove Ribbons out of Access (or better out entire Office).

    Replace/remove Ribbons out of Access (or better out entire Office).
    Nearly every, even the smallest little and tiny application has an better menu structure than this space taking ugly ribbon thing. Besides, now we must conclude that after 8 years of introduction there is still no decent ribbon builder included within Access it is time to get rid of it. Lets say, it was a nice try, but let's return to something better please.

    31 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add a TreeGrid Control

    A TreeGrid control could be used in forms, or as just a Tree control. This should be a somewhat customizable look and feel.

    30 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

    30 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Provide conditional formatting features to datasheets and continuous forms

    As per Excel, it would be great to highlight and distinguish field data between the records displayed. Currently, if a format is set on a field, in a continuous form, the entire column receives that format, whether or not the data value contained, matches the criteria.

    30 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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.

    29 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    (thinking…)
    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.

  15. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  16. USysNotes Object for documentation

    When creating objects such as forms and reports it would useful to be able to have a dialogue form where you can key in notes and a date to keep documentation current. Have a few columns for date, user notes and developer notes. On the ribbon, have a notes icon which will open the notes to the current object for display and edit. Have it link to the ID Field in Msysobject table.

    27 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
  17. Document the LoadFromText and SaveAsText methods

    There are two undocumented methods, SaveAsText and LoadFromText, which were originally used for the old SCC integration. Since Access 2013, the source code integration has been removed and we now rely on third party tools (e.g. OASIS-SVN or Ivercy being example). It is my understanding those still rely on the undocumented methods. This request is to ask that Access team document those methods and thus make it supported so that those tools can continue to count on it being available and provide a solution for source code without taking any resources from Microsoft.

    27 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Hide Navigation Pane In ACCDE Files

    I have never understood why after all the effort put into compiling Forms and Code in Compiled Access databases and then they leave the Navigation Pane exposed so that all Tables are revealed and accessible to end users. Sure you can hide the Navigation pane but anybody can go into Options and reveal that Pane.

    This has been a major negative to Access for me for years ....

    Dick

    27 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Deal with sleep mode properly for tablet environments

    When a tablet or PC goes into sleep mode any active form looses its connection to the database backend (I am using SQL Server). This is very annoying in tablet environments where the PC is frequently switched to sleep mode. Make it so that Access can detect a reawaken from sleep and refresh the connection automatically rather than leave an error so that the user doesn't have to log off and reload the screen.

    27 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  20. PDF Export with PDF-Form-Field-Functions

    The Adobe PDF-Format allows to implement form-fields. This fields could be filled in by the receiver of the PDF-File.

    In my opinion it would be great to generate an PDF-File with Access with form-fields. If the data from Access could be pre-filled in, this would be great.

    The generated PDF could then be sent via Email to a client. The missing data could be filled in direct with Adobe Reader and then printed out.

    At the moment the PDF-Export just generate an PDF-File without form-fields.

    25 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Feedback and Knowledge Base