Customized Menu Bar

[MarionD]

Hi there,

Can anyone tell me if (and how!) I can set entries in a customized menu bar to "enabled" true or false. Users login to the DB with a password, and I would like certain menu items dissabled for certain users.

I've been trying along these lines but no joy yet!

Set menubar = CommandBars.ActiveMenuBar
With menubar
.Controls.Item("exportdatei erstellen").enabled = False
End With

Would certainly appreciate any help!

 

[pedromac73]

Marion

Check out the following link courtesy of user ghudson

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

This may be what your looking for

Regards

Peter

 

[MarionD]

Hi again,

I'm getting there..

the line I need is

Application.CommandBars("Formmenu").Controls(1).Enabled = False

Now I need to take this one step further... This disables the main menu point, but how do I refer to the "sub menu options"
e.g. I dan't want to disable the main option "File", but I want to disable "New" under File > New

Thanks again

 

[pedromac73]

Hi

Try this from microsoft,

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

remember to check the correct reference version i.e. OFFICE9 or OFFICE10 or OFFICE11. This can usually be found in the Microsft Folder within Program Files

Regards

Peter

 

[MarionD]

Thanks for the reply Peter. I've got it working now!