ExecuteFile MS Access Navigation Pane Issues

ueberyak · Post by **ueberyak** » Tue Feb 27, 2018 5:55 pm

I have a Microsoft Access 2016 database set to hide the Navigation pane. I did this via Options > Current Database. When I open it manually and when I open it via MacroScheduler without calling a macro, the database opens as expected; The main form is displayed and the Navigation pane is hidden.

If I use

Code: Select all

ExecuteFile>DatabaseName.accdb, /x SpecificMacro

it runs the macro but the Navigation pane is visible.

I've tried some tricks within Access - specifically I used SetDisplayedCatagories and set every category to Show = No - but the first time I use the code above for the first time, the Navigation Pane is still visible. After that, SpecifiedMacro runs and the Navigation pane is hidden.

I haven't switched to RunProgram because my end users won't necessarily all be on the same version of Access.

Is there some way around this?