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

Bill Benson bensonforums at gmail.com
Tue Jan 29 23:07:33 CST 2019


John, not sure how to search that website but I will give it a try
tomorrow. In the meantime if you post link here that will help. Always
delighted to learn something is within the realm of the possible.


Another thing I've been looking to do is create a bulletproof vba routine
to regroup objects in the navigation groups. Particularly would be helpful
when running make table queries and re-attaching linked tables from user
defined locations (retrieved with filedialog).

Messing with system tables makes me nervous to begin with - then every SQL
query I looked into to accomplish it, I would look in the MSYS tables and
not see valid (expected) entries in the tables people said those SQL
queries should update - so I gave up and figured that messing with such
tables was a really bad idea!

On Tue, Jan 29, 2019, 7:01 PM John Colby <jwcolby at gmail.com> 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
>


More information about the AccessD mailing list