hiding navigation and top menu from access 2007 (1 Viewer)

[iworkonline]

Hi

I have ACCESS 2007 application in which I do not want to show the All Access Objects on the left and stuff on the top.

When somebody runs the app they should only see the start up form.

How can I only show the start form in my app, if the individual running the app have ACCESS2007 already installed.

Thanks.

 

[Dairy Farmer]

To hide the Navigation pane

DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

To set which form opens at startup goto the Access Options, Current Database, Display Form.
Convert the DB an ACCDE, but set the Navigation Options before converting.
You could also script which form is startup via VB (say on a Close Button.

CurrentDb().Properties("StartupForm") = "Form1"

There is also

DoCmd.LockNavigationPane -1

 

[Dairy Farmer]

Cut down ribbon.
Add the following to the table USysRibbons and set as Ribbon Name in Current Database options.
You will only have the Close Database option on the menu button.

<customUI xmlns="[URL]http://schemas.microsoft.com/office/2006/01/customui[/URL]">
<ribbon startFromScratch="true">
   <officeMenu>
        <button idMso="FileOpenDatabase" visible="false" />
         <button idMso="FileNewDatabase" visible="false" />
         <splitButton idMso="FileSaveAsMenuAccess" visible="false" />
     </officeMenu>
</ribbon>
</customUI>

 

[ghudson]

Hide or display the default ribbon...

DoCmd.ShowToolbar "Ribbon", acToolbarYes
DoCmd.ShowToolbar "Ribbon", acToolbarNo

 

[dijilator]

1. Where would I insert the DoCommand code to hide/display the ribbon and QAT?
2. How would I set a keyboard entry/combination to toggle between hide and display?