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.
-
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 -
1 vote
-
On the main screen in Virtuoso, move the "Overall Health" column closer to the project name column.To will eliminate need to scroll over
On the main screen in Virtuoso, move the "Overall Health" column closer to the project name column. To will eliminate need to scroll over to see the Over Health column as you look through the list
1 vote -
Bring back table wizard
This feature helped a lot of people to be productive I think now a lot of people are having trouble with creating a database I think with this feature it will bring back the productivity in this app other version starting in Access 95 had this great feature and I think that is gone in Access 2016/2019 people have trouble with productivity in Access
1 vote -
Bring back table wizard
This feature helped a lot of people to be productive I think now a lot of people are having trouble with creating a database I think with this feature it will bring back the productivity in this app other version starting in Access 95 had this great feature and I think that is gone in Access 2016/2019 people have trouble with productivity in Access
1 vote -
Why not define a Ctrl-". This would fill a field with one date higher than the field above it.
I do a fair amount of data entry that involves date data into a database table. I can use the Ctrl-' function to add to the field the data in the same field directly above it. This is great. But I have to enter a lot of records with dates, and the new record is for a different date, usually the next date on the calendar. So if there was a function Ctrl-", I would be able to directly add the next day to this record when compared to the record above it. For example if Record 12 has a…
1 vote -
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 -
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 -
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 -
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 -
I can't right
I can't right on here even the other Microsoft apps.
3 votes -
Dual Windows support
Unlike Excel/Visual Studio Code/Chrome. Currently, Access Desktop has no split screen/windows feather. It is hard to compare the data and check data structure to write query.
It would be better to have a split screen feature.1 vote -
Faster CTRL+F datasheet functionality
Sometimes when I do a CTRL+F search on a column in datasheet mode, it takes much longer to complete than if I apply a column filter that does more or less the same thing. I suggest that you re-program your CTRL+F search function so that it makes use of query filters, to make it work faster.
1 vote -
Inventory sheet: # , item, serial number, model number, size, Price$
Should be in 14pt and vertical lines between items. spacing of horizontal lines should be 1/4 inch wide.
Primary use would be for 2nd hand store, or pawn shop.1 vote -
Template for mailing labels
I want first name, last name, address, city, state, zip , sent, received, email.
3 votes -
Add a second email line to allow for business and personal emails
I need to input both business and personal email addresses when I receive them. So having an Email 1 and Email 2 line would be fantastic even if the Email 2 line is optional.
1 vote -
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 -
Record not show full
I don't know why, this morning I update Windows, after update, in datasheet and forms, record not show full, show about 10%, but when I click on the Last record button, it just show full, I do not this is new feather or error. Please answer me, Thank you so much.
1 vote -
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
- Don't see your idea?