When multiple forms are open and you go into the VBA IDE and then switch back to the GIU view, the object that was selected is no longer selected or the object that thew the VBA error is no longer selected. Furthermore, you can't just select the object from the tabs. You first have to select another object before you can select the one you want.

Please add a standard way to backup your tables to an external database ( file or SQL) on time or in the case of a certian event.

Currently this can be made visible programmatically from an external program via Automation.

Should be able to have a property for controls that can highlight when mouse passes over other than a button. Similar to Windows 10 Start menu or other Windows menus. This should also be allowed for a single row on a continuous form. Perhaps this could be a property in conditional formatting.

Sometimes queries can be expensive, or have errors affecting performance. Currently, if one of these expensive (i.e. very slow) queries is in a form's or control's Data source, (like a Combo Box, for example), that query can be re-evaluate repeatedly and frequently (very slowly EACH TIME) making any effort to edit or design the form a legitimate pain in the keester. Give us the option to cache these query results during development (Design View) so we can work FAST, like Access is supposed to!

In VBA if I want to change the .connect property to a server where I have no access, the tableDef.Refresh generates an error.
I would like to be able to relink from DEV SQL Server to PROD SQL Server before deployment even when I have no access to PROD

Ability to open and convert .mdb was removed in Access 2013. Put that all back

Permit (from VBA?) to instruct a program to run in a specific Core; so if we have a 4core PC, we can run concurrently 4 programs.

When objects are opened, it would be nice if Save also saved the window size (and, optionally, placement)

On some clients site I have been working, it's quite frequent to have 200 more linked tables pointing to 2 or 3 different servers (MS or Oracle). In such databases, switching forms/reports to design mode can take a minute or more, clicking in design view in a subform (or back to the main form) takes enough time to grab a coffee. It's often faster to close and reopen in the desired mode than to switch modes.This should be really improved.

When the macro window opens, it is much wider than it needs to be
If people write long comments, they can make it wider at that time.
If the Action Catalog is displayed, the window is so wide that you can't see the scrollbar

for proper date control, it would be nice to store a GMT date/time instead of Now() in the current time zone

Make Expression Builder available from Visual Basic Editor, as it used to be in Access 97 and before.
Currently it can be opened only from query design view..

When the ribbons began being used, we lost the ability to display the toolbox vertically. Despite using the ribbon for several years now, I have not gotten faster at picking up the right tool quickly.

When the toolbox could be displayed vertically, I practically didn't even have to look at the tools, I knew where they were positionally.

It is much faster to design when the toolbox can be vertical.

thanks

When Browsing for Importing, Exporting, or whatever, it would be nice to be able to have an option to use the last directory used -- even if the database has been closed.

It is difficult to figure out which column of a query that properties are being set for. It would be nice to show the column name at the top of Property Sheet in a Query

thank you

Currently, if a database is opened through code, it requires gymnastics to avoid running startup stuff. It would be nice for Access to have EnableEvents like Excel does

thank you