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. 24 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 →
  2. Fix rendering of VBA UserForms with Parent controls (eg. Frames) in Access 2003+ file formats

    The Access 2000 mdb format supports VBA UserForms with normal and parent controls, but all database formats beyond Access 2003 (ACCDB) only render UserForms that do not include Parent controls.

    Being able to reuse UserForms across VBA hosts is a very useful way of reusing code and User Interfaces, but a runtime error (Error 75) occurs when trying to render a UserForm in an ACCDB database format, when there is a Parent control (such as a Frame or MultiPage control) present.

    Parent controls enable rich functionality and more intuitive UI, but Access fails to render the forms, with an error…

    24 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 custom controls and a gallery

    Due to wide variance among different industries, I think Access is best benefited if users are enabled to author and share custom data-bindable controls. That would enable industries to build controls customized to their particular need, and hopefully share with one other, making it easier to develop with Access even for those who don't have the programming expertise to author it themselves. Look at PowerBI gallery as an example of how this can be a success story for Access.

    24 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  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  4. import from excel

    Better control of datatypes when importing from Excel or linking to a worksheet.

    Currently the import decides for you using the first few rows, so often you have truncated memo fields when the first few rows are less than 255 char or errors when the first few rows are numeric but later rows are alpha numeric.

    When importing into an existing table the import should honor the datatypes in the table.

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

    23 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  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    23 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 →
  7. with accde: create forms and controls at runtime. even reports.

    how wonderful it would be to have programmatic access to create forms and Controls at runtime (compiled version)
    Even The ability to create and change reports.

    22 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  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  8. 22 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 →
  9. 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

    22 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 →
  10. Create PDF-File with merge function

    Create more than one PDF-File from the Report and merge the PDF-File to one PDF-File

    22 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 →
  11. Create a stand alone file independently version of Access or Runtime and 32 or 64 bit architecture

    Due to the currently conflicts between versions, I think it would be necessary to create a stand alone file that can be run independently of the version of Access or Runtime and 32 or 64 bit architecture, that the user has installed!!

    22 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 →
  12. 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

    We're glad you're here

    Please sign in to leave feedback

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

    22 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  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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 →
  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.

    21 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  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    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 →
  17. add event: Before Leave Record

    an event that would be nice to have is Before Leave Record. This would enable a main form/view to ensure there are are actually detail records

    20 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 →
  18. 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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  20. Form scaling and splitter bars

    Provide for splitter bars as well as form size scaling

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base