Table of contents
TOC
Collapse the table of content
Expand the table of content

Set Startup Properties from Visual Basic

office 365 dev account|Last Updated: 4/3/2018
|
3 Contributors

Applies to: Access 2013 | Access 2016

In a Microsoft Access database, startup properties are properties of a Database object. A Database object is a DAO object supplied by the Microsoft Access database engine, but startup properties are defined by Microsoft Access, so they aren't automatically recognized by the Access database engine. If a startup property hasn't been set previously, you must create it and add it to the Properties collection of the Database object.

In a Microsoft Access project (.adp), startup properties are properties of a CurrentProject object and like the Database object in an Access database, startup properties aren't automatically recognized by the Access database engine. If a startup property hasn't been set previously, you must create it and add it to the AccessObjectProperties collection of the CurrentProject object. When you set startup properties from Visual Basic, you should include error-handling code to verify that the property exists in the Properties or AccessObjectProperties collection. For more information about setting properties defined by Microsoft Access, seeSet Properties of Data Access Objects in Visual Basicor Set Properties of ActiveX Data Objects in Visual Basic. The names of the startup properties differ from the text that appears in the Startup dialog box. The following table provides the name of each startup property as it's used in Visual Basic code.

Text in Startup dialog boxProperty name
Application TitleAppTitle
Application IconAppIcon
Display Form/PageStartupForm
Display Database WindowStartupShowDBWindow
Display Status BarStartupShowStatusBar
Menu BarStartupMenuBar
Shortcut Menu BarStartupShortcutMenuBar
Allow Full MenusAllowFullMenus
Allow Default Shortcut MenusAllowShortcutMenus
Allow Built-In ToolbarsAllowBuiltInToolbars
Allow Toolbar/Menu ChangesAllowToolbarChanges
Allow Viewing Code After ErrorAllowBreakIntoCode
Use Access Special KeysAllowSpecialKeys

ACCESS SUPPORT RESOURCES
Access for developers forum on MSDN
Access help on support.office.com
Access help on answers.microsoft.com
Search for specific Access error codes on Bing
Access forums on UtterAccess
Access wiki on UtterAcess
Access developer and VBA programming help center (FMS)
Access posts on StackOverflow

© 2018 Microsoft