Discussion on:

Referencing command bar and control objects in Access

I noticed in your example Figure D there are five buttons near the right end of the Title bar labled "SWRBC" and just to the left of these is the date?

How do you add buttons to the title bar?
Can these buttons be accessed via the Commandbar object?

I've always read that you CAN'T control menu bars in microsoft Access. Sure, in the Visual Basic Application (by itself) it works great, but Access won't let it's Visual Basic use the menu bar.

If I am totally wrong, please let me know how this is done! Because this article doesn't show how to make Access's VB use menubars.

As long as you include a reference to the Microsoft Office Library within VB,( as the author points out at the beginning) you should have no problem accessing and manipulating the commandbars which is part of the Office object libary that hosts common objects (like the Assistant, CommandBars and FileSearch) for all Office apps.

I already know of this "Microsoft Office 10.0 Object Library" that the author meantions......i've been using Access for years now using Access 2000 and Access 2002 and i've always had this object referenced in the VB. i can still use the menu bars that are already pre-created, but it never lets me manipulate them. I've used VB by itself and have done this exact thing so i understand the steps to make it work....but not in Access....
are there different versions of Access that this works in that i don't know about??

Not sure why you are so mixed up here dude. The code to control it is right in front of your face. Enter the code the author is using and it works...there you go!! Where is the problem??

This post has been very helpful in a project I'm working on. Some of us still have to work with Office 2003, so this is good stuff! Thanks!