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. Permit the Properties Window to be displayed in Form View again

    In Access 2003, an object on an open form could be right-clicked | Properties chosen, and then the [Event Procedure] of the object could be displayed. This allowed the developer to open the code behind an object while the form was open and working. This was highly productive for the developer, as the code for open objects could be adjusted, tests run, and further objects adjusted and so on.
    This was removed from Access 2007+ and is a HUGE drag on developer productivity as either the form must be constantly shifted back-and-forth from Design View to Form View --losing the…

    4 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  ·  Flag idea as inappropriate…  ·  Admin →
  2. Improve design speed on databases with lots of tables attached

    On some clients site I have been working, it's quite frequent to have 200 more linked tables pointing to 2 or 3 different servers (MS or Oracle). In such databases, switching forms/reports to design mode can take a minute or more, clicking in design view in a subform (or back to the main form) takes enough time to grab a coffee. It's often faster to close and reopen in the desired mode than to switch modes.This should be really improved.

    5 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  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add capability to call stored procedures with DAO

    Please add the capability to call stored procedures in a remote ODBC database with DAO, like it existed in the past with ODBC-Direct-Workspaces.
    Pass-Through-Queries are only a kludge because parameters have to be concatenated into the sql string.

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add a new operator to Group By queries

    Let's call it something like "Concat". It would concatenate values in a field instead of summing them.

    Take this query:
    SELECT Product, Concat(Color) FROM ProductColors GROUP BY Product. The result might be something like this:

    Flag Red, White, Blue
    Tractor Green, Red

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Make it easier to select and change printers

    Especially important if user has runtime Access and/or maybe using an accde file.

    40 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Enhance Vertical Text to turn 90, 180, 270 degrees

    Idea here is, that you should be able to turn text a) not only top to bottom but also b) flipped and c) bottom to top

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. System help forms - allow resize

    Lots of system help forms (i.E. on Query the search table or the references form in VBA to search DLLs ) are far too small and the user cannot resizre them, why ? Just allow to pull them bigger would help

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. SQL View - Add replace to edit mode

    If in SQL View of a query it is extremely annoying not to have the replace command handy.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. BrowseTo add parameter OpenArgs

    Why not have an OpenArgs parameter like in docmd.openform ? Would enable to react in forms based on OpenArgs - especially helpful when you want to open a form on several places with different actions.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow more reliable way of saving pop up windows position and size

    Spent today trying to save pop up form windows size with popular or a dialogue but the windows kept reverting or opened off screen on a dual. Monitor Pc - and I can't tell whether if it persists whether will do properly on a single monitor PC

    2 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  ·  Flag idea as inappropriate…  ·  Admin →
  11. Make Access again able to import / export / transform as many file types / legacy files like it used to

    Ability to open and convert .mdb was removed in Access 2013. Put that all back

    12 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  ·  Flag idea as inappropriate…  ·  Admin →
  12. Show Tools Vertically

    When the ribbons began being used, we lost the ability to display the toolbox vertically. Despite using the ribbon for several years now, I have not gotten faster at picking up the right tool quickly.

    When the toolbox could be displayed vertically, I practically didn't even have to look at the tools, I knew where they were positionally.

    It is much faster to design when the toolbox can be vertical.

    thanks

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Open Macros in a Narrower Window

    When the macro window opens, it is much wider than it needs to be
    If people write long comments, they can make it wider at that time.
    If the Action Catalog is displayed, the window is so wide that you can't see the scrollbar

    5 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  ·  Flag idea as inappropriate…  ·  Admin →
  14. Table and Field Name Validation

    Validate table and field names when saving changes to a Table to Prevent Special Characters in Table or Field Names or Reserved Words as Table or Field Names.

    7 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  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow JET/Ace SQL To support Multiple SQL Statements and comments.

    This will make the supported CREATE PROCEDURE statement begin to be actually meaningful.

    Also, permit the Query Editor SQL view to RETAIN WHITESPACE & tabs used for FORMATTING (indenting) in the SQL. to enhance readability.

    46 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Enable Ctrl-Spacebar to Popup Intellisense in Queries

    When designing queries, it would be nice if Ctrl-Spacebar could be used (as in VBA) to pop up intellisense when typing expressions, criteria, AppendTo, ...

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Intellisense/Builder Recognize Table/Query Aliases

    It would be nice if Intellisense/Builder would recognize Table/Query Aliases

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Reference from Relative Position in a Query

    In Queries, it would be nice to be able to reference a value in a record relative to the current one.

    For instance, many times it is required to get a difference in a changed value

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. Export Options

    When exporting, it would be nice to be able to choose how data in form/page headers/footers will be treated:


    1. as displayed

    2. only at top and bottom

    3. do not include

    especially for RTF and formats that will end up in Word

    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  ·  Flag idea as inappropriate…  ·  Admin →
  20. MsgBox Custom Choices

    With MsgBox, we can process vbYes, vbNo and other built-in choices ... it would be nice to be able to have 3 custom choices ... ie: vbCustom1 and vbCustom1Caption, vbCustom2 and vbCustom2Caption, vbCustom3 and vbCustom3Caption,

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base