XP Toolbars and MenuBars in Access 2010 .accde instead of ribbon?

AnthonyGerrard

Registered User.
Local time
Today, 19:54
Joined
Jun 11, 2004
Messages
1,069
I have an old XP db which I am going to move to Access 2010 accdb or accde.

In XP , it was completely locked down and used only custom menu bars and toolbars.

Now I know they appear in the addin tab in 2010, and I can trun the ribbon off so I just have the Home and Add IN Tabs for teh ribbon.

But I want to really go back to how it was in XP - can this be done? Just custom menu and toolbars showing , no ribbon?

Thanks
 
i don't think so - you get an irritatingly tall menubar, the same size as the ribbon
 
Hi,

I know you can do this with Access 2007 and I detail how to do that on this page of my site:
http://www.accessjunkie.com/Pages/faq_31.aspx

I haven't, however, tried the same technique with Access 2010 but I think it might work. The only thing I'm not sure about would be the Backstage view. Try out my steps above and see if it works in 2010.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 
Hi

The technique of keeping the menu, out of the add-in only works for MDB extension. If you decide to use the extension ACCDB, the menu will be trapped in the Add-in tab. It is ugly!

Why get stuck in the past? Face the change, that is here to stay! There are good sites teaching the assembly of ribbons!
 
Hi,

I know you can do this with Access 2007 and I detail how to do that on this page of my site:
http://www.accessjunkie.com/Pages/faq_31.aspx

I haven't, however, tried the same technique with Access 2010 but I think it might work. The only thing I'm not sure about would be the Backstage view. Try out my steps above and see if it works in 2010.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

cheers as Ari say - I think this is only for mdb.
 
Hi

The technique of keeping the menu, out of the add-in only works for MDB extension. If you decide to use the extension ACCDB, the menu will be trapped in the Add-in tab. It is ugly!

Why get stuck in the past? Face the change, that is here to stay! There are good sites teaching the assembly of ribbons!


Thanks for the answers everyone - I guess I'll either have to live with it as addin at the moment and/or learn ribbons

Maybe you can answer a few questions - I know nothing about ribbons as yet.

0.5) Can code auto select the add in tab - so at least my users are presented with the menu bar rather than having to tab to it. (i know its not a great deal to ask of a user - but frankly it will cause absolute bedlam and revolt)?

1)Can I set a new ribbon per form / report - which then appears the same way as teh old toobar did? I presume looking at the property sheets of objects that you can.

2) What happens to short cut menu/toolbars (ie the right click on forms, controls etc ) - are these the same as they were - but now with no interface to change them?

3)I have some pretty big toolbars - ie reports are run off toolbars - so there could be 100s of buttons on the biggest and maybe 10 custom ones total - can they be auto upgraded to ribbons.

4) Can coding be done to change, add buttons, disable buttons, edit ribbon buttons on the fly through code?



Finally - whats the point of ribbons for either a developer, or the end user. Seems I now have a lot of work - just to get back to where I already was?

Cheers
 
Hi Anthony

Enjoy the weekend and check out this site that will answer all your questions.

http://www.accessribbon.de/en


"Finally - whats the point of ribbons for either a developer, or the end user. Seems I now have a lot of work - just to get back to where I was Already?"

See also this site, having a application made ​​in Access, to assembly of ribbons. It has excellent video-lessons! I chose this application, because was created in the proper Access and allowed me to learn the XML. Today I am able to mount ribbons, without relying on any tool..

http://www.ribbons-access.com

Good study!
 
Last edited:
Hi Anthony

Enjoy the weekend and check out this site that will answer all your questions.

http://www.accessribbon.de/en


"Finally - whats the point of ribbons for either a developer, or the end user. Seems I now have a lot of work - just to get back to where I was Already?"

See also this site, having a application made ​​in Access, to assembly of ribbons. It has excellent video-lessons! I chose this application, because was created in the proper Access and allowed me to learn the XML. Today I am able to mount ribbons, without relying on any tool..

http://www.ribbon01.com/

Good study!

Cheers link 1 has both a builder and a converter tool (from toolbars) link 2 is just the builder? YOu chose the builder in 2. The converter in link one is tempting though for me to start of the process - you use this at all?
 

Users who are viewing this thread

Back
Top Bottom