Link to home
Start Free TrialLog in
Avatar of schneider_ks
schneider_ks

asked on

Access 2010 error message object or class does not support the set of events

Just upgraded to office 2010 - opened a 2007 database and am getting the error message 'object or class does not support the set of events when I try to enter data in a field on a form
I've made sure that it's a trusted location, and compacted the database
Can you tell me where to go from here?
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Can you show the code where the error occurs?

In the meantime, open the VBA Editor >> Tools>>References ... see if any are listed as:

**MIssing <SomeReferenceName>

mx
Avatar of schneider_ks
schneider_ks

ASKER

I opened the VBA editor and there are none that are listed as Missing.....

There is no code associated with the field that I'm trying to enter data in...??
We upgraded from 2007 to 2010 - any chance this would all be fixed if we installed the new program instead of upgrading?
sorry no - lots of privacy / HIPPA issues
The field is a number field (long integer) with the validation rule [ServiceTime] Mod 15=0 (requires date entry of time in 15 minute increments.
Now when I tab into the field I can enter 1 and then the error message pops up.  I can click the ok on the message box and finish entering a 5 and the data is entered but the message box pops up every time
This error is generally associate with an Active X control. Are there any special controls on this form?

mx
"any chance this would all be fixed if we installed the new program instead of upgrading?"
There is always a chance, but not seeing a high probability here.

Try creating a blank new ACCDB in the A2010 environment, then import all objects (except Linked Tables) from the A2007 db.  See what this produces.

mx
this is the only VB code associated with this (sub) form

Private Sub frm_KS_SF_EnterServices_Enter()
On Error Resume Next
    RunCommand acCmdRecordsGoToNew
End Sub
Back to the VBA editor >> Debug >> Compile.
Do any compile errors occur ?

mx
ASKER CERTIFIED SOLUTION
Avatar of schneider_ks
schneider_ks

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I guessed and tried a few things and stumbled on something that worked.