View Single Post
  #6  
Old August 9th, 2009, 08:24 PM posted to microsoft.public.access.forms
Brent
external usenet poster
 
Posts: 143
Default Main Menu Form Will Not Open

First of all thanks to Jeanette and Gina for your help with this problem.

I will start with listing the References I have checked in order from first
to last:

1. Visual Basic for Applications
2. Microsoft Access 10.0 object Library
3. OLE Automation
4. Microsoft DOA 3.6 Object Library
5. Microsoft Active X Data Object 2.5 Library

Now I will try some of the other suggestions and this may take some time as
I am not good with Modules and code issues.

I will post back results or if I have problems with the codes



"Gina Whipp" wrote:

Brent,

Things I would check...

1. Please list the References you have set and the order in which they
appear. Because Access 97 had some References that were unnecessary to
future versions, once you post what you have one or two may need to be
eliminated to 'fix' the Main Menu.

2. Make sure at the top of every module appears...

Option Explicit
Option Compare Database

This will insure the are no undeclared variables that are causing the
problem.

3. Go into an module window and Debug - Complie and fix any errors that
might appear.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Brent" wrote in message
...
Thanks Jeanette
When I opened the code and check the references the Microsoft DAO 3.6
Object
Library was already checked, I compacted and repaired a few times and the
result is the same, the Main Menu Form will not open it still thinks I
have
not converted to a newer version. Could there be something in the code
somewhere that is causing this? if so where can i find it?

"Jeanette Cunningham" wrote:

Hi Brent,
When you have the database open and the main form open in design view,
open
the code window and check the references.
You will need to select the Microsoft DAO 3.6 Object Library as a
reference.
After you set that reference and close the references dialog, do a
compile
and fix any errors until the code compiles.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Brent" wrote in message
...
I have just converted a database from version 97 / 2000 to MS Access
2003.
The Main menu form will not open, I get a message that I must convert
to a
newer version that 97 / 2000 and then it closes the database down. I
have
converted the database. This is the only form that will not open. I
open
the
database using the shift key and the main form will open in design
view.
Can
someone help with this problem?

Thanks