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

[Darren - Active Billing]

Stuart,

I noticed this, at the end of last year.

I wanted to pull down something I wrote with You and Drew - related to ID Card editing

Goorrrrn!

Darren

--------------

On 30/1/19, 11:34 am, "AccessD on behalf of Stuart McLachlan" <accessd-bounces at databaseadvisors.com on behalf of stuart at lexacorp.com.pg> wrote:

    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