MS Access How to open Switchboard / Main Menu at Add-in

[irsmalik]

Hello Friends

I want to create and use my switchboard / Main Menu at Ribbon / Menu bar.

I have created Switchboard Items and Switchboard Form. Now I want to make it as Default menu.

All the other Access Default Menus should NOT display. Only my Switchboard / Main Menu should be display at Ribbon / Menu Bar.

I have seen at many templates which are used at Add-ins. I don't know how to do it.

Please if any one can help me how to do it step by step.
Thanks

[zmbd]

Which version of Office/Access?

To hide the ribbon >> BE CAREFUL HERE <<
MS>How to: Hide the Ribbon When Access Starts
In the XML that creates your primary ribbon add:

<customUI xmlns="http://schemas.microsoft.com/office/20xx/xx/customui">
   <commands>...</commands>
[B][iCODE]<ribbon startFromScratch="true">[/iCODE][/B]
   <tabs> .... </tabs>
</ribbon>
[B][iCODE]<customUI>[/iCODE][/B]

ONCE AGAIN>>> USE CAUTION HERE
Once you wipe the built-in menus you'll need to make sure you have a way to get back.

Open your database
Ribbon>File>Opt ions>Current Database
Navigation group
Uncheck "Display Navigation Pane"

You can do this via Maco and/or vba which I often do in the on_load event of the main form. However, this tends to be the easiest.

While you're at it,
Ribbon>File>Opt ions>Current Database
Application Title: [enter an original name]
Display Form: [Enter the name of the form to load on start]

Now you can always use the AutoExec macro to load the form too... this is what I tend to do, In the aforementioned there is a simple splash-screen form that loads, the autoexec checks for trusted stat and if found loads the primary login form, that form handles closing the splash-screen and loading the main switch board.

Of course, keep in mind, that someone like myself can bypass all of this without so much as a blink of an eye. :)