Access 2010 FAQ
Where are all the extra macro actions for client databases in Access 2010? When I look in the Action Catalog or drop down the list of macro actions in the Add New Action combo box, I do not see all the options present in previous versions.
Access 2010 by default only shows macro actions that are trusted in client database. Trusted client macro actions will run even if the content in the database has not been trusted and/or the database is not in a trusted location. When you first open the Logic Designer, Access displays only 66 macro actions in the Action Catalog. Access also only shows that same number when you drop down the list of macro actions in the Add New Action combo box.
To see the complete list of 86 client macro actions, click the Show All Actions button in the Show/Hide group on the Design tab, as shown in the screenshot below.
Access displays a lightning bolt next to trusted actions in the Action Catalog and an exclamation point next to non trusted actions, as seen here.
When you select an action that can run only in a trusted database, Access displays an exclamation point next to the selected action on the macro design surface, as shown in the screenshot below. If a macro in your application includes actions that can run only in a trusted database, your user must trust your database to be able to run the macro.
See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out
Back to FAQ main page