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.
-
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.
90 votesNote 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)
-
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 -
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 -
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 -
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.
5 votes -
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 -
4 votes
-
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 -
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 -
Datasheet active row customization
Please allow to customize the color and font for the selected row.
3 votes -
3 votes
-
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 -
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 -
I can't right
I can't right on here even the other Microsoft apps.
3 votes -
Template for mailing labels
I want first name, last name, address, city, state, zip , sent, received, email.
3 votes -
3 votes
-
Make the predefined templates more flexible for users
I currently cannot add a column to a predefined template in Access. This makes the template unusable to me, and I only need to add one more column.
There is no "Click to add" option available. Be great if there was!
It would also be useful if it states in the online Help that this is the case; predefined templates cannot be edited. I spent a long time trying to solve this but it was only through online chat support where I eventually found out that adding a column was not possible.
3 votes -
Make the predefined templates more flexible for users
I currently cannot add a column to a predefined template in Access. This makes the template unusable to me, and I only need to add one more column.
There is no "Click to add" option available. Be great if there was!
2 votes -
Drag a datasheet to Excel
Instead of manual ctl-A, Ctl-c, open excel, new worksheet, ctl-v.
2 votes -
Datasheet enhancements
Please increase the size of the footer of the data sheet to make it easier to see and use the record controls. The number of records box should be much bigger to see large record numbers. Also, the search box should be at the top of the datasheet to make it more intuitive to use and be inline with the emphasis Microsoft now gives search in all its applications. I would like to see wrappable columns heading. And the filter button, the add button and a delete and refresh button at the upper right hand part of the datasheet so…
1 vote
- Don't see your idea?