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

[John Colby]

If you look on the accessed web site you will find a widget I wrote to do
that from a ui. The code is in there.

On Tue, Jan 29, 2019, 4:14 PM Bill Benson <bensonforums at gmail.com wrote:

> Paul,
>
> Am I able to do that without instantiating another Access Application? I am
> trying to control everything through the DBEngine.
>
> On Tue, Jan 29, 2019 at 3:15 PM Paul Hartland via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> > 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
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>