Hi All

We have migrated our access application from access 2003 to access 2007.

Just wondering is there any way to modify application menus in access 2007.

Thanks

What do you mean by modify the application menus? Are you talking about the forms in the Access application, or are you talking about custom menus and ribbons? There are ways to do both.


mmcdonal

Look it up at: http://wrox.books24x7.com

Thanks for reply donald

This is what i found and i did try this work very well but there's few glitches.

There are 5 steps to customizing the ribbons:

    * Create the ribbon XML - the ribbon definitions are done through an XML file, and the first step is to build that file. This is pretty easily done with a simple text editor, but can be made even easier with Visual Studio tools.
    * Specify callbacks - next, you need to build small VBA routines that handle ribbon actions like clicking a button or selecting something from a dropdown.
    * Create table for XML file - next, you create an Access table to hold the XML you created in step 1.
    * Add the ribbon to that table - next you create a record in the table for each custom ribbon, containing the ribbon name and the XML definition of the ribbon.
    * Set the Custom Ribbon property - finally, you set the Custom Ribbon property for the database as a whole or for specific forms and reports to load the ribbon you defined in the table above.


for more information
http://blogs.msdn.com/access/archive...access-ui.aspx