S
Steve S
I have a db created probably in Access 97, or earlier, that has worked in
access 2000 for 5 years just fine. After installing Office 2007 (left the
2000 versions of Access, Word, and Excel on the PC) I have a problem with
it. Double Click on the file name, Access 2000 opens the db ok and displays
the Main Form which has 4 command buttons. When I click on 4 of the 5
buttons I get the following error:
The expression On Click you entered as the event property setting produced
the following error: Object or class does not support the set of events.
• The expression may not result in the name of a macro, the name of a user
defined function, or [Event Procedure].
• There may have been an error evaluating the function, event, or macro
When I switch to design mode and try to inspect the event procedure I get
the following error:
“Microsoft access for windows has encountered a problem and needs to close.
Bla, bla,blaâ€, and Access closes.
The command button that functions OK (no error) is envokes a macro rather
than a EP.
The db (not a copy) functions normally on a networked PC that does not have
2007 installed. Both units are running XP home. On the second unit I was
able to look at the Event Procedures that seems to be causing the error. See
one [Event Procedure] below.
---------------------------------------------------------------------------------------------------
Option Compare Database
Private Sub Button0_Click()
On Error GoTo Err_Button0_Click
Dim DocName As String
Dim LinkCriteria As String
DocName = "Record Expenses"
DoCmd.OpenForm DocName, , , LinkCriteria
Exit_Button0_Click:
Exit Sub
Err_Button0_Click:
MsgBox Error$
Resume Exit_Button0_Click
End Sub
What is going on here. When will I ever learn to NEVER, NEVER, NEVER
install version 1.0 of ANY software.
access 2000 for 5 years just fine. After installing Office 2007 (left the
2000 versions of Access, Word, and Excel on the PC) I have a problem with
it. Double Click on the file name, Access 2000 opens the db ok and displays
the Main Form which has 4 command buttons. When I click on 4 of the 5
buttons I get the following error:
The expression On Click you entered as the event property setting produced
the following error: Object or class does not support the set of events.
• The expression may not result in the name of a macro, the name of a user
defined function, or [Event Procedure].
• There may have been an error evaluating the function, event, or macro
When I switch to design mode and try to inspect the event procedure I get
the following error:
“Microsoft access for windows has encountered a problem and needs to close.
Bla, bla,blaâ€, and Access closes.
The command button that functions OK (no error) is envokes a macro rather
than a EP.
The db (not a copy) functions normally on a networked PC that does not have
2007 installed. Both units are running XP home. On the second unit I was
able to look at the Event Procedures that seems to be causing the error. See
one [Event Procedure] below.
---------------------------------------------------------------------------------------------------
Option Compare Database
Private Sub Button0_Click()
On Error GoTo Err_Button0_Click
Dim DocName As String
Dim LinkCriteria As String
DocName = "Record Expenses"
DoCmd.OpenForm DocName, , , LinkCriteria
Exit_Button0_Click:
Exit Sub
Err_Button0_Click:
MsgBox Error$
Resume Exit_Button0_Click
End Sub
What is going on here. When will I ever learn to NEVER, NEVER, NEVER
install version 1.0 of ANY software.