ExecuteFile MS Access Navigation Pane Issues

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
ueberyak
Junior Coder
Posts: 29
Joined: Tue Sep 03, 2013 9:45 pm

ExecuteFile MS Access Navigation Pane Issues

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?
Thanks,
Josh

Post Reply