Ribbon Bar Question

[Paul Cooke]

Is it possible to disable the 'File' tab on the ribbon through code?

At the moment I have a login form set up and depending on the access rights of who logs in the whole ribbon will either show or not show.

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Whilst going through some testing it has become apparant that I do need a ribbon to show whilst in report previews but I do not want the users to be able to get into the 'File' tab.

I am about to start designing a custom ribbon but going on the code above I am assumig it would not show anyway? And I think the 'File' tab will always show even on a custom ribbon?

Any advice greatfully recieved.

many thanks

 

[boblarson]

If you use START FROM SCRATCH you can create your own ribbon which has none of the system things. It might include the File tab but the only thing on it would be Close/Exit. But I don't know for sure that it would even show up on a Ribbon that is built using the start from scratch in the XML.

And you can build whatever Ribbons you want for each form or report and then set those for that form or report and then it will change depending on what you have open.

 

[Paul Cooke]

If you use START FROM SCRATCH you can create your own ribbon which has none of the system things. It might include the File tab but the only thing on it would be Close/Exit. But I don't know for sure that it would even show up on a Ribbon that is built using the start from scratch in the XML.

And you can build whatever Ribbons you want for each form or report and then set those for that form or report and then it will change depending on what you have open.

Thanks Bob.

I will look into that when I start doing the custom ribbon and keep my fingers crossed !!

Will post back with the results

thanks again