Custom Ribbons in Access 2007

[PeterJC]

Where can i find information for making a custom ribbon for an Access 2007
application?
I have an application written in Access 2000 with a custom menu and I want
to convert that menu to an Access 2007 custom ribbon.
Also, how would i suppress the Access 2007 ribbon and only show the
custom ribbon?
--

 

[Maurice]

Look at www.accessribbon.de

that's the place where you'll find the info

 

[PeterJC]

Thanks, Maurice, that link appears to have the info I need.
If I use a custom ribbon, can I also suppress the database window when
opening t the application? and how would I do that?

 

[Maurice]

You can supress the db window in the settings under the office button under
access options. It would be better to create an ACCDE project that way it
will become protected from all users..

 

[PeterJC]

Thank you Maurice. where do i find out how to create an ACCDE project? I am
indeed anxious to protect this from all users.
Further, after making a custom ribbon for normal application use with the
Access ribbon suppressed, how would I open the application including the
Access ribbon for purposes of further development?

 

[Maurice]

Peter,

You create an ACCDE file by going to the [Database Tools] tab. At the far
right you see the option Create ACCDE. Click this button and Access wil
create an ACCDE for you. For this to happen make sure any VBA code compiles
correctly.

For ribbon maintenance you should use your original ACCDB file because once
a file has been converted to an ACCDE file you can't revert it back. So any
maintenance and new versions should always be created from the original
ACCDB. So make a copy of that en do your designing in the original.

hth