Custom command and Menu bars in Access 2007

[Guest]

Custom Menu & Command bar created in earlier versions of access will only
appear as part of the "add-in" button and not appear continously. As access
2007 is so new haven't been able to find information on how this works. Is
there a way to have them present always (as in previous custom databases) or
is this not possible.

Not sure I like the new version. I'm losing control of parts of current
databases for clients and would not recommend they upgrade. I can't prevent
them accessing areas they couldn't before. I wish some of the new reference
books would get here!

jsrogol

 

[Jeff Conrad]

I wish some of the new reference

books would get here!

We're working on that....


You'll need to make one tiny change to see your custom menu bars/toolbars *as* menu bars/toolbars

1. Click the Microsoft Office Button in the upper left corner.
2. Click the Access Options button in the bottom right corner
3. Click the Current Database category on the Access Options dialog box
4. In the Ribbon and Toolbar Options section select your menu bar name from the Menu Bar combo box
5. Click Ok to save and close the Access Options dialog box.
6. Close your database and then reopen. Viola!

You'll see no signs of the Ribbon.

Remember that you cannot make any modifications to the menu bars and toolbars through the old
standard UI in 2007; the capability simply does not exist. You'll need to make these changes in an
earlier version.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message:

 

[Guest]

I also have an Access application written in Access XP, which uses custom
menus and toolbars (popups invoked by right-clicking). I have converted the
application to Access 2007. The custom menu does not appear in the list you
mention, just the toolbars. The custom menu is the main menu of the
application. There is no alternative interface. The only way I can get it
to appear is to set it as the menu bar of the splash screen (it does show up
in that dropdown); however, it is in the ribbon under addins. I don't wan't
the ribbon to show at all.

I suppose I could use a custom ribbon; however, I do not see how to create
one.

 

[Guest]

Having done some more research, I find that there are 'ribbon designer' tools
in VSTO; however, they seems backward to me. When you are designing a
graphical UI, it seems that the tools should allow you to lay out your
ribbons the way you want them to look and write the xml behind, similar to
the way FrontPage works with html. With all the limitations in the object
model for commandbars, at least you had a graphical design interface to start
with.

I have no wish to write XML and paste the successive approximations into an
Access table, then open the application each time to see if the ribbon is the
way i wanted it. This would take forever. How about a 'split view' designer
so you can see what you are doing as you go? 'Designing' a ribbon by writing
XML is a step back into the dark ages, like authoring web sites with Notepad.

 

[Mark Stonebanks]

I totally agree with you. I have spent many years developing my applications.
There benefit to me is the time I save in producing complex reports.
I feel that the current version of Access is a huge backward step and I
can't believe that Microsoft can do no better.

 

[Luis Soares]

Hi all,
I have exactly the same problem and tryed the suggested way round.
In my case when I tryed to do step 4. "In the Ribbon and Toolbar Options
section select your menu bar name from the Menu Bar combo box", I dont have
any entry in the combo box althought the custom toolbar apears in the add-in
ribbon. Any idea why this happens?

Regards,
Luis soares