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. 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 →
  2. Include "hide control" feature Continuous Forms

    Currently on Continuous Forms, the developer can enable/disable, along with a few other functionality items relating to conditional formatting. At the moment, there is no "hide/unhide" feature to allow developers to display or not display controls based upon values of a particular row of data. There are ways to do it, but only in a very convoluted way, and very confusing when having to manage the code. Please include this functionality for continuous forms!

    74 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. Add a TreeGrid Control

    A TreeGrid control could be used in forms, or as just a Tree control. This should be a somewhat customizable look and feel.

    44 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 →
  5. Allow arrow up/down keys to move between previous/next row in continuous form

    In a datasheet form we can navigate left/right as well as up/down, navigating between different rows of the recordset.

    In continuous forms the up/down errors behave the same as left/right.

    Nowadays, to achieve the described behavior we have to catch the KeyDown event in a continuous form and MoveNext or MovePrevious with error handling for first/last record etc.

    Instead the behavior should be the same as in datasheet form.
    There can be an option similar to "Move after <Enter>".

    44 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  6. BugFix: Combo Datatype bug

    Please fix the combo box RowSource datatype binding bug.

    The bug is as follows:
    1. Create a table [Table1] with two columns:
    - [NumberField], datatype: Number, Double
    - [TextField], datatype: Short Text

    Add 1 Row to the table:
    [NumberField] = 10
    [TextField] = "Some Text 10"


    1. Create a combo box:

    2. Set the RowSource of the combo box to this:
      SELECT NumberField, TextField FROM Table1;


    3. Add a Button to the form: [cmbErrorExample]
      Add On Click Event:
      If Me.cmbErrorExample.RowSource = "SELECT NumberField, TextField FROM Table1;" Then
      Me.cmbErrorExample.RowSource = "SELECT TextField, NumberField FROM Table1;"
      Me.cmbErrorExample.DefaultValue = "Some Text 10"
      Me.cmbErrorExample.Value = "Some Text…

    37 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. Custom naming on message boxes

    When using the vbYesNo message box you can only have 'Yes' or 'No' options. I would like to be able to rename these options. Currently the only way round it is to create a form to look like a message box.

    36 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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 →
  9. Deal with sleep mode properly for tablet environments

    When a tablet or PC goes into sleep mode any active form looses its connection to the database backend (I am using SQL Server). This is very annoying in tablet environments where the PC is frequently switched to sleep mode. Make it so that Access can detect a reawaken from sleep and refresh the connection automatically rather than leave an error so that the user doesn't have to log off and reload the screen.

    27 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 →
  10. Macroes vs VBA in Button Wizard

    When using the Button wizard MS Access creates macroes as default. This should be an option if you prefeer macroes or vb as the event code.

    25 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix rendering of VBA UserForms with Parent controls (eg. Frames) in Access 2003+ file formats

    The Access 2000 mdb format supports VBA UserForms with normal and parent controls, but all database formats beyond Access 2003 (ACCDB) only render UserForms that do not include Parent controls.

    Being able to reuse UserForms across VBA hosts is a very useful way of reusing code and User Interfaces, but a runtime error (Error 75) occurs when trying to render a UserForm in an ACCDB database format, when there is a Parent control (such as a Frame or MultiPage control) present.

    Parent controls enable rich functionality and more intuitive UI, but Access fails to render the forms, with an error…

    24 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 →
  12. All the 32 bit dll and ocx should work in 64 bit os and office

    We are working with 32-bit add-ins for access. But it is not possible to work in 64 bit system which I am using.

    23 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 →
  13. State of the Art Replacement for Active X MS Calendar

    Everything revolves around time and Microsoft Active X Calendar is(was?) the perfect tool to use in a lot of applications we've prepared over the years. This gem works seamlessly even in continuous forms while current datepickers associated with textboxes won't do and subforms won't do and equally seamlessly integrates with VBA code and queries and control sources SQL. It doesn't work in Access 64 bit so it's about time to come up with a state-of-the-art replacement but even simply enabling it for 64 bit would suffice.

    19 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 →
  14. Limits are reached - if I open one more form: Error 3048: Cannot open any more databases

    I have 2 reports and 1 form open. Each of theses has complex data sources (with many joins, subqueries...). If I open an fourth report - I get the error message.

    I think the limits are to low. Please upgrade them.

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  15. improve performance of conditional formating

    conditional formating is a great feature but slow when data is not small and forms flicker. Can you please improve that?
    By the way: Shadows of Buttons flicker too.

    12 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 →
  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. 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 →
  18. Allow developer to put animations like gif images or flash

    Review the shockwave flash object and put a animated gif component.
    An example for usage:
    a) We can use little flash animations in splash screens
    b) Animated gifs could be an option instead of progressbars (like the "loading" icons we see on web pages)

    We do have a shockwave flash component - but at least here I can't make it work in Access 2013). The gif idea came from a customer.

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  19. Can we have a Separate Time Picker Control

    Often Date and Time are stored separately. To ensure the correct time is entered one has to write a fair bit of code to determine 24 hour time or AM/PM are entered correctly. A Time picker would have two Combo boxes, one for hours and one for minutes -and even show the time on a dial.

    10 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 →
  20. Outlook style navigation control for users when running an application

    Have the navigation pane have two modes. The default design pane or an Outlook style navigation control that can be used by the application. It would have properties that would run various objects like forms, reports, queries or code but no design capabilities. Even allow for multiple navigation control object for multi user roles but the application would only be set to one navigation control in the navigation pane. People are used to the Outlook paradigm.

    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 →
← Previous 1 3 4 5 6
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base