ExecuteFile MS Access Navigation Pane Issues

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
ueberyak
Junior Coder
Posts: 30
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
Sign up to our newsletter for free automation tips, tricks & discounts