Ms access 2010

[BoredBloke]

We have been upgrading to 2007, rather than 2010. The menu system is different. In older versions you could build a menu by hand and then manipulate it via VBA. For some reason that's all been changed. Although they will work, adding extra functionality is a bit of a pain in tha arse as you can no longer easily add/remove/modify items or check the code they run. We have a database that I inherited and the developer built amenu system from hell. Rather than rebuild it completely (because I don't fully understand the database) I added extra items in the immediate window. Anything I build from the ground up I use a table to hold all the menu items and VBA to process it, so adding items to groups is pretty easy.

MS say that you can use XML to generate menus, but I looked into it but it's a complete nightmare to work with!

[lilelvis2000]

We have been upgrading to 2007, rather than 2010. The menu system is different. In older versions you could build a menu by hand and then manipulate it via VBA. For some reason that's all been changed. Although they will work, adding extra functionality is a bit of a pain in tha arse as you can no longer easily add/remove/modify items or check the code they run. We have a database that I inherited and the developer built amenu system from hell. Rather than rebuild it completely (because I don't fully understand the database) I added extra items in the immediate window. Anything I build from the ground up I use a table to hold all the menu items and VBA to process it, so adding items to groups is pretty easy.

MS say that you can use XML to generate menus, but I looked into it but it's a complete nightmare to work with!

Yeah you end up using a third-party tool - like this one to do it for you. I haven't tried it myself, but will give it a go on my next project.