Disable Ribbon Button, How?

[Meltdown]

Hi,

I need to be able to disable buttons on the Access 2007 rippon, can anyone tell me how to do that please?

This is a secured database so depending on the group I want to enable/disable some buttons, thanks.

Regards
Melt

 

[Magster]

I don't have a lot of experience with the ribbons, but what I did was create my own ribbons and excluded the buttons I didn't want to show.

Some of the buttons are in groups so you may have to find the individual ones to add.

Hope this helps.

 

[Meltdown]

Thanks for the reply,

I know how to add my own custom ribbon, but I still need to be able to enable/disable some buttons for certain security groups through code.

Anyone else got any suggestions?

 

[Uncle Gizmo]

All MS access 2007 forms have a " ribbon name" property.

Create as many ribbons as you require for the different groups that will use them and name them suitably, then have the forms "ribbon name" set to the ribbon that matches the group security level of the person opening the form.

 

[Meltdown]

Thanks Uncle Gizmo, that's a workable solution.