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

[Jim Lawrence]

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