As you can expect, there is never enough information when it comes to powerful products like Access. To assist you with further investigations, I have put together a Web page with
Tuning Up Your Design
All About Command Bars: Menu Bars, Toolbars, and Shortcut
Command Bars in Access 97
You can find the further reading Web page for this chapter in the Downloads section of the Apress Web site ( http://www.apress.com ) or at the address http://www.vb123.com/map/too.htm .
Now I will introduce some additional VBA code samples that are included in the downloadable database.
object is a powerful tool that has many properties and
Show you how to list all the commands in a shortcut/pop-up menu.
Find all the custom menus in your database and display them in a separate list box for each toolbar type. You can easily
Figure 7-22: - Additional toolbar VBA code in the frmShowMenus form.
Another way to restrict the menu items in an Access database to those that are essential for forms and
Include the /Runtime option in an Access shortcut file (explained in Chapter 10).
Install the runtime environment on a computer that doesn't have Access installed. This packaging system is available if you purchase the Office Developer edition of Access.
The menus displayed are the same as those if you clear the Allow Full Menus startup check box. It is necessary to have a startup form before starting Access in runtime mode. You can read more about runtime systems in Chapter 12.
To use the same menus across multiple databases, I recommend that you keep all your standard menus in one library database and give the menus a
Access is a multifaceted interface designed for both developers and users. Nowhere is that more apparent than in the
How to build custom toolbars, menus, and shortcut menus.
How to add VBA code to the custom toolbars.
How to use VBA to change the relevant properties in your forms so that they use your custom toolbars and shortcut menus.
What the toolbar
How to disable developer-specific toolbar commands on end-user computers.
Of course, this seems like a lot of material, but I can assure you that though toolbars and menus seem a little tricky at first, they really are quite easy to set up. As a first step, you should ensure that the developer-specific commands are not available to the end user, because this precaution will better protect your database and make it easier for your users.
Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities
Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs
Building Microsoftu00ae Access Applications (Bpg Other)
VBA Developer's Handbook, 2nd Edition