F. Scott Barker's Microsoft® Access 2000 Power Programming

WORKING WITH COMMAND BARS THROUGH VBA

The really exciting feature beginning in Access 97 concerning command bars is that you can programmatically create, modify, and delete them at runtime. This gives you, the developer, much more flexibility in designing applications and lets you control which users have access to which features. The following sections provide an example that, at runtime, will look at which type of user is opening a form and will assign tools to a submenu command bar designed for that type of user. But first, let's discuss the object model of command bars.

Note

To program command bars in VBA, you need to create a reference to the Microsoft Office 9.0 Object Library. To do so, open a module, and then choose References from the ...