Access 2007 Home Ribbon URGENTLY need to remove

[Guest]

I know I can remove teh other ribbons using teh Access Opions|Current
Database options. I need to remove the Home ribbon and therefore have no
ribbons ahowing in my application. But I want to remove the whole ribbon for
two reasons

1. The space it takes up.
2. To remove the options from the user.

I can do it by using send keys ctrl F1 but this isn't perfect as if the user
clicked these accidentally the ribbon would reappear.

I have looked at all the microsoft stuff on ribbons and I feel like crying.
Wonderful if you want to really get into it and create a fancy interface. But
can someone just tell me hgow to remove teh ribbon.

Is there a vba command like ribbonhome.visible=false?

Please help - I just can't afford the time to learn all the XML ribbon stuff
at the moment.

Lou

 

[Guest]

Hi Lou,

I know I can remove teh other ribbons using teh Access Opions|Current
Database options. I need to remove the Home ribbon and therefore have no
ribbons ahowing in my application. But I want to remove the whole ribbon for
two reasons

1. The space it takes up.
2. To remove the options from the user.

I can do it by using send keys ctrl F1 but this isn't perfect as if the user
clicked these accidentally the ribbon would reappear.

I have looked at all the microsoft stuff on ribbons and I feel like crying.
Wonderful if you want to really get into it and create a fancy interface. But
can someone just tell me hgow to remove teh ribbon.

Is there a vba command like ribbonhome.visible=false?

Please help - I just can't afford the time to learn all the XML ribbon stuff
at the moment.

if you don't need any ribbon at all you can use the following ribbon
definition:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>

If you don't know how to applicate this, just look at "all the microsoft
stuff on ribbons". ;-)

Bye
André

 

[Guest]

I gritted my teeth and dived into the Microsoft stuff at
http://msdn2.microsoft.com/en-us/library/aa338202.aspx

I found and followed the section "To create an Access application-level
custom ribbon" - substituting your xml.

And it worked thank you !!!!! May be these ribbons aren't so bad....