You can use the AllowFullMenus property to specify whether or not full Microsoft Office Access 2007 built-in menus will be available when the application database opens. For example, you can use the AllowFullMenus property to disable menu items that give users the ability to modify table (table: A database object that stores data in records (rows) and fields (columns). The data is usually about a particular category of things, such as employees or orders.), form (form: An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.), query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.), or report (report: An Access database object that you can print, which contains information that is formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels.) structures.
The AllowFullMenus property uses the following settings.
||Display the full built-in menus at startup.
||Don't display full built-in menus at startup.
The easiest way to set this property is by using the Allow Full Menus option on the Startup tab of the Application Settings dialog box, available by clicking Access Options on the File menu. You can also set this property by using a macro (macro: An action or set of actions that you can use to automate tasks.) or Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) code.
To set the AllowFullMenus property by using a macro or Visual Basic for Applications (VBA) code, you must first either set the property in the Startup dialog box once or create the property in the following ways:
If you set this property to False, a predefined subset of the full built-in menus is displayed in your database. This set of menus doesn't include menus and commands that enable users to change the design of database objects.
Setting this property to False also disables the toolbar buttons that correspond to the disabled menu items. However, shortcut menus (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.) aren't affected (you can still change some design features by using shortcut menu commands). If you don't want users to have access to the commands on the shortcut menus, you can set the AllowShortcutMenus property to False.
This property's setting doesn't take effect until the next time the database opens.