access toolbar

[thomas_kemp]

I have a database that opens with a form.

I would like users to open it with the generic "microsoft access" toolbar hidden.

How do I go about doing this?

Thanks in advance

 

[ghudson]

'The below code will disable (hide) all menu bars and tool bars.
'Ensure that you have a way to enable (unhide) the menu bars
'and tool bars (transparent command button) before you hide them!

'this will disable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

'this will enable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i

'An added bonus is the right click option is disabled if the menu bars are disabled with the above code.

'Use the 'ShowToolbar' command if you need to display a tool bar or menu bar...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarYes

'This will hide a tool bar or menu bar when needed...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarNo

'This will hide the Menu Bar...
DoCmd.ShowToolbar "Menu Bar", acToolbarNo

'You can also hide/unhide the database window with code...

'Hide the database window
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

'Unhide the database window
DoCmd.SelectObject acTable, , True

Check this link out for more tricks...
Hide all Access Toolbars and Menubars

'HTH

 

[JimJones]

GHudson,

Thanks too for that info., but instead of the "invisible button",
I would like to do it with a set of key strokes.

Is that even possible? If so, how would I even begin to assign any sort of "On 3 key stroke" event, for example ?

Thanks,
Jim