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?
I've made sure that it's a trusted location, and compacted the database
Can you tell me where to go from here?
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...??
There is no code associated with the field that I'm trying to enter data in...??
ASKER
We upgraded from 2007 to 2010 - any chance this would all be fixed if we installed the new program instead of upgrading?
Can you upload the db ?
mx
mx
ASKER
sorry no - lots of privacy / HIPPA issues
ASKER
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
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
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
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
ASKER
this is the only VB code associated with this (sub) form
Private Sub frm_KS_SF_EnterServices_En ter()
On Error Resume Next
RunCommand acCmdRecordsGoToNew
End Sub
Private Sub frm_KS_SF_EnterServices_En
On Error Resume Next
RunCommand acCmdRecordsGoToNew
End Sub
Back to the VBA editor >> Debug >> Compile.
Do any compile errors occur ?
mx
Do any compile errors occur ?
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Guess we lucked out ..
mx
mx
ASKER
I guessed and tried a few things and stumbled on something that worked.
In the meantime, open the VBA Editor >> Tools>>References ... see if any are listed as:
**MIssing <SomeReferenceName>
mx