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