MS Access Menu - Unhide Not Working?

[smedvid]

Anyone else ever hit this problem? Thanks in Advance!

I am using below code to hide/unhide toolbars. It works great, except, when "one" user (of 3) opens MS Access after exiting the application, the File Menu does not appear in MS Access unless openning in Safe Mode.

I suspect corrupt DLL or other MS Access System related issue?

I will ask IT to re-install MS Access 2003 (or Office 2003). If that does not solve issue; I am stuck!

I posed same question in 2005, with no responses; and never solved the issue. Needed to open MS Access in Safe Mode.

Function HideAllMenuItems()
'This will hide all menu bars and tool bars
    Dim i As Integer
    For i = 1 To CommandBars.Count
        CommandBars(i).Enabled = False
    Next i
End Function

Function UnHideAllMenuItems()
'This will unhide all menu bars and tool bars
    Dim i As Integer
    For i = 1 To CommandBars.Count
        CommandBars(i).Enabled = True
    Next i
End Function

Steve Medvid
IT Consultant & Web Master

 

[lameid]

http://office.microsoft.com/en-us/frontpage-help/about-office-safe-mode-HP003082393.aspx

Looks like toolbar customizations are not loaded in safemode.

Out of curiosity what is Commandbars.count on the problem client if not using safemode?

Also, if I am not mistaken all commandbar customizations are largely stored in the database... what if you create a new database on a different system (or same for that matter) and open it not in safe mode?

 

[smedvid]

Sorry I forgot to post a follow-up. Appears that repair of MS Access 2003 fixed issue initially... but problem has since re-surfaced! A complete re-install of MS Office 2003 is planned... since only (1) user or (3) has issue... Good chance it is a MS Access DLL or orher issue I suspect. Did not have time to do WinDiff to compare directories and file sizes.

Steve Medvid
IT Consultant & Web Master