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. Add Search Bar history, and maybe logical operators like AND, OR, NOT

    I use the Search Bar in the Navigation Pane a lot. And specially if you name queries, forms, tables etc with same prefix/suffix code (ie q03CustomerList, f03CustomerList) you get the various objects that is connected to each other just by searching 03. It is really fast and easy to design/work on your objects this way. But what I often miss is a Search Bar history, showing the different searches you have done during a working day. Another nice feature to add is ability to have logical operators (AND, OR, NOT) in the Search Bar...

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. add a windows server cliant for access

    Would like to have a server set up for access so that those who have large datbases can stroe them on a server and all users would connect to server to reteave the tables or reports they need.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add "on action" to the alternatives when a user clicks on a ribbon tab.

    We need the ability to display a particular form on tab click.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. commandbar

    Please provide a meaningful value (other than the current " ") for the Name property of the Commandbar object representing the shortcut menu which comes up when you right-click the very top of a Form open in Form mode (and ditto for reports) so that this can easily be disabled in code. It is currently one of three Commandbars with no meaningful Name.

    0 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 →
  5. Resolve Missing ACE Drivers for local registry and out-of-process scripts for Click-to-Run deployments

    The Host OS is unable to locate or use the ACE engine drivers for purposes of out-of-process automation calls, or ODBC connections when Office is deployed under Click-to-Run deployment models. This needs to be corrected so that out-of-process automation and ODBC calls can succeed no matter which deployment model is selected for deployment of Office/MS-Access components.

    4 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 →
  6. Fix the Database Documenter so it returns the correct value for Query RecordsetType.

    In Access 2007 and 2010, the Database Documenter returns the wrong value for Query RecordsetTypes.

    If a query has the Recordset Type set to 'Snapshot' in the Design view, the Database Documenter reports that the Recordset Type is 'Dynaset (Inconsistent Updates)'.

    If a query has the Recordset Type set to 'Dynaset (Inconsistent Updates)', the Database Documenter reports that the Recordset Type is '0' (which I believe is the value for 'Dynaset').

    Setting the Recordset Type to 'Dynaset' does return the correct value in the Database Documenter, but this is the only setting to do so.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Imagem desktop Control - bug fix

    Enable the image control in form and reports show all kinds of images stored in database in app office365 (SQL). Currently error occurs and the image is not displayed. Using third-party ActiveX contoles, works.

    1 vote
    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 →

    Thanks for making this suggestion.
    This is not a bug but a behavior that is by design.
    There are no current plans to change the existing image control

    Thanks,
    Michal [MSFT]

  8. Allow Quick Style to be imported from database to database

    I had some issues with a database. Getting messages like "file is missing". To get rid of it I opened a new database and imported all from the first one. After that the database works just fine, but colors on buttons changed.

    The two databases, the "original" and the "imported" has Office Standards Theme. I cant find anything in settings that could explain the different colors.

    On Access developers forum people found this issue still exists in version 2016. I use 2013.

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

    a html Editor Control would be very nice
    - Show html Source (bound)
    - simple edit functions: bold, font, fontsize, insert Picture, Link
    a Kind of more powerful rich text Control but with a real permanent toolbar and more html-Support

    5 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 →
  10. Add ability to expand/collapse all object groups in Navigation Pane

    Similar to what you have in macro design view. And please, a keystroke equivalent! Thank you.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. return the current object status bar display during Database Documenter

    return the current object status bar display during Database Documenter

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Include DAX support within Access Services QBE

    Since Access Services is become the Ad Hoc RDB tool for BI it would be great to have Access share DAX features and functions as many of the functions in DAX could be used to clean-up and transform data for Power BI to visualize (e.g., Relate, RelateTable, Value, etc.

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Use scope_identity() to refresh linked SQL-Server tables or views

    After inserting a row into a linked SQL-Server-table or view Access is refreshing the row. For these query on the new row, Access builds a where-condition which compares all fields with the known values.

    If a inserted value gets changed in the meantime e. g. by a Trigger, the where-condition fails and the returned resultset is empfy. Access is showing then the text "#deleted" in the row.

    Before SQL-Server 2008 this was probably the only way, to get the new identity of the new row.

    Since SQL-Server 2008 exists the function scope_identity() which returns the new identity of a row…

    4 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 →
  14. Add SQL view in Access Service QBE and enhance SQL support to be equivalent to Desktop functionality is Desktop

    Currently ACCESS Services has datasheet view and QBE, why not SQL view like Access Desktop given its a Azure backend it would only make sense.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Access Product Improvement SQL query Access

    I made this suggestion on another site and someone pointed me to this one so I am adding it here as well....

    http://answers.microsoft.com/en-us/office/forum/office_2016-access/access-product-improvement/4ba8de7f-638f-4429-9e00-5ba454b047a7

    I am trying to provide a suggestion for Office Access, I really can't believe this has been added already.

    When right clicking on a query in the database object listing, you know, tables, queries, reports, forms, etc. On the query right click pop menu, PLEASE add a link to open up directly to the SQL view for the query, instead of the design view, where we then need to go to the menu bar and select from…

    8 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 →
  16. 21 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 →
  17. Visual indicator of unsaved changes

    It would be nice to have some sort of indicator on the tab bar that shows if a query/table/... has been modified without saving, like a star "*" at the end of the name.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Tab seamlessly between subform and main form

    For a subform control, add a property to allow tabbing to next control on main form when at the end of the record(s) in the subform. This will allow for seamless tabbing from the user instead of one of the following:
    1) having to know about ctrl+tab
    2) requiring a mouse to get out of a subform and back to the main form
    3) adding a work-around by adding a control and coding in VBA to setfocus back to the next control on the main form

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Summary Row in DataGrid-view on SQL-Server tables builds Aggregat on Client instead of using serverside aggregate-functions

    When using the summary row in a DataGrid-view with SQL-Server-tables or views the Aggregate is build on the clientside, which is very slow when rowcount is high. Continually all rows are fetched to build summary. When ready, it starts again.

    Please use sum(), avg()...-Aggregate-functions to get the summary.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Add some basic (fundamental) checks to text-fields

    Add some basic restrictions/rules to text fields like
    - numbers only (incl./excl. .,+-< >)
    - only characters ... allowed
    -- like a to z, A to Z, ABC, incl./excl. language specifics (like ü û)
    - entry must be between (1 to 999, 427 to 634, AAA to BBB)

    Also add some basic formatting like
    - convert to lower case
    - convert to upper case
    - convert to web-compatible
    - convert to date/time (enter 290416 to get 29.04.2016 or 1534 to get 15:34)
    - convert using Word rules
    - convert to ... (EBCDIC, Codepage xyz, Unicode...)

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base