|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new Expression Web |
Is Your Database Corrupt ?
Right-Click Microsoft Access Menus
A shortcut (pop-up) menu appears whenever you right-click a form or a report in
preview mode. If you leave the built-in menus in place, the shortcut menu will
include the Design View command. Naturally, you probably won’t want this command
to be available in a protected database, so let’s find out how to build a custom
shortcut menu that replaces the built-in Form View shortcut menu:
1. Select the View menu, choose Toolbars and choose the Customize dialog, select
the Toolbars tab, and create a new menu.
2. Click the Properties button and select Popup from the Type drop-down list.
This action brings up a message box, shown in Figure 7-11, that tells you that
the menu is about to disappear and that you will have to find it
again. Weird, but true!
3. Click OK and then click Close.
|
|
Chapter 7 discusses, at great length menu management for Access 2000-2003. This will help you simplify, secure and improve the user interface for the users of your database. |
<<Click picture to enlarge
Figure 7-11. The message invoked when you make a toolbar into a shortcut
(pop-up) menu.
4. To start adding commands to your new shortcut menu, choose the Toolbars tab.
5. Select the Shortcut Menus check box (as shown in Figure 7-12). Find the new
shortcut menu under the Custom menu on the right side of the Shortcut Menus bar.
Figure 7-12. Displaying shortcut menus with other toolbars.
6. Now that you have found the new shortcut menu, you can drag and drop all the record and form-related commands onto the menu, such as the Form View menu that I have built in Figure 7-13.
Figure 7-13. A demonstration of a Form View shortcut menu.
Whenever you want to edit the shortcut menu further, you need to open the Customize dialog, select the Toolbars tab, and select the Shortcut Menus check box. Alternatively, you can find your shortcut menu by selecting the menu you want with the drop-down list at the top of the Toolbars tab.
Integrating Menus into Your Forms and Reports
Adding a toolbar or menu to your Access user interface requires
no more than changing a few properties on your forms and reports. These
properties are the Menu Bar, Toolbar, Shortcut Menu, and Shortcut Menu Bar, and
they can be found in the Other tab of the Form properties dialog (shown in
Figure 7-14). To add a custom menu or toolbar to a form, open the form in design
view and show the form’s Properties dialog. Now select the Other tab to add your
custom menus to a form.
Figure 7-14. Adding custom menus and toolbars to your form.
Find Out More
Click on the following button
Click
here for Book Samples of Menu and Toolbar Protection
These samples are discussed at
length in Chapter 7 of Garry's Book on Access
Protection and Security
Read More
Form Based Selection
Criteria For Queries using Combo Boxes
to jump to the next page in the protection samples loop.