A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Main Menu Form Will Not Open



 
 
Thread Tools Display Modes
  #1  
Old August 7th, 2009, 08:35 PM posted to microsoft.public.access.forms
Brent
external usenet poster
 
Posts: 143
Default Main Menu Form Will Not Open

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
  #2  
Old August 8th, 2009, 03:26 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Main Menu Form Will Not Open

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



  #3  
Old August 8th, 2009, 05:04 PM posted to microsoft.public.access.forms
Brent
external usenet poster
 
Posts: 143
Default Main Menu Form Will Not Open

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




  #4  
Old August 8th, 2009, 11:14 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Main Menu Form Will Not Open

The next problem with A2000 is that it had many service packs - do you have
them all installed?

The next thing to check is the code.
What code do you have when the database opens?
Is there an autoexec macro?
What code is on the main menu form?

One way to test the code is a method like this that I have used--
Open your database with the shift key.
Open the main form in design view and put break points on the subs and
functions.
Close the main form.
Now open the main form in form view from the database window.
When the code window opens, step through the code.
Note the first error. I don't recommend making any changes to code in break
mode, so stop the code and then fix the code.
Keep testing and fixing until it works.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"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






  #5  
Old August 9th, 2009, 12:35 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Main Menu Form Will Not Open

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






  #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






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

Here is me first debug problem that is identified

Public Function CMD_EnableCommandBarCtl(pcbr As CommandBar, pstrTag As
String, fEnable As Boolean) As Boolean

This shows up in each Module I debug. Does this help or is their more to
this that I need to post?

"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






  #8  
Old August 9th, 2009, 09:59 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Main Menu Form Will Not Open

Is this function the spot where the compiler stops and gives an error?
What error does it give?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Brent" wrote in message
...
Here is me first debug problem that is identified

Public Function CMD_EnableCommandBarCtl(pcbr As CommandBar, pstrTag As
String, fEnable As Boolean) As Boolean

This shows up in each Module I debug. Does this help or is their more to
this that I need to post?

"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








  #9  
Old August 10th, 2009, 12:06 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Main Menu Form Will Not Open

Brent,

Is this the line that is highlighted in yellow? Also, copy/paste the rest
of the module here.

--
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
...
Here is me first debug problem that is identified

Public Function CMD_EnableCommandBarCtl(pcbr As CommandBar, pstrTag As
String, fEnable As Boolean) As Boolean

This shows up in each Module I debug. Does this help or is their more to
this that I need to post?

"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








  #10  
Old August 10th, 2009, 12:09 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Main Menu Form Will Not Open

Brent,

Did you convert this database to Access 2003? Because according to the
Object Library you did not. So perhaps the better question is what version
is your databse?

--
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
...
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








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.