limiting navigation to forms 6

[jommyjet]

Is there a way to limit navigation to forms?. If a user wants to open a report, do it through a form, else they shouldn't be there. thanks

 

[randysmid]

Hi,
You can "hide" all the reports, one at a time. You can do this by right-clicking on the report name, and selecting Properties. You will then see a check box labelled "Hidden".
To "unhide", you will need to "unhide" all the objects in the database at one time. To do this, simply click on Tools, then Options. Under the View tab, you will see "Show", with a check box for Hidden objects.

HTH,
Randy Smith
California Teachers Association

 

[GEHongfei]

Another option would be to goto 'Tools -> Startup'. From there you can uncheck the box 'Display Database Window'. This will remove the navigation window when the user opens the database, preventing them from opening reports in design view. If you uncheck all of the options, you can 'user-proof' your database pretty well. However, if you need to edit the database, just hold down shift while opening it to regain all the controls.

Hongfei
GE Silicones

 

[jommyjet]

thanks guys

 

[randysmid]

Hongfei,
That was a great tip. It is much appreciated, and deserves a star!!!!!

HTH,
Randy Smith
California Teachers Association

 

[jommyjet]

the start-up option works great. I'd like to allow access to most menus and toolbars, but not design. can you disable design mode as the default start-up option?

 

[humbleprogrammer]

Create your own custom menu and replace the default menu with it. Follow below steps:

1. Go to Tools - Customize - Choose the Toolbars tab.
2. Select New and type a name for your menu.
3. Your new menu should now show up on the toolbars list and a little pop up of it should show on your screen.
4. Go to the Commands tab and drag any of the menu commands you want over to your menu pop up.
5. When finished placing all your menu items, drag your menu to the top toolbar.
6. Go back to the Toolbars tab and highlight your menu name.
7. Click properties and change the Type: to "menu bar", uncheck "allow moving", uncheck "allow customizing", uncheck "allow showing/hiding" and close window.
8. Make sure your menu name is checked in the Toolbars tab and close window.
9. Go to Tools - Startup - and set menu bar to your menu.
10. Uncheck "allow full menus", "allow default shortcut menus", "allow toolbar menu changes"

This will give you a custom menu rather then the default Access menu.

Hope it helps.

 

[jommyjet]

thank you