Access 2003 database On Open Event Error

[Jorist]

I have an Access Database that was developed in 2007. One version of the
database is saved in 2003 for compatabilty with some users.

The Access 2003 databases started reporting the following error when opening
the menu. "The expression On Open you entered as the event property setting
produced the following error: Object or class does not support the set of
events."


The only On Open event is:

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True

End Sub

This code is the exact same code used by the Switchboard Manager. Does
anyone have any thought as to why this keeps throwing an error and how I can
fix it?

Any help would be GREATLY appreciated.

 

[CrazyAccessProgrammer]

I've run into this as well. One thing is for sure, Offic 2007 and prior
versions of access do not get along well.

I tested an Access 2003 database that behaved the way you describe in your
post on a PC that never had an install of Office 2007 and it works fine. Put
the same Access 2003 database on an install with Office 2007 and it started
having that error you posted.

I'm still trying to figure out the best solution.

 

[Peter Hibbs]

Are you aware that the Switchboard wizard in Access 2007 does NOT use
any VBA code to create the Switchboard form, it uses the new Macro
system only.

If you create a new Switchboard using Access 2007 in the .accdb format
I don't see how this could work when used in Access 2003.

HTH

Peter Hibbs.

I've run into this as well. One thing is for sure, Offic 2007 and prior
versions of access do not get along well.

I tested an Access 2003 database that behaved the way you describe in your
post on a PC that never had an install of Office 2007 and it works fine. Put
the same Access 2003 database on an install with Office 2007 and it started
having that error you posted.

I'm still trying to figure out the best solution.

I have an Access Database that was developed in 2007. One version of the
database is saved in 2003 for compatabilty with some users.

The Access 2003 databases started reporting the following error when opening
the menu. "The expression On Open you entered as the event property setting
produced the following error: Object or class does not support the set of
events."


The only On Open event is:

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True

End Sub

This code is the exact same code used by the Switchboard Manager. Does
anyone have any thought as to why this keeps throwing an error and how I can
fix it?

Any help would be GREATLY appreciated.