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. 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
    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 →
  2. 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
    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 →
  3. 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
    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 →
  4. 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
    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 →
  5. 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
    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. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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
    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. 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
    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. 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
    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. 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 →
  14. 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
    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. 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
    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. 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
    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. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
← Previous 1
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base