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.

Provide for splitter bars as well as form size scaling

If in SQL View of a query it is extremely annoying not to have the replace command handy.

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

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.

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.

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

Async and await like .net.
Access as an application that connects to remote data (sql server or web apis) and then freezes on every call makes no good user experience.

Error-handling: Buy out EverythingAccess.com's vbWatchdog add-in and incorporate it into VBA. It makes error-handling so much easier and much like that in .NET.

A frequent task in Access is to import some or all database objects from an existing database into a blank new database. After that, we must painstakingly set all non-standard VBA references in the new database the same way as in the old one.
It would be nice if we could specify in the Import Objects dialog which references should be copied from the existing database into the new one.

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

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.

The current workaround is to UNION a LEFT OUTER JOIN and a RIGHT OUTER JOIN together. This is repetitive and error-prone. Please implement the FULL OUTER JOIN in Access.

I would think after all these years MS has a pretty good knowldge about reasons for file corruption. It is quite the joy when The dreaded dialog that deletes Your vba Project appears...