macro auto comment on share facebook script

For more information, see the article Bypass startup options when you open a database.Īnother way to perform actions when a database starts is to specify a startup form, and then attach macros or VBA code to the OnOpen or OnLoad events of the form. To bypass the AutoExec macro and other startup options, hold down the SHIFT key while you start the database. The new macro will run the next time that you open the database.įor more information about how to create macros, see the article Create a user interface (UI) macro. Repeat step 2 for each additional action you want to occur.Ĭlick Save, and in the Save As dialog box, type AutoExec.Ĭlick OK and then close the Macro Builder. For more information, see the article Decide whether to trust a database. This expands the list of actions that you can use, but the list will include some actions that will only run if the database is granted trusted status. If you cannot find the action you want, on the Design tab, in the Show/Hide group, make sure Show All Actions is selected.

If applicable, type the appropriate values in the argument boxes.

In the drop-down list at the top of the Macro Builder, select the action that you want to perform. On the Create tab, in the Other group, click Macro. Otherwise, follow these steps to create a macro: If you have already created a macro that contains the actions that you want to occur when the database starts, just rename the macro to AutoExec, and it will run the next time that you open the database. When a database starts, Access runs the AutoExec macro before it runs any other macros or VBA code. For example, you might want to automatically maximize the application window, lock the Navigation Pane, and then open a particular report.Īn AutoExec macro is just a macro that is named AutoExec. If you want to perform a particular set of actions every time that an Access database starts, you can create an AutoExec macro.

Macro auto comment on share facebook script