Making munu-items not accessible.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefan - 02 Jun 2006 08:26 GMT

Hello,

In my database i have an own-made menubar with a lot of menu items.
Depending on the user i wish to lock or unlock different items so that the
user can't use them.

At this moment i check the user AFTER he/she clicks on the menu.

(Something like in WORD, copy or paste isn't accessible if there is no text
selected)

--
Stefan

Reply to this Message

Marshall Barton - 02 Jun 2006 21:47 GMT

>In my database i have an own-made menubar with a lot of menu items.
>Depending on the user i wish to lock or unlock different items so that the
>user can't use them.

You need to traverse the CommandBar's Controls collection
(see Help).

Maybe something like:

CommandBars("yourbar").Controls("somecontrol").Enabled=False

Or, if you would prefer to make them invisible:

CommandBars("yourbar").Controls("somecontrol").Visible=False

Signature

Marsh
MVP [MS Access]

Reply to this Message