callstate
asked on
How to add a ribbon in a form Ac07/Ac10
I am looking to add a custom 'toolbar' to my Access project. I'd like to emulate the 'ribbon' look that Office 2007/2010 uses and started looking into using the code to generate a custom ribbon in Access 2007.
However, everything I find talks about modifying the existing ribbon in the Access window (blue). I want to add a ribbon to the form (red). I have included a .jpg to illustrate what I mean.
Do I need to re-create the toolbar using standard Access controls and make it 'look' like the ribbon, or is there a way to use the ribbon tools to add this function to a form?
I searched Google and EE for an example, but everything I find works with the window ribbon.
Ribbon.jpg
However, everything I find talks about modifying the existing ribbon in the Access window (blue). I want to add a ribbon to the form (red). I have included a .jpg to illustrate what I mean.
Do I need to re-create the toolbar using standard Access controls and make it 'look' like the ribbon, or is there a way to use the ribbon tools to add this function to a form?
I searched Google and EE for an example, but everything I find works with the window ribbon.
Ribbon.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<<Outlook 2010 uses a 'ribbon-like' toolbar in the client windows, and I'd like to use something similar in mine. Just wondering if I needed to look at the ribbon tools, or recreate using Access controls.>>
Access forms are sub-classed windows and therefore the look/feel is controlled by Access. Their not a true child window as they are in other applications, such as Outlook.
So you can't add a ribbion yourself to an Access form other then simulate it.
<<I downloaded a cool example from http://www.accessribbon.de/en/ that customizes the window ribbon based on which form is displayed, and that's my 'Plan B' - but I really wanted a toolbar in the popup window instead like my .JPG illustrates.>>
That's what I would do. Between the Ribbon, Menubar, and shortcut menu properties, you can be very context specific when on a form, but it will all be in the main Access window and not the forms.
Jim.
Access forms are sub-classed windows and therefore the look/feel is controlled by Access. Their not a true child window as they are in other applications, such as Outlook.
So you can't add a ribbion yourself to an Access form other then simulate it.
<<I downloaded a cool example from http://www.accessribbon.de/en/ that customizes the window ribbon based on which form is displayed, and that's my 'Plan B' - but I really wanted a toolbar in the popup window instead like my .JPG illustrates.>>
That's what I would do. Between the Ribbon, Menubar, and shortcut menu properties, you can be very context specific when on a form, but it will all be in the main Access window and not the forms.
Jim.
ASKER
I never was able to resolve the issue I wanted ... left the question open to see if any further responses.
For those coming across this thread in archive, what I did find was there is no way to do this in AC10 without resorting to a 3rd party control or 'simulating' it using built-in controls.
For those coming across this thread in archive, what I did find was there is no way to do this in AC10 without resorting to a 3rd party control or 'simulating' it using built-in controls.
ASKER
Jim & Peter - THANKS for the help!
ASKER
Yes Peter, I did see that link .... Jim, I have been on that site as well. That's what prompted my question.
Outlook 2010 uses a 'ribbon-like' toolbar in the client windows, and I'd like to use something similar in mine. Just wondering if I needed to look at the ribbon tools, or recreate using Access controls.
I downloaded a cool example from http://www.accessribbon.de/en/ that customizes the window ribbon based on which form is displayed, and that's my 'Plan B' - but I really wanted a toolbar in the popup window instead like my .JPG illustrates.
I guess it kinda depends on how much trouble I want to go to to get it!