Hiding menu's in Microsoft Access

[p4nny]

Hi

I have an Access form with controls..

I would now like to hide all Access menu's on opening of the database.


Hide the following: ribbon, All access objects, bar at the bottom (next record, previous, new record)

Many thanks

 

[Trevor G]

What you can do is use the Form On Open Event and use the following code. You would also need to change some of the form properties to hide the Record Selector and Navigation Button. Then I would use a MACRO to maximize the Form window as an Executable Macro. named autoexec.

Private Sub Form_Load()
DoCmd.SelectObject acForm, "frmstaff", True
' .. and hide it
RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

' Make sure I have the focus
Me.SetFocus

End Sub

 

[p4nny]

thanks for this..