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.
-
get more things to do on the website
their should be more improvement on the app
1 vote -
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 -
1 vote
-
4 votes
-
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 -
3 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 -
3 votes
-
1 vote
-
Datasheet active row customization
Please allow to customize the color and font for the selected row.
3 votes -
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 -
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 -
Drag a datasheet to Excel
Instead of manual ctl-A, Ctl-c, open excel, new worksheet, ctl-v.
2 votes -
Allow Object Model Manipulation of the ctl.Filter.ValueList.RowSource in a Form Datasheet
The Filter Value List in datasheets is set to scan the full recordset's field to display a unique list. This takes time and i/o in a pure .accdb recordsource and worse, will not work if the recordset is based directly on an ODBC attached source.
Many Filter Value Lists are sourced from fields which are foreign keys to look up tables - we could intervene by feeding the look up table as source for the Filter Value List.
1 vote -
Increase the size of the record display in datasheet view footer
Right now the size is not big enough in many cases depending on the number of records. Since datasheets are usually wide anyway, this can be easily increased.
0 votes -
Allow disable of filter icon on datasheet at the bottom.
On many forms I create, I include filtering fields at the top of the form, a filter and clear filter button and the datasheet below. If the user unclicks the filter on the datasheet, this causes issues as the filtering on the form above is not cleared at the same time because the main form does not know about the "unfiltering" below. If the datasheet view had a property that controlled the "filtered" button option. If disabled, just show the word filtered if it has been but not clickable.
1 vote
- Don't see your idea?