What are menu building options available for MS Access applications?

[waltret]

In 2003 version of MS Access there was a very simple and easy customizable menu building system. In the 2010 version such menu is shown in Add-Ins and are not modifiable. Navigation form which was introduced in the latest versions of Access is very cumbersome, especially, for multi-level menus. What other options are available?

[NeoPa]

I use forms. If you're referring to the built-in switchboard facility in older versions then calling it by another name is only likely to confuse anyone trying to help.

Please pay more attention to your own questions if you want people to spend their energies helping you.

[MikeTheBike]

Hi

If I interpret waltret's question correctly I believe he is referring to the 2003 command/tool bar creating facility and the simplicity of removing the normal Access user interface.

To simulate this in 2007 or later the only way I have found is to define you own Ribbons. Removing all the relevant Access interface is however much trickier. And then they change that part in 2010 and again in 2013. I do not know what possessed Microsoft to do any of this!

Designing/running/debugging Ribbons and their Callback procedure is a nightmare by comparison to toolbars.

I found this site essential for designing Ribbon

https://msdn.microsoft.com/en-us/library/aa338202(v=office.12).aspx

This is for 2007 but 90% applies to later versions
I think there are links to parts 2 and 3.

For 2010 and later you need to be looking 'Backstage', try this link

http://www.accessribbon.de/en/?Access_-_Ribbons:Ribbon_XML___Controls:Backstage_View

This is 2010, I cannot remember the difference(s) for 2013 but a search for backstage 2013 should do the trick?
I have yet to sample the delights of later versions.

I could of course be totally of beam hear, if so, sorry, but it may be useful to somebody!

If I am right, then the best of luck, it is a steep learning curve (at least it was for me).


MTB

[jforbes]

If you prefer the old Switchboard, you can build one yourself. Twinnyfo put a lot of work in documenting a switchboard with user permissions here: How To Create User Permissions and Customized Menus in MS Access

[waltret]

I meant customizable Menu Toolbar

[NeoPa]

I was under the impression they still were modifiable if I'm honest. If they truly aren't then that's a blow.

Nevertheless, my recommendation would still be to use forms for this type of work.