Removing Toolbars, & Navigation window from DB apllication?

[ITHELP85]

Hello I have a Access Data Project as an Front _end application and a SQL server backend. Does anyone know the way so that when a user opens this application only thing they see are the forms and not the toolbar at the top and the Navigation pane on the left of the screen. Is it VBA code or is it something to adjust in the properties?

 

[Tony]

Ithelp85

Try the following code by opening the property sheet of the Form and placing it in your VBA code via the "On Open Event":



Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

 

[ITHELP85]

thanks, do you know how I would disable right clicks

 

[ITHELP85]

Ithelp85

Try the following code by opening the property sheet of the Form and placing it in your VBA code via the "On Open Event":



Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

This got rid of everything except the Navigation Pane.. any ideas on how to get rid of that?