• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. PROGRAMMING OFFICE COMMAND B... > WORKING WITH COMMAND BARS THROUGH VB...

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 Tools menu. Find the reference and mark that you want to include it. If you don't do this, you won't be able to use the objects available in the Command Bar object model.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint