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.

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.

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.

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.

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

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

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

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

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.

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.

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.

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.

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

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.

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

Provide for splitter bars as well as form size scaling