Just post back to either tom's post or mine - we will all see it.

Now that you have that reference to the Microsoft Office 11 Object Library,
what happens when you try to open the database? If it opens and works
correctly it is fixed. Does it?

To comment out code, you put an apostrophe as the very first character at
the start of the line or lines of code.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia




"Brent" wrote in message
...
Jeanette

How do I comment out the code on the main form? I'm not sure if all the
forms have the same code I could check and post back.

I will post back to Tom under his post, I'm not sure if that is how it's
done or if I should post back under the last post.

Thanks again I can't believe you are still with this.

"Jeanette Cunningham" wrote:

As I understand, all your forms have this code in them. I would have
thought
that all your forms would have the same problem when you try to open
them.

If this was me, I would comment out the code on this main form that
doesn't
work and then open the form to see if it will open.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Brent" wrote in message
...
Thanks again Jeanette for all of your help. I am going to go back to
the
begining of these posts and redo everything you and others have
suggested
to
make sure I have not missed anything. If that doen't work I think I
will
be
at the end with this form and maybe try to recreate it.

Once again thanks for everything.

"Jeanette Cunningham" wrote:

Brent, I didn't look at the downloads. I understood that they were
examples.

Do this--
Open your database and open the code window.
You are using A2003 aren't you.
Go to Tools | References
and scroll down the list till you find
Microsoft Office 11 Object Library
Check the box next to this reference then close the references dialog.
Do a compile.
Hopefully it will compile and the main menu problem will be fixed.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia




"Brent" wrote in message
...
Jeanette

I got the downloads and opened them however, I'm not sure how they
work,
do
I copy some of the code into my code?

I can understand it you have had enough of this and want to move on.

thanks again for your help

"Jeanette Cunningham" wrote:

Here is some information from a colleague. He has a download that
explains
it.

CommandBarControl is a member of the Office object library. If the
code
uses
early binding, you will need a checked reference set to the
"Microsoft
Office {version} Object Library" (mso.dll). There is a downloadable
sample
available on the Seattle Access User's Group site:

A2003 uses version 11.


http://www.seattleaccess.org/downloads.htm

Quick Demo for Enabling Command UI, Zac Woodall, April 2005

Download (27 kb)

Adapted for '97 and 2000/2002, Tom Wickerath, May 2005

Download (51 kb)