[AccessD] AC2007 and the ribbon - the adventure continues.....

Mark Simms marksimms at verizon.net
Sat Nov 27 11:31:16 CST 2010


Well, it's been a lot of time invested to understand how the ribbon operates
and how to control it.
In Summary:
1) There is no way to convert older Commandbars built in VBA, however, those
created thru the GUI can be converted.
I don't think the conversion can be done programmatically....i.e.
command-line or vba proc.
2) Older commandbars will show-up ONLY in the Add-ins tab of the default
Ribbon. If you attempt a custom ribbon,
NONE of the commandbar items are available...i.e. your users can do nothing.
The commandbars cannot be placed anywhere else.
3) Although Form and Print ribbons have been reverse engineered and can be
defined to contextually appear,
no one has reverse engineered the entire default ribbon. i.e. there is no
XML for the default ribbon.
If there were, then older commandbars could be placed in a user-controlled
tab.
4) There is a tool to assist in enabling/disabling buttons on a ribbon via
VBA, however, no one has created a tool that will allow a ribbon menu to be
built-up in VBA similar to building commandbar pop-ups, etc.
5) The ribbon operates nicely when minimized and takes up the least amount
of screen real estate.
6) There are a few third party tools to assist in building ribbon menus from
scratch. 
However, none of them generate VBA....you become totally dependent upon them
or must apply your knowledge of XML and the specifics for the Microsoft
schema that was implemented (i.e. "good luck").
7) There is a substantial body of knowledge at this forum:
<http://social.msdn.microsoft.com/Forums/en-US/accessdev/threads>
http://social.msdn.microsoft.com/Forums/en-US/accessdev/threads
I was impressed !



More information about the AccessD mailing list