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.

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Report Events Need To Be Cleaned Up

    You really need to clean up the Report Event Model so that code inside a Report gets fired the same way in Preview, Report and Print modes. It is obvious from the Internet that lots of people have run into this and there is little or no common-sense help on this issue ... this itself is strange.

    If, for example, you add a message box in the OnOpen Event of a report, the message box fires if you run Docmd.OpenReport with the acViewPreview switch but not if you use the acViewPrint or acViewReport switches.

    If you place the same code…

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  2. Why is it so hard to get at database Objects' metadata?

    These items are VERY useful when we are asked to go fix a previous coder/employee who may or may not be with us any more. Elsewhere in this forum others have suggested adding Notes field with date/time stamps for each object. I endorse that.

    Would be really sweet if there was a quick way to get to items like the Description field in a Table definition, the existing Description field for objects (right click on object in Database or F11 window). I note that a right click is pretty quick, but this means you can only see one object at…

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. Drag a datasheet to Excel

    Instead of manual ctl-A, Ctl-c, open excel, new worksheet, ctl-v.

    2 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 →
  5. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  6. Fix the TransferDatabase command so that it exports tables to Oracle properly.

    When I try to export an Access table into an Oracle database it doesn't retain the input field formats. Everything is converted into a string and the indices are lost. I've contacted Microsoft about this before but got no meaningful response, presumably for petty proprietary reasons.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  7. Have "native english" Naviagation pane - even if using LanguagePack (like german)

    It's hard to find things if you don't know the exact name in english if you search some things - especially because Help doesn't work / help.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. non editable System Queries For Listbox etc.

    Why not enableing the user to select "selected" columns / rows via Query - always looping thru itemselected is not very easy and intuitive.

    Similar is with queries about Tables, queries, forms, reports, indizes fields (like in combobox) and Macros and all the other collections.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  9. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow better control/usage of the office spellchecker

    Often times I want to be able to run a spellchecker on just a single textbox, of just a single row/record. The primary textbox might contain text while other textboxes on the same form could contain references that would not make sense to spellcheck.
    Ideally, as part of the beforeUpdate event of either the textbox or the form, I could run the spellchecker and react accordingly.

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  11. Highlightable property for all controls including rows on continuous forms

    Windows 10 in particular like to highlight controls as you pass over them. This capability should be available for any control and would also be very useful on a continuous form to highlight a particular row as you mouse over.

    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 →
  12. custom menu

    Bring menus back as an option. The story I heard was that MS Access had to go the way of other Office applications. The example was that Word had over 1,400 menu options and most of the tech support calls were to help people find the right menu item. Access is different. Most MS Access application have a limited set of menu options so the need for the Ribbon interface is overkill.

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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
    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. Combox - separate what is shown when "open" to what is shown when "closed"

    If you select values via combobox (you open it to show a list of values) then i often want to restrict what is shown there, but if combobox is "closed" (just the result is shown) then i do not want to apply any restriction there. (When closed Show "Select Names form tblAdress" but for show selection: SELECT Names from tblAdress WHERE dept = 1; ) ...

    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 →
  15. Make SQL and QBE Smarter

    1. When a query that selects identifiable rows joins to a query that aggregates data, allow rows in the identifiable part to be updated rather than making the query non-updateable. Extend this to heterogeneous joins so if one table in the join is updateable but another is not, allow updates to the updateable one.
    2. Stop smothering expressions with excessive numbers of parentheses. There is no reason that I can think of that would require an individual column name to be enclosed all by itself in parentheses.
    3. Stop reformatting MY SQL strings. I have a work-around for this but…

    31 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Expose Swipe Events on Forms so Touch Screens can be Supported

    Add SwipeLeft, SwipeRight, SwipeUp and SwipeDown events at the form level. Tabs could support Swipe Left and Right to move to the next tab. Datasheets could use it to move in the grid.

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Parallel Processing

    Maybe this is too much to ask. Can we request to to evolve from VBA to vb.net? allowing us to take advantages of parallel executions?

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. java

    Java Driver
    please create a driver for java, so that it would be able to create a android frontend to accdb-databases

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. Additional Error Object properties - which procedure, which module, which object, which db

    The error object should be expanded to included properties which can reveal the procedure, module, and object that the error is taking place in.

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Feedback and Knowledge Base