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?
schneider_ksAsked:
Who is Participating?
 
schneider_ksConnect With a Mentor Author Commented:
NO, no compile errors, but I just experimented with deleting that VB code, saved, and then put the code back in and re-saved and now the data entry is working.  So, thanks for your help - I'll be back if there are more problems!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
schneider_ksAuthor Commented:
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...??
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
schneider_ksAuthor Commented:
We upgraded from 2007 to 2010 - any chance this would all be fixed if we installed the new program instead of upgrading?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Can you upload the db ?

mx
0
 
schneider_ksAuthor Commented:
sorry no - lots of privacy / HIPPA issues
0
 
schneider_ksAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
This error is generally associate with an Active X control. Are there any special controls on this form?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
0
 
schneider_ksAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Back to the VBA editor >> Debug >> Compile.
Do any compile errors occur ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Guess we lucked out ..

mx
0
 
schneider_ksAuthor Commented:
I guessed and tried a few things and stumbled on something that worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.