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

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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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 →
  9. 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 →
  10. Resolve ODBC / SQL Server issues with NVARCHAR(MAX) and REAL

    Several SQL Server / ODBC data types poorly supported. I have just found that NVARCHAR(MAX) is the recommended SQL Server memo field type but Access is inconsistent in handling this - text larger than 4000 characters fails to update.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  11. Better Backwards Compatibility

    I have three version of MS Access - 2013, 2010 and 2007. I need this so if I develop a DB with library references (in particular the MS Excel library) and it has to work in an earlier version of Access (so if I developed it in 2013 but it has to work in 2010) I have to open it in 2010 and make sure the references are not missing before giving it to a user. I have tried multiple times to write code that will try and remove the missing reference and add a valid one but why? These…

    18 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 →
  12. 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 →
  13. Make it possible to stop Access Desktop from being an Automation Server so that security is improved

    Currently, if a user has Access running, much of what is meant to be secured can be accessed from another program, e.g. Excel, via Automation. This is not good.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Provide a better link to Outlook especially for adding appointments

    I have always wanted to be able to add appointments to Outlook via the link to the PST file using an append query.

    9 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. 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 →
  16. Table column count to the same than in SQL Server

    It makes it much simpler to create applications if 254 column restriction is not applied like in Access. Unfortunately in Engineering system I can't avoid using more than 254 columns. Computer speed is not anymore a problem so why to have that limit.

    8 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 →
  17. 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 →
  18. DSN less connection wizard

    Please design a wizard for dns-less coonections to SQL databases. Make it easier to use Access as frontend devolpment for different situations.
    Other RAD tools have this already.

    11 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 →
  19. 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 →
  20. Ability to Show Property Sheet and Field List at the Same Time

    This is not new ... just missed! We used to be able to show the Property Sheet and Field List at the same time ... I miss this a lot!

    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 →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base