[AccessD] Possible to set external ACCDB navigation properties through code

Bill Benson bensonforums at gmail.com
Tue Jan 29 14:09:38 CST 2019


It does not appear that this setting can be done through Properties, and
this code snippet does not appear to discover such a property.


Sub DisplayProperties()
Dim db As DAO.Database
Dim Props As DAO.Properties
Dim iProps As Long
Dim iProp As Long
Set db = CurrentDb
Set Props = db.Properties
iProps = Props.Count
For iProp = 0 To iProps - 1
    Debug.Print db.Properties(iProp).Name
Next
End Sub

Results:
Name
Connect
Transactions
Updatable
CollatingOrder
QueryTimeout
Version
RecordsAffected
ReplicaID
DesignMasterID
Connection
AccessVersion
NavPane Category
HasOfflineLists
StartUpShowDBWindow
StartUpShowStatusBar
AllowShortcutMenus
AllowFullMenus
AllowBuiltInToolbars
AllowToolbarChanges
AllowSpecialKeys
UseAppIconForFrmRpt
UseMDIMode
ShowDocumentTabs
AllowDatasheetSchema
Show Values in Indexed
Show Values in Non-Indexed
Show Values in Remote
Auto Compact
Row Limit
ANSI Query Mode
Picture Property Storage Format
NavPane Closed
NavPane Width
NavPane View By
NavPane Sort By
Build
ProjVer
AppTitle
StartUpForm
Show Values Limit
DesignWithData
Show Navigation Pane Search Bar
Theme Resource Name
WebDesignMode


>


More information about the AccessD mailing list