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

[Paul Hartland]

Not sure about the system ones but for hidden objects you can try

Application.setoption "Show Hidden Objects", vbfalse

Paul

On Tue, 29 Jan 2019, 20:10 Bill Benson <bensonforums at gmail.com wrote:

> 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
>
>
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>