re-enable db window

[arage]

removing all options from the startup menu will disallow my MDE file from opening anything behind the scenes, but I require code that will display the database window. I’ve searched & haven’t found anything on this yet.

 

[Talismanic]

arage, is this what you are looking for?


'To Show Database Window
Private Sub cmdShowDbWindow_Click()
DoCmd.SelectObject acTable, , True
End Sub

'To Hide Database Window
Private Sub cmdHideDbWindow_Click()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub

'To Show Access Default Menu
Private Sub cmdShowDefaultMenu_Click()
CommandBars.Item(32).Enabled = True
End Sub

'To Hide Access Default Menu
Private Sub cmdHideDefaultMenu_Click()
CommandBars.Item(32).Enabled = False
End Sub

I am not sure how it works with a MDE though.

 

[Rich]

Does F11 work?

 

[arage]

f11 does not work no

 

[Talismanic]

Well, is it?

 

[arage]

hehe, sorry Talismanic your code works beautifully, just got it done. thanks very much. however, i only used the re-enable code & nothing else b/c i disabled all the options under start up before compiling to MDE and none of them could be started in the MDE, which is what i wanted, your code though would only activate when i logged on & clicked a button that is not hidden for me.