Create Menu bar with macro

[Gunilla]

How do I create a customized menubar? I know that I "once upon a time" used macros to customize menubar to use with specified forms and reports. Does anyone have a clue on how to do it or where I can get the information?
Gunilla

 

[HiTechCoach]

way back in Access 2.0 it was done with macros.

if you are using Access 2000 to 2003 go to View >Toolbars > customize. You can also use VBA.

In 2007 you create a custom Ribbon.

 

[Gunilla]

Thank you, I knew it was a long time ago I used the menubar macro. But does this mean I cannot change the default toolbar. I mean I want the File show but the only options should be Close and Open, In the Edit menu only export, import and find should be enabled. The rest of the option in the standard toolbar I don't want to show or disable the options. Does this make sense?

 

[HiTechCoach]

To help you, it would really be very helpful to know what version of Access you are using.

Since you are saying menu bar, I will assume you are using Access 20000/2002/2003,

... But does this mean I cannot change the default tool bar. ... this make sense?

Yes you can change the the default tool bar but it does not make sense to do so.

Why? If you change the default tool bar, you are actually modifying it globally withing Access, NOT for your database!

What I would highly urge you to do is to create a NEW custom menu bar with the options you want. Set this new menu baar as the default menu bar for your database.

To get started, open your database when you want the new menu bar. on the Access menu go to View > Toolbars > customize... and click NEW

Before you start:

1) Be sure to backup your database before starting.

2) You might also want to create a system restore point in Windows just in case.

 

[Gunilla]

Hi again
I have created new menu bars. But I am not happy with the result. The problem is that it shows up like a menu bar with icons not with text. I think I just have to go with it. It looks so much more professional when you have the toolbar in text, I think. It's a pitty if they took that option away.
Thanks for your help and have a nice week-end

 

[HiTechCoach]

Hi again
I have created new menu bars. But I am not happy with the result. The problem is that it shows up like a menu bar with icons not with text. I think I just have to go with it. It looks so much more professional when you have the toolbar in text, I think. It's a pitty if they took that option away.
Thanks for your help and have a nice week-end

It sounds like you did NOT make your new tool bar into a menu bar.

... It's a pitty if they took that option away. ...

You in luck because they didn't! I make menu bars in almost every database I create.

Go to the properties of your new toolbar and change the Type to "Menu Bar".

 

[HiTechCoach]

This may help:

Adding Command Bars to Your Application

Hope this helps ...

 

[Gunilla]

Thank you guys, now I have something to work on, I would never have been able to find this information myself. I also thank you for showing me the difference between toolbar and menubar. It really isn't easy when you are not familiar with the terminology. Thank you.
Gunilla

 

[HiTechCoach]

You're welcome.

Glad we could assist.

Good luck with your project.

 

[John Big Booty]

A macro records your mouse clicks and keystrokes while you work and lets you play them back later. You can use a macro to record the sequence of commands you use to perform a certain task.

Sorry that is what an Excel macro does, an Access Marco is a beast of a very different colour. An Access macro is constructed using collection of generalized database functions using existing Microsoft Access capabilities.

 

[sevenzz]

is it same method if i want to create menu bar in access 2010?