Disabling built-in Menubars and ToolBars And Creating our Own MenuBar

[a_20120]

Hi all,
How it is possible to Hide all Built-in Menus and ToolsBar of M.S Access, and Create our own Menubar with VBA.
I mean when the project open, no built-in menus and toolsbar appear like File--Edit--View--Insert ... and Formatting, Standard toolbars and all built-in menus, just appear our own menu, and when Click on it, Open a form and do an action...

 

[Uncle Gizmo]

Hide all Access Toolbars and Menubars

Hide all Access Toolbars and Menubars


http://www.access-programmers.co.uk/forums/showthread.php?t=97578

 

[Uncle Gizmo]

Please Note G Hudson's comment Right at the bottom of the thread, it is very important that you read this comment!

 

[a_20120]

How can I Make My Own Menu

Thanx

How it is possible to make our own menubar in Access with VBA, and when click on any of them open the form, or report, or table...

 

[a_20120]

Create Our Own MenuBar with VBA

How it is possible to make our own menubar in Access with VBA, and when click on any of them open the form, or report, or table...

 

[a_20120]

No One is here to help me!
How can I create my own Menu Bar in Access with VBA? that I click on it, it open the Form, or Report...

How Can I make like File, Edit,Format Menu Bar...

 

[Uncle Gizmo]

As you state in your signature, "Research is the key to Success"

You are absolutely right! A couple of minutes searching with Google led me to this:

http://support.microsoft.com/kb/209974

 

[unclejoe]

Hi,

Maybe you mean the default toolbars in Access?

Go to Tools - Customize - check the Toolbars like "Form Design".

No One is here to help me!
How can I create my own Menu Bar in Access with VBA? that I click on it, it open the Form, or Report...
How Can I make like File, Edit,Format Menu Bar...

 

[a_20120]

Not Work

As you state in your signature, "Research is the key to Success"

You are absolutely right! A couple of minutes searching with Google led me to this:

http://support.microsoft.com/kb/209974

I used that code so many times, but unhappily it does not work... there is an error when I execute it.

I want to make same as the Attached menubar picture of the first thread

 

[Uncle Gizmo]

You need to set the references

I used that code so many times, but unhappily it does not work... there is an error when I execute it.

Again the answer is before you!

I suspect you need to set the references,

as stated on that page >>>Set References to Use Command Bars<<<

depending on the version of access you are using you will need either:
Office 9.0
Office 10.0
Office 11.0 (I think you may need to check this)

In the following extract from that web page here:

1. While in the Visual Basic Editor, on the Tools menu, click References.
2. In the References dialog box, click to select Microsoft Office 9.0 Object Library.
3. Click OK.