After lunching program, automatically hide all menus and access staff by code

[asgare]

I wrote an application in access 2007 for office branches in different cities.

Wondering how could it possible to make my program in way that after lunching automatically hide all menus and access staff and all is done by code or something like that.

Because almost all users are not familiar with access and I want just open the program just by one click.

I’m looking your great and helpful comments.

Thanks

 

[Pat Hartman]

You need to make custom menus if you want to hide the Access menus. I haven't tried making a custom ribbon which is what you need to do for A2007. However, if you have A2003 available, make the custom menu there and then you can import it. Use the Office button to get to the access options and you can set the options there to open a specific form, hide the built-in menus and use your custom menu.

 

[ezfriend]

Access 2003 - Not sure about Access 2007

Here is a quick code to reset all Access menu items. To hide it is just the opposite.

Private Sub cmdReset_Click()
    
    'show all the tool bar menu
    DoCmd.ShowToolbar "Menu Bar", acToolbarYes
    DoCmd.SelectObject acTable, , True

    For i = 1 To CommandBars.Count
        CommandBars(i).Enabled = True
    Next i
    
End Sub