Access 2007 FAQ
What happened to all the extra Macro Actions in Access 2007? When I drop down the list of macro actions in the macro design window, I do not see all the options present in previous versions. Where are they?
Access 2007 by default only shows macro actions that are trusted. Trusted 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 macro design window and drop down the list of macro actions in the Action column, Access displays only 45 macro actions.
To see the complete list of 70 macro actions, click the Show All Actions button in the Show/Hide group on the Design tab, as shown in the screenshot below.
When you select an action that can run only in a trusted database, Access displays an exclamation point on the selection button to the left, 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 our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page