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. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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

    We're glad you're here

    Please sign in to leave feedback

    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  5. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  12. get more things to do on the website

    their should be more improvement on the app

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  13. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  14. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
2 Next →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base