In a Microsoft Access project (.adp), you can add the property to the AccessObjectProperties collection of the CurrentProject object by using the Add method. accdb), you can add the property by using the CreateProperty method and then appending it to the Properties collection of the Database object. To set the AllowBypassKey property by using a macro, you must create the property in the following way: You can set this property by using a macro or VBA code.
![how to make an autoexec ignore a line how to make an autoexec ignore a line](https://accessdevtools.com/wp-content/uploads/shop/find-replace-search-options.png)
The AllowBypassKey property uses the following settings.Įnable the SHIFT key to allow the user to bypass the startup properties and the AutoExec macro.ĭisable the SHIFT key to prevent the user from bypassing the startup properties and the AutoExec macro. Disable the Bypass (SHIFT) key by using Visual Basic for Applications (VBA) code to set the AllowBypassKey property to False. When your database has multiple users, you can prevent users from bypassing startup options. When you bypass the startup options, the AutoExec macro does not run. If you add an Access macro named AutoExec to a database, the macro usually runs every time that you open the database.
How to make an autoexec ignore a line how to#
The designated custom Ribbon is not displayed.Īll default Ribbon tabs are displayed regardless of the setting.Īll default shortcut menus are displayed regardless of the setting.įor more information on how to set options for the Current Database, see the article Set user options for a current database from a centralized location.
![how to make an autoexec ignore a line how to make an autoexec ignore a line](https://support.content.office.net/en-us/media/e7a039a9-fd9e-38a9-39e9-adefbd4661fc.jpg)
When available, the designated Web form is not displayed, and none of the form's event procedures are run.Įven if this option is not selected, the Navigation Pane is displayed. Is available only when a designated Web form is present. The designated form is not displayed, and none of the form's event procedures are run. The custom application icon is not displayed.
![how to make an autoexec ignore a line how to make an autoexec ignore a line](https://www.prosettings.com/site/wp-content/uploads/2020/03/csgo-enable-developer-console.jpg)
The custom application title is not displayed. The following table lists each setting on the Current Database page and how they behave when you open the database while holding down the SHIFT key.īehavior when startup options are bypassed Note: You may need to close and reopen the database for the changes to be effective.