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

[Bill Benson]

Well since John knows exactly what I am after (and I assume it is very
small bit of code) it would be kind of nice if he would just ... well...
post it.

Or not. I am not saying that he should. Just that he could.  ;)

On Wed, Jan 30, 2019 at 9:24 PM Jim Lawrence <accessd at shaw.ca> wrote:

> You can access the databaseadvisors web site via:
> dba.creativesystemdesigns.com (I cobbled it together remotely and have
> not had a lot of time to test anything so it may crash for not particular
> reason.)
>
> Do not use this site often as it is running on a server with very little
> capacity and running tons of remote access stuff and the certification has
> expired. I am some distance away, on a very slow connection and my good
> friend and backup person is currently in Mexico, so if things crash it is
> not easy to fix. (I believe it is secure but I am not sure...)
>
> Try it if you need some files or access. Note: Many of the old links are
> no longer working and everything else is dreadfully out dated.
>
> HTH
> Jim
>
> If there are any web boys or girls out there, who would have the time and
> the wiliness to learn, taking over this site would be a wonderful
> challenge. It definitely needs a huge renovation.
>
> ----- Original Message -----
> From: "stuart" <stuart at lexacorp.com.pg>
> To: "Access Developers discussion and problem solving" <
> accessd at databaseadvisors.com>
> Sent: Tuesday, January 29, 2019 4:34:19 PM
> Subject: Re: [AccessD] Possible to set external ACCDB navigation
> properties through code
>
> Doesn't seem to be anything left of the databaseadvisors website apart
> from the list manager
> interface :(
>
>
>
> On 29 Jan 2019 at 19:00, John Colby wrote:
>
> > 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
> > >
> > --
> > 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
>