vb123.com.au
Right-Click Microsoft Access Menus
This is a sample from the
Microsoft Access Protection book by Garry
Robinson
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.
Your Access 2002/2003 sample database file is called "grMap2002.zip"
and your Access 2000 sample database file is called "grMap2000.zip"
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
Find Out More
These samples are discussed at
length in Chapter 7 of Garry's Book on Access
Protection and Security
Read More
Other Pages At VB123.com That May Be Of Interest
Setting Up Right Click Menus for
Access 2007
Remote Updates of a
Back-End Database
Form Based Selection
Criteria For Queries using Combo BoxesClick on the following button
to jump to the next page in the protection samples loop.
Our Tools and Resources
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
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
Access 2003 Security
Right-Click Microsoft Access Menus
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.
Your Access 2002/2003 sample database file is called "grMap2002.zip"
and your Access 2000 sample database file is called "grMap2000.zip"
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
Find Out More
These samples are discussed at
length in Chapter 7 of Garry's Book on Access
Protection and Security
Read More
Other Pages At VB123.com That May Be Of Interest
Setting Up Right Click Menus for Access 2007
Click on the following button
Form Based Selection
Criteria For Queries using Combo Boxes
to jump to the next page in the protection samples loop.
Our Tools and Resources
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
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
Access 2003 Security
