activate / deactivate menu bar

[le888]

Hi,

How can I customize a menu bar? Example, if you a viewer, the menu bar is deactivated and if you are the editor, the menu bar is activated but only the import and export functions. Is it possible?

Thanks,

Le

 

[scouser]

Custom Toolbar

Create a custom toolbar then on the OnLoad Event of your form add:

DoCmd.ShowToolbar "Toolbar Name", acToolbarYes --Shows toolbar--
DoCmd.ShowToolbar "Toolbar Name", acToolbarNo  --Hides toolbar--

Hope this is what you were after.
Phil.

 

[le888]

Create a custom toolbar then on the OnLoad Event of your form add:

DoCmd.ShowToolbar "Toolbar Name", acToolbarYes --Shows toolbar--
DoCmd.ShowToolbar "Toolbar Name", acToolbarNo  --Hides toolbar--

Hope this is what you were after.
Phil.

Thanks for your reply. Yet, but I doesn't hide the database window which you can uncheck (hide this window) by the setup in the main menu. This is fine but if I want to reactivated how can I do this ?

Thanks again,

Le

 

[freddienet]

Menu bar

Hiding menu bar requires code inserted into the form event when it is loaded.
I understand that, but just where do I do it.
I have the command from a previous post but I am still having problems as well.

Thanks,

Freddie

 

[ghudson]

I list the code to do all that @ Hide all Access Toolbars and Menubars

 

[le888]

I list the code to do all that @ Hide all Access Toolbars and Menubars

Hi,

I have use :

Hide the database window
DoCmd.RunCommand acCmdWindowHide

Unhide the database window
DoCmd.SelectObject acTable, , True

Instead of

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

I have takeout this line : DoCmd.SelectObject acTable, , True
and it works fine. So, what is this line for?

Thanks for your help

Le

 

[ghudson]

It just puts the focus onto the Table table of the database window.

 

[le888]

It just puts the focus onto the Table table of the database window.

Thanks. So, if I don't put it, it would not affect my database?

Le