View Single Post
  #13  
Old August 10th, 2009, 03:21 AM posted to microsoft.public.access.forms
Brent
external usenet poster
 
Posts: 143
Default Main Menu Form Will Not Open

Gina

"Gina Whipp" wrote:

Brent,

Is this the line that is highlighted in yellow?

There is no yellow highlighted line the line above was in blue

Also, copy/paste the rest of the module here. This is from the form code


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

Dim ctl As CommandBarControl

On Error GoTo Err_CMD_EnableCommandBarCtl
Call RecordTrace("basCmdFunctions", "CMD_EnableCommandBarCtl", pcbr.Name)
CMD_EnableCommandBarCtl = False

Set ctl = pcbr.FindControl(msoControlButton, Tag:=pstrTag,
Visible:=True, Recursive:=True)
ctl.Enabled = fEnable

CMD_EnableCommandBarCtl = True

Exit_CMD_EnableCommandBarCtl:
Exit Function

Err_CMD_EnableCommandBarCtl:
Select Case Err
Case 91 'Control doesn't exist
CMD_EnableCommandBarCtl = True
Case Else
Call GlobalError("basCmdFunctions" & ".CMD_EnableCommandBarCtl")
End Select
Resume Exit_CMD_EnableCommandBarCtl

End Function

Hope this helps


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