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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|