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)