Access 2007 Ribbon & toolbars

[AG]

I have found quite a number of articles on customizing the ribbon, but
(unless I missed it) can't seem to find any reference to controlling the
height of the ribbon. It does take up a lot of screen space.
If I create a new ribbon with three buttons, they are placed vertically. Is
there any way to specify that they should be placed horizontally and to
shrink the height of the ribbon?

Once I have imported objects, including toolbars from a previous version, is
there any way to remove the legacy toolbars?

Thanks for any help,

 

[Charles Wang [MSFT]]

Hi AG,
Thank you for using Microsoft MSDN Managed Newsgroup.

For your 1st question of controlling the hight of the ribbon, based on my research, currently there is no way to control the height of the ribbon.

For your 2nd question, yes, you can put your three buttons into a box, and set the box attribute boxStyle to horizontal. Then you will find that the three buttons are horizontally arranged.

For your 3rd question, you can remove the legacy toolbars by using VBA code. For example:
Sub test()
Dim bar As CommandBar
Dim ctrl As CommandBarControl

For Each bar In Application.CommandBars
If bar.Name = "Standard" Then
For Each ctrl In bar.Controls
If ctrl.Caption = "xxxxxx" Then
ctrl.Delete
End If
Next ctrl
End If
Next bar
End Sub

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Charles Wang [MSFT]]

Hi AG,
Thank you for using Microsoft MSDN Managed Newsgroup.

For your 1st question of controlling the hight of the ribbon, based on my research, currently there is no way to control the height of the ribbon.

For your 2nd question, yes, you can put your three buttons into a box, and set the box attribute boxStyle to horizontal. Then you will find that the three buttons are horizontally arranged.

For your 3rd question, you can remove the legacy toolbars by using VBA code. For example:
Sub test()
Dim bar As CommandBar
Dim ctrl As CommandBarControl

For Each bar In Application.CommandBars
If bar.Name = "Standard" Then
For Each ctrl In bar.Controls
If ctrl.Caption = "xxxxxx" Then
ctrl.Delete
End If
Next ctrl
End If
Next bar
End Sub

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[bcap]

As far as I can tell the ribbon is the height it is. You can right-click it
and then minimize it.

 

[AG]

Thanks Charles,

The ribbon is a nice feature, but it does take up too much space.

Is there any problem with continuing to use the classic menus and toolbars?

Can you get more control of the ribbon added to the 'wish list'?

--

AG
Email: discussATadhdataDOTcom

Hi AG,
Thank you for using Microsoft MSDN Managed Newsgroup.

For your 1st question of controlling the hight of the ribbon, based on my
research, currently there is no way to control the height of the ribbon.

For your 2nd question, yes, you can put your three buttons into a box, and
set the box attribute boxStyle to horizontal. Then you will find that the
three buttons are horizontally arranged.

For your 3rd question, you can remove the legacy toolbars by using VBA
code. For example:
Sub test()
Dim bar As CommandBar
Dim ctrl As CommandBarControl

For Each bar In Application.CommandBars
If bar.Name = "Standard" Then
For Each ctrl In bar.Controls
If ctrl.Caption = "xxxxxx" Then
ctrl.Delete
End If
Next ctrl
End If
Next bar
End Sub

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
=========================================================

 

[Charles Wang [MSFT]]

Hi AG,
Access 2007 support legacy add-ins continuously working, so you can continue to use the classic
menus and toolbars. For your second question, may you elaborate it what you want to
implement? I think that you can get more control of ribben added to the 'wish list' by using VBA,
VB.NET/C# or changing the xml file. I recommend that you refer to the following articles for more
detailed information:
Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)
http://msdn.microsoft.com/en-us/library/aa338202.aspx
Extend The 2007 Office System With Your Own Ribbon Tabs And Controls
http://msdn.microsoft.com/en-us/magazine/cc163469.aspx

Hope this helps.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Charles Wang [MSFT]]

Hi AG,
Access 2007 support legacy add-ins continuously working, so you can continue to use the classic
menus and toolbars. For your second question, may you elaborate it what you want to
implement? I think that you can get more control of ribben added to the 'wish list' by using VBA,
VB.NET/C# or changing the xml file. I recommend that you refer to the following articles for more
detailed information:
Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)
http://msdn.microsoft.com/en-us/library/aa338202.aspx
Extend The 2007 Office System With Your Own Ribbon Tabs And Controls
http://msdn.microsoft.com/en-us/magazine/cc163469.aspx

Hope this helps.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[AG]

Charles,

My issue is the amount of space the ribbon takes up on the screen. As is, it
is fine for developers and power Access users.
When we develop an app for a 'user' who know snothing about Access and
couldn't care less about it, we make simple menus/toolbars/ribbons that only
make available to the user what they need. E.G. a report. When previewing a
report on the screen, a user wants to fill the screen with the report and
only needs commands for print, close, etc. If a ribbon is used for this, the
user loses too much vertical screen space.

Customizing/creating a ribbon should include some method of controlling it's
height. Yes, I know it can be minimized (though not via code), but then the
commands are not visible.

We have already estiblished that there is no way to reduce the height of the
ribbon, so all I am asking at this point is to submit that issue to the
development team.

 

[bcap]

It's a valid point, I hope they listen.

Charles,

My issue is the amount of space the ribbon takes up on the screen. As is,
it is fine for developers and power Access users.
When we develop an app for a 'user' who know snothing about Access and
couldn't care less about it, we make simple menus/toolbars/ribbons that
only make available to the user what they need. E.G. a report. When
previewing a report on the screen, a user wants to fill the screen with
the report and only needs commands for print, close, etc. If a ribbon is
used for this, the user loses too much vertical screen space.

Customizing/creating a ribbon should include some method of controlling
it's height. Yes, I know it can be minimized (though not via code), but
then the commands are not visible.

We have already estiblished that there is no way to reduce the height of
the ribbon, so all I am asking at this point is to submit that issue to
the development team.

--

AG
Email: discussATadhdataDOTcom

Hi AG,
Access 2007 support legacy add-ins continuously working, so you can
continue to use the classic
menus and toolbars. For your second question, may you elaborate it what
you want to
implement? I think that you can get more control of ribben added to the
'wish list' by using VBA,
VB.NET/C# or changing the xml file. I recommend that you refer to the
following articles for more
detailed information:
Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)
http://msdn.microsoft.com/en-us/library/aa338202.aspx
Extend The 2007 Office System With Your Own Ribbon Tabs And Controls
http://msdn.microsoft.com/en-us/magazine/cc163469.aspx

Hope this helps.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
=========================================================

 

[AG]

Charles,

Yes, that works for the commandbars.
The problem is that they with an Access 2007 database, the legacy toolbars
only appear on the Add-ins tab of the ribbon.
I thought I had a workaround, but it only works with running a prior version
(I used 2000) db with Access 2007.
With a prior version, there is an option for a menu and
allowbuiltintoolbars. When AllowFullMenus and AllowBuiltInToolbars are both
set to false and there is an entry for application menu bar, nothing is
displayed except for the menu. Not even the Office Button - very nice.
However, it does not work with an accdb. There are no options for
AllowBuiltInToolbars and MenuBar with an accdb, and setting them via code
has not effect as the MenuBar property is not retained when the db is closed
and reopened.

DoCmd.ShowToolbar "ribbon", acToolbarNo does hide the ribbon, office
button, etc., but then there is no menu of any kind at all.

--

AG
Email: discussATadhdataDOTcom

Hi AG,
Thank you for using Microsoft MSDN Managed Newsgroup.

For your 1st question of controlling the hight of the ribbon, based on my
research, currently there is no way to control the height of the ribbon.

For your 2nd question, yes, you can put your three buttons into a box, and
set the box attribute boxStyle to horizontal. Then you will find that the
three buttons are horizontally arranged.

For your 3rd question, you can remove the legacy toolbars by using VBA
code. For example:
Sub test()
Dim bar As CommandBar
Dim ctrl As CommandBarControl

For Each bar In Application.CommandBars
If bar.Name = "Standard" Then
For Each ctrl In bar.Controls
If ctrl.Caption = "xxxxxx" Then
ctrl.Delete
End If
Next ctrl
End If
Next bar
End Sub

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
=========================================================

 

[Charles Wang [MSFT]]

Hi AG,
I understand that your concern.

Since this is by design, could you please give Microsoft your feedback at http://office.microsoft.com/en-
ca/suggestions.aspx?sitename=CL100569831033&type=0? Your feedback will be routed to our product tean
and hope that this feature can be improved in future.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Charles Wang [MSFT]]

Hi AG,
Thank you for your response.

To facilitate our research process, could you please first send me (changliw_at_microsoft_dot_com)
your test database so that I can reproduce your issue quickly and perform effective research?

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[AG]

Done.

 

[Charles Wang [MSFT]]

Hi AG,
Thank you for your email response so that I quickly reproduce your issue.
I think that you have two concerns here:
1. The Home menu
2. The Add-in menu
Regarding the 1st one, to set it invisible, please add the following xml code segment to your Add-in
Ribbon xml file:
<tab idMso="TabHomeAccess" visible="false" />

Regarding the 2nd one, as I had replied you, currently there is no way to have your Add-in tab
behave like 2000 menu. You can still see the Add-in menu and the height is also that high.

If you have any other questions or concerns, please feel free to let me know. Have a nice day~!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your comments and suggestions about how
we can improve the support we provide to you. Please feel free to let my manager know what you
think of the level of service provided. You can send feedback directly to my manager at:
(e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================