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

Stuart McLachlan stuart at lexacorp.com.pg
Tue Jan 29 18:34:19 CST 2019


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
> 




More information about the AccessD mailing list