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. Fix saving column order in datasheet view

    I have noticed this issue whereby you move columns and when the user exits the form, the datasheet columns revert back to the original (pre-saved) order. The work around I found was to hide/show columns, toggle one field on then off, close dialogue and then it will save. Not very intuitive.

    Thanks for fixing.

    83 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    26 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →

    Note that typically the reason this happens is that there is code behind the datasheet form that modifies properties on the form or controls (e.g. Textbox.Locked). Access intends to save the datasheet column widths without saving the properties changed in code, and that process was not working as expected. We are planning to fix this, but in the meantime, you may be able to work around this if you can avoid changing form/control properties in code (e.g. by using Conditional Formatting instead)

  2. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  3. Have a 'Total' Option

    If you select part of a column in Excel, it will provide a total as well as the number of rows selected.

    It would be great to have this feature in Access.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  4. Link Relationships Between Groups of People

    For example, I use access as a work tool. It would be great if I were able to put the contact of a Research PI as one person and then put the whoever else working in the lab as a separate contact but be able to electronically link the names to the Research PI so that when I pull the PI's name up I can see who else is working in the lab.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  5. When a datasheet is filtered, the download button should respect the filter.

    If a user has selected the rows that they are interested in by means of the filters on the datasheet they will expect that the download will deliver a spreadsheet with those rows. Instead they are getting the full list of records and must repeat the filter in excel.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  6. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  7. Crop tracking application for orchard farming

    Should include fertilizer and pesticide application rates, dates, times, lot numbers. Planting, harvest, temp tracking. Cultural managements such as pruning and mowing.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add a visual clue that the data is still being loaded before user can get the drop-down to choose type (e.g., Sum, or Count)

    After I add a Totals row to my datasheet (by clicking the Sigma button), I was expecting to get a drop down when I click on any column for the Totals row. With a Linked Table (SQL Server), I wasn't getting this. I assumed it was because this Totals row would not work for Linked Tables, perhaps?

    I had even asked why this might be with this SQL Server support forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/502dea49-1a92-4fdb-89b0-1d778a7b7df4/not-able-to-display-column-totals-totals-row-in-ms-access-for-linked-table-from-sql-server

    As described in that forum post, the reason I wasn't getting the drop-down allowing me to choose Sum, or Count, etc., was because MS Access was still loading…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  9. Datasheet active row customization

    Please allow to customize the color and font for the selected row.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  10. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  11. Use Delete Key to Clear a Block of Fields in a Table or Query Datasheet

    Excel users expect to highlight a block of cells, press the [Del] key and have those cells cleared. That's not supported in Access. It'd be nice to highlight a set of fields across multiple records, press [Del] and have them cleared if they don't violate any constraints. If a constraint is encountered, the delete process should stop just like it would if a user manually selected each field and pressed Del. This would make Access more intuitive and similar to how Del works in Excel and Word tables, and save hundreds of keystrokes for clearing a simple block of fields.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  12. Autofit all column widths of a table at once, not just the visible ones

    Currently, one can highlight multiple column headers, double click on the right edge and have all the field widths autosize to the maximum width of its data. Unfortunately, this is limited to the columns that are visible on screen which makes it cumbersome for tables with lots of fields. Columns beyond the screen are not adjusted and the last one is often adjusted oddly. Excel lets you select the entire worksheet, double click on the edge of one column, and have all the columns resize even if they aren’t currently visible. We would like to see the same in Access.…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  13. I can't right

    I can't right on here even the other Microsoft apps.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  14. Template for mailing labels

    I want first name, last name, address, city, state, zip , sent, received, email.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  15. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  16. Protect data

    It needs to be more difficult to accidentally delete data in the database. I don't know how you do this, but all I know is Access automatically saves changes even when I don't want it to. If I accidentally delete something, it's gone forever.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  17. Drag a datasheet to Excel

    Instead of manual ctl-A, Ctl-c, open excel, new worksheet, ctl-v.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  18. For medium bandwidth connections to SQL Server attached tables speed issue

    For medium/lower bandwidth connections to SQL Server attached tables, Access datasheet performance (scrolling, window refreshes) slows down when "allow additions" is set to false and "allow edits" is true. If set to true but set to false on form open, the performance is good.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  19. Fix: runtime error 7771 when using VBA ColumnOrder in MS Access 2016

    I am trying to arrange datasheet columns for users, when a form loads. I have code (in a module) that sets the "ColumnOrder" property, using the OnLoad trigger for the form.

    I receive the runtime error '7771':
    "You can't set the ColumnOrder property when you are in Form view or PrintPreview."

    I'm also updating ColumnHidden, and ColumnWidth, using data saved in a table, so that users can save their datasheet view settings and have them regardless of which desktop they're working on. This is an access front end, linked to a SQL server storage.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  20. get more things to do on the website

    their should be more improvement on the app

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base