Is it possible to create my own menu bar ?

[KulasCage]

My boss ask me if my Main Menu form could be replaced by Menu Bar ?

My Main Menu contains buttons such as : Data Entry, Reports. Exit.

My Boss want it to look like the typical Menu Bar at the top of the screen. I wonder if it's possible?

I really appreciate if anyone could help me with this.

Thanks in advance.

 

[Robert Dunstan]

Yes you can.

There is wealth of information in the Access help relating to customising / creating your own toolbars and menu bars. Also search this forum as there are a number of posts relating to this subject as well.

Rob

 

[KulasCage]

Robert,

I tried to read and understand the threads about customized menu, but i can't figure out how to apply in my mdb.

If you could lend me an example it would be great. I'm just newbie access user.


My Menu should look like this (pull down) menu:

Data Entry , Reports , Exit

a.) When i click Data Entry, it should pull down and displays the following: Case, Insurer, Insured, Types of Activity, Types of Reports.

b.) When i click Reports, It should pull down and displays the following: by Insured, by adjuster, by Insurer, by group...etc.

I hope i explain it clearly.

thanks.

 

[Oldsoftboss]

Try this (A2000)
1.. Right click on the menu bar at the top and select customize.

2.. Under toolbars select New
Enter a name

3.. Select 'Commands' and drag the menu items you want to make your new menubar. For a dropdown menu select 'new menu' at the bottom of the 'categories' section.

To open forms etc there are categories called 'all forms', 'all reports' etc. drag the form name you want and you will be able to open this form, report etc from the toolbar.

If you right click on the item in your new menu you will be able to change the names and pictures etc

4.. Go back to toolbars and highlight your custom toolbar and click properties.

5.. Under the Type select Menu Bar.

6.. Open your forms in design mode and in the form properties there is a property for menu bar. Select your custom menubar and when you open the form the menu bar will be displayed.

HTH
Dave

 

[Oldsoftboss]

Like this. Hope it helps
Dave

 

[KulasCage]

Yehey finally i made it, thanks a lot.

I just need to read more threads about hiding the default menu bar.

cheers.

 

[ghudson]

'The below code will disable (hide) all menu bars and tool bars.
'Ensure that you have a way to enable (unhide) the menu bars
'and tool bars (transparent command button) before you hide them!

'this will disable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

'this will enable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i

'An added bonus is the right click option is disabled if the menu bars are disabled with the above code.

'Use the 'ShowToolbar' command if you need to display a tool bar or menu bar...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarYes

'This will hide a tool bar or menu bar when needed...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarNo

'This will hide the Menu Bar...
DoCmd.ShowToolbar "Menu Bar", acToolbarNo

'You can also hide/unhide the database window with code...

'Hide the database window
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

'Unhide the database window
DoCmd.SelectObject acTable, , True

Check this link out for more tricks...
Hide all Access Toolbars and Menubars


'HTH

 

[jeremie_ingram]

Try this....

1.Right click on the toolbar and select Customize
2. Go to the TOOLBARS tab and click the NEW button.
3. Name the Toolbar and click OK
4. While the item is HIGHLIGHTED in the toolbars list, click on the PROPERTIES button.
5. Change the TYPE selection from TOOLBAR to MENUBAR
6. Now the new bar should appear on the screen "FLOATING" next to the window you made the selection in. IT WILL BE SMALL.
7. Left Click on the COMMANDS tab and scroll to the very bottom of the list to NEW MENU.
8. Left click on NEW MENU (in the right portion of the window) and drag it to the floating toolbar you just created.
9. Right Click on the NEW MENU item that appeared on you toolbar and go to properties.
10. Here you can name your menu, to assign a access key to a certain letter (underlined) just add an & before the desired letter.
EXAMPLE - &File = File AND Fi&le = File

11. Under the Commands tab, left click on a catagory (to the left) and see what commands are availible (on the right). Left click and drag these to your menu item on you tool bar and they will appear under it.

12. Create all neccessary Menus on your menu bar following those steps. When you have completed your toolbar, dock it and close the customize window.
13. Left click on TOOLS and then STARTUP. Under MENU BAR select the one you created and UNCHECK the ALLOW BUILT IN TOOLBARS option.
Close and save, then reopen. The only toolbar appearing should be yours.

 

[Peter D]

Here are two links that might help:

http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc97/html/msdn_command.asp

Regards,

 

[andrewf10]

But what happens if you want to disable all menus and toolbars on all forms and reports but still have a custom toolbar unhide itself when a report is activated and then hide again when the form is closed?!

In other words, I don't want this toolbar to be seen unless a report is active. Is this possible?