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. Autocomplete for calculated access form controls

    When in form design mode. It's really time consuming write calculated fields. It would be great to have autocomplete formula like for built in access functions and database objects directly inside edited control.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  2. Gui ribbon editor

    Allow access developers to create or edit a ribbon with a gui rather than having to write xml.

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  3. Select Navigation control Tab programmatically

    Hi Team,

    Currently we use this command to switch to a tab in a
    NavigationControl

    DoCmd.BrowseTo acBrowseToForm, TabToOpen, Me.name & ".NavigationSubform"

    This works fine if there is a unique NavigationTargetName for the selected Tab/Button. If we have two or more Tabs with the same target form name, we are unable to open a specific Tab. The first tab with the matching targetName is opened.

    I.e. TabA and TabC has the same targetFormName X
    if we use the following command

    DoCmd.BrowseTo acBrowseToForm, X, Me.name & ".NavigationSubform"

    TabA is activated.

    Problem: How do we activate TabC?

    Regarding why we have same targetFormName:…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add sorting and grouping to multiple-item forms

    Add sorting and grouping to multiple-item forms, working in the same way as found in reports. You'll probably need to prevent the addition of editable/save-able fields in the group headers and footers though (maybe force them to Enable=false and/or Locked=true).

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  5. ITEMS in Detail Section with Crosstab Queries and specified fixed headings should have option to suppress repeating

    Whenever an ITEM such as a heading progress bar is in the Detail section, so if you display the form as Continuous Forms, you will see a progress bar in each displayed record. It will happen whenever a Continuous Form displays more than one record.

    The only way to avoid this is to move the progress bar to the form header (or footer) section.

    Please refer to the attached design, on the very last page described in microsoft forums.

    https://answers.microsoft.com/en-us/msoffice/forum/msofficeaccess-msowindows8-mso_2010/crosstab-query-to-display-all-records-according-to/b98b9372-1a83-402d-b54d-87ca5b7a7407?messageId=c8966d76-2bcd-4a49-a1cc-83cdcf71a483

    Either an access development enhancement to enable this would provide more flexibility to create complicated reports.

    Thank you…

    28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  6. Picture viewer like web site

    For a recording, viewer externals pictures (folders & names in a table) with 3-5 thumbnails if several images for the recording.
    Zoom with a clic on a thumbnail.
    Functionnality to add new images or delete imge for the table.

    Native functionality.
    It 's possible with a VBA code but if it's a build-in...

    Thanks

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  7. conditional formating rules on controls

    Add the ability to set border color and thickness and line type. Also allow conditional formatting for checkboxes - Would be nice to not have to do this all in code.

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  8. Improve the Basic Graphics Model

    Add levels of transparency, blur, shadows, and drop shadows. We can fake some of these today, but it takes a lot of resources and time. These are all things needed to make apps look modern in Windows 10.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  9. User Defined Enumerates in Expression Box

    I create user-defined enumerates in VBA quite often, it would be helpful to use those in the expression box i.e. when calling a user defined VBA function and supplying a parameter, so I could start typing the Enum name and IntelliSense would finish the name and when typing a . (dot) provide a list of values for that Enum.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  10. design wizzard to transform old apps in modern design

    there are so many good working Access applications but too many look Grey-old like norhwind.
    Please make a simple Transformation wizzard for forms to Change the design of all existing forms in one Application. Change Color, font, increase space between controls, bring alle Buttons to a modern design and Standard Actions on buttons with a modern Icon, endless forms with alterning Colors ….
    this could increase the value of many Access applications and the Image of access!

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  11. Allow for key-in object name in Form/Report property sheet

    Right now we must select an object from the drop down list. Depending on the number of objects on a form it can be rather time consuming to scroll to the object you want. It would more user friendly to allow input of the object name just like in a combo box in access.

    Thanks for your consideration!

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  12. pre-filled contact sheet, that is blank to match the entry structure of contacts blank

    make a printable template sheet that matches info to fill in new contacts for written on the road use.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  13. Please create global methods to deactivate the CTRL+MINUS (delete the current record) and the CTRL+PLUS (add record) shortcut:

    Please create global methods to deactivate the CTRL+MINUS (delete the current record) and the CTRL+PLUS (add record) shortcut:
    • Bug report: In some forms AllowDeletions is mysteriously set to true, even if the form has AllowDeletions = False set (this is only displayed correctly in debug mode). CTRL-Minus then deletes a record without question. Calling Me.AllowDeletions = False in the Form_Open event helps. Access option "Confirm Record Changes" was not set.
    • In the AutoKeys macro sub-macros for ^{-} and ^{+} are not allowed (but {DEL}, ^{DEL}, ^{X} are possible).
    • The Access option "Confirm Record Changes" is helpful, but…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  14. Can we have onClick() events on the bars/columns/slices in the new charts

    Love the new charts but can we have onClick() events on the bars/columns/slices so that create drill downs using VBA
    Always made me sad that MSGraph had events in Excel but not Access.

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  15. ComboBox

    Why Did Not Applied Property ( LineStyle ) For ListBox Or Combobox In Access 2007

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add a ListView control as an alternative to the ListBox.

    Add a ListView control like the one in Dynamics AX. The control should NOT HAVE master/child field linking. Only needs an after-update event that triggers when the user clicks on a row, just like a ListBox.

    Access ListBox is frequently used for form navigation. It’s easy to implement but has several serious drawbacks.

    Its worst drawback is the form blinking that occurs when the AfterUpdate event is triggered. This makes your form functionality unprofessional.

    Other drawbacks: It’s static, user can’t adjust column width or row height. Can’t be filtered or copied from.

    The current work around is to use a…

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow custom controls and a gallery

    Due to wide variance among different industries, I think Access is best benefited if users are enabled to author and share custom data-bindable controls. That would enable industries to build controls customized to their particular need, and hopefully share with one other, making it easier to develop with Access even for those who don't have the programming expertise to author it themselves. Look at PowerBI gallery as an example of how this can be a success story for Access.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  18. Access Student db could have a function for managing student grades as well

    Access Student db could have a function for managing student grades as well. Will be fantastic for people like me who manage grades on Excel sheets. Thank you.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  19. Subform in continous form

    Today we can't use a subform in a continous form.

    151 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  20. Listbox update

    Have a fully programmable listbox with events like comctl listbox and treeview we had. Sizable columns, header click, sorting, image support.

    65 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base