Hi, Wayne.
[color=blue]
> I've been clicking around Access 2007 Beta 2 and can't see the custom
> menu bar designer. Is it in the beta?[/color]
Kinda. One can customize the Quick Access Toolbar by adding built-in
commands, but no custom commands.
Select the Office button in the top left corner of the screen, then select
the "Access Options" button on the bottom right of the pop-up window to open
the Access Options dialog window.
Select the "Customization" navigation menu item on the left, then select the
"Choose commands from" combo box and select from the menus or sections that
contain the functions you want. Select an item in the list, then select the
"Add > >" button to add it to the toolbar.
When you're done adding the buttons you'd like, select the "OK" button to
close the window. You also have the option of placing the Quick Access
Toolbar above or below the UI ribbon.
[color=blue]
> Will custom menu bars be the same height as they
> were in previous versions[/color]
The Quick Access Toolbar appears to me to be the same height, but one cannot
create custom menu bars (CommandBars) in Access 2007 database format.
[color=blue]
> or will they be the "ribbon" style that takes
> up a huge portion of the screen?[/color]
One can build custom UI ribbons for the Office 2007 applications by writing
code. XML code. Really.
[color=blue]
> If I convert
> this same database to the Access 2007 format the custom menu bars seem
> to be lost and don't display.[/color]
Access 2007 database format doesn't support CommandBars. CommandBars have
been replaced throughout the Office 2007 applications with the UI ribbon.
[color=blue]
> Given that the final version would hopefully be able to convert the
> custom menu bars of earlier versions[/color]
The final version isn't going to make this easier. If you want to "convert"
your custom CommandBars from the earlier versions, you'll either have to
manually add the buttons to the Quick Access Toolbar, or you'll have to
write the XML code for your own custom UI ribbons.
[color=blue]
> they won't fit the screen with the ribbon style menu
> bar taking up the space that it does.[/color]
Oh, that. See the tabs at the top of the UI ribbon? Home, Create, External
Data, Database Tools, et cetera? Double-click on any one of the tabs.
Squeeze. Double-click on one of the tabs again. Expand. Convenient, huh?
That makes up for Microsoft's claims that Access 2007 is designed to be
easier for Access developers, doesn't it? ;-)
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Wayne" <cqdigital@volcanomail.com> wrote in message
news:1149138839.586880.87750@u72g2000cwu.googlegro ups.com...[color=blue]
> I've been clicking around Access 2007 Beta 2 and can't see the custom
> menu bar designer. Is it in the beta? Maybe I'm blind. The question
> that comes to mind is: Will custom menu bars be the same height as they
> were in previous versions or will they be the "ribbon" style that takes
> up a huge portion of the screen?
>
> Also when I use Access 2007 to open an Access 2003 database that has
> custom menu bars they display as they did in Access 2003. If I convert
> this same database to the Access 2007 format the custom menu bars seem
> to be lost and don't display.
>
> Given that the final version would hopefully be able to convert the
> custom menu bars of earlier versions, if they are the ribbon style,
> this will spell trouble for any forms designed for full or near full
> screen display ie. they won't fit the screen with the ribbon style menu
> bar taking up the space that it does.
>[/color]
