Re: Making munu-items not accessible.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Stefan wrote:
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

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Locking subforms
    ... I lock the prior months depending on the current date. ... If I set the allowedits to true or false, will that unlock the fields I just ...
    (microsoft.public.access.setupconfig)
  • Field Lock
    ... I hope some one can help i have a combo box and depending what i select from ... it it should lock or unlock a field for editing how is that posible ...
    (microsoft.public.access.forms)
  • Re: Refresh Problem
    ... If I wait 3 seconds between mouse clicks on the lock / unlock button, ... workstation is looking at a current copy of the data. ... MESSAGEBOX statement after all of the database lookups have been done ...
    (microsoft.public.fox.programmer.exchange)
  • Re: A scoped lock/unlock implementation in C++.
    ... mutex_locker wrapping the same mutex, more than one thread won't share ... But beyond that it will still work with thread local mutex_locker instances, since no two threads can have a nonzero lock count anyway. ... When entering a locked region, if the last entry is negative, you know ... In case of unlocks even the unlock count is insignificant. ...
    (comp.programming.threads)
  • Re: [PATCH] Remove softlockup from invalidate_mapping_pages.
    ... These block devices are very likely to have just one ... Being locked for read is very unlikely because mdadm would have already ... memory reclaim could lock the page, ... core is free to unlock the page when the IO completes, ...
    (Linux-Kernel)