Recover Access menu after hiding

26 Oct 2006 10:03 PM

Li Qiu

Hi

I run the code below from answers by Todd L. Shillam (12/19/2004 9:21 PM
PST) to hide all command bars (menu & toolbars) in my logon form.

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

It works fine but the Access menu will not show again, even when I just open
the Access application. Using the the statement below only unhide the menu
at the current session. But it does not solve the problem.

CommandBars("Menu Bar").Enabled = True

Please give me advise as how to configue the Access to unhide the menu
Thanks,
Li

27 Oct 2006 7:22 AM

Keith Wilby

Show quote Hide quote

"Li Qiu" <Li***@discussions.microsoft.com> wrote in message
news:D364BD3C-AED4-459D-847D-B08A85B4B226@microsoft.com...
> Hi
>
> I run the code below from answers by Todd L. Shillam (12/19/2004 9:21 PM
> PST) to hide all command bars (menu & toolbars) in my logon form.
>
> Dim i As Integer
> For i = 1 To CommandBars.Count
> CommandBars(i).Enabled = False
> Next i
>
> It works fine but the Access menu will not show again, even when I just
> open
> the Access application. Using the the statement below only unhide the
> menu
> at the current session. But it does not solve the problem.
>
> CommandBars("Menu Bar").Enabled = True
>
> Please give me advise as how to configue the Access to unhide the menu
> Thanks,
> Li

Try holding the shift key down when you open Access.

Keith.
www.keithwilby.com