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. Changing theme in access 365 proplus

    It seems not possible to change the theme to black in Access 365 ProPlus. I have installed on another computer Access 365 Home and I can change it there. Further, all other ProPlus applications can be changed to Black. I have set the "UI" in registry editor to 4 which enables the colour options to increase to 4 - Colorful, Dark, Black, and White. only colorful and white are available in Access ProPlus, access home there are all 4 colours available

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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 →
  3. make set_spapprole work in a VBA context

    SQL Server (see https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-setapprole-transact-sql?view=sql-server-2017) has a great security feature to allow an app to assume a security role when connected to the server. This doesn't work from Access VBA. This leaves us having to give permissions to data that users can subvert. Whilst this can be mitigated, if Access could connect using a user account with no permissions, and switch to an app role with the right permissions security would be wonderful. SetAppRole is particular pleasant in that in the context we still know the original user who started the app.

    21 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 →
  4. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Interactive Reports

    Many of my Clients ask for interactive reports for example the ability to change a Manager name by means of a Combo box, but still have the facility to print in a nicely formatted way. It is more intuitive than having to enter criteria in a form which the user then has to click on to see the corresponding report.

    This feature will also make reports easier to use for the semi-skilled Access User and provide a much more powerful Reporting System..

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add Save As... back to the Query context menu

    In earlier version of Access, when you modified a query the context menu had the choices of “Save”, “Save As…” and “Close” in the context menu. Since the ribbon was introduced, the context menu only provides “Save” and “Close”, if you’ve made a change in the query and don’t want to over write the existing one, you have to go to the File | Save Object As route to get to the “Save As..” dialog box.

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  7. 20 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 →
  8. New Property, Filter for Combo Box

    Scenario: Product Obsolete.
    if product is marked as obsolete then we do not want it to appear on the combo drop down list but still must be visible to display historic data.

    The Hack involves hiding a second drop down behind the first with a different rowsource, on click of the first we swap focus to the rear dropdown which then retrieves the required value without effecting the bound tables historical data.

    Can you apply a filter to a combo box, on focus, for addition of records.

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Form scaling and splitter bars

    Provide for splitter bars as well as form size scaling

    20 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 →
  10. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Please allow the storing of comments in the SQL of stored queries.

    If a query is at all complicated, it can be good to store comments, but this is not possible currently in Access.

    19 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 →
  12. Create a truly locked down FE format

    ULS was a pain and way too many people implemented it incorrectly but it did serve a function which we have lost. People who develop Access apps for others need a way to completely lock down the FE. The .accde doesn't cut it because users can still modify tables, queries, and macros. We need something that acts like the .accdr but which isn't a trick. I understand why creating an .exe is not an option but you should be able to create a "permanent" format that acts like .accdr but which can't be undone by simply renaming the file. That…

    19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  13. Cambiar la altura de la fila de encabezado en un hoja de datos

    La idea es poder manipular la altura de la fila de encabezado de una hoja de datos para poder darle un alto suficiente capaz de mostrar todo el título de la columna, pero sin cambiar su anchura.

    19 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 →
  14. Function to completely hide Access Window (tick box)

    Currently we are having to use custom modules to disable the main access window although these work their the cleanest way of doing things, would it be possible to add a function in the options menu to hide the Main Access window and only show Popup forms and reports.

    19 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 →
  15. 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 →
  16. System Resource Exceeded, On Big Table

    Can not allways count rows, update fields (ADODB/DAO),
    SUCCESS RATE ................ONLY 40-80%...!!!!
    BUG, Confirmed by :.......... Deepak Panchal10 - 9,745Points
    Microsoft Office for Developers.Access for Developers

    https://social.msdn.microsoft.com/Forums/office/en-US/6d973b12-b6e7-4386-8a59-0528645e570a/system-resource-exceeded-on-big-table-825942-rows-2147467259-access-2013?forum=accessdev#0c68222d-28cd-4115-bb46-ac63f81eecbc

    19 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 →
  17. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Package accdr with the runtime

    Please make Access package the runtime with mde/accde/accdr into a standalone EXE like VFP and RBase to avoid the annoying setup and version conflict and make it a truly stand alone app.

    19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  19. 18 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 →
  20. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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