Object or Class does not support the set of events ; Access 03 07

Just thought I'd note to people a potential hazard that they may come across if they install both Access 2003 and Access 2007 on a single machine.

Many of you will be familiar with the reinstall / de-install process that the operating system does when you move between versions of Office be that between Excel / word or other office versions. This feature specifically relates when users have both Access 07 and Access 03 on the same machine.

When you open Microsoft Access 2007, it changes the following registry key to point to the Access 12 Object Library:
[HKEY_USERSS-1-5-21-680354291-1286354565-1361462980-1003SoftwareClassesTypeLib{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}9.0win32]
@="C:Program FilesMicrosoft OfficeOffice12MSACC.OLB"

When you open Access 03 the installer should change this key back to Office 11.

[HKEY_USERSS-1-5-21-680354291-1286354565-1361462980-1003SoftwareClassesTypeLib{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}9.0win32]
@="C:Program FilesMicrosoft OfficeOffice11MSACC.OLB"

Unfortunately at some point this can stop working and the installer will NOT set the key back to the correct value (leaves it pointing to Office 12) If you then try to open any Access 2003 form you end up with the error.

"Object or Class does not support the set of events"

To solve the problem you have to manually point the registry key back to the Office 11 version of the file.

Microsoft’s official response on this issue is to create a .reg file with the correct version of the key, and manually run it before opening Access 2003 after you’ve been in Access 2007.

Initially I thought this was just a feature of Vista but I'm getting it on a XP machine as well. Possible that an update from MS inctroduced this to the operating system.


Post your answer or comment

comments powered by Disqus
hey group
the below error suddenly appeared today.
Been using database for a few years, but lately started going back and forth between access 2007 and the older one.
(getting previous version doesn't help)



"The expression "On Load" 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."

Hi,

I have a form with a few command buttons and it was working very well until recently. On opening access, this form loads and all the buttons on this form do not work, giving the following error:

Object or Class does not support the set of events

*The expression may not result in the name of a macro etc

Compiling the VBA solves the issue, but, it has to be done every time I open the Database, is there some other underling issue that might be causing this?

Is it a references issue?

Thanks for your help

I have a database that is used once a year. It worked last spring but is showing errors now. I am using Vista and Office Professional 2003.

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. Private Sub

Here is a sample of the code that is causing the error:

rptSettlement_Click()
On Error GoTo Err_rptSettlement_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmPrtSettlement"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_rptSettlement_Click:
Exit Sub

Err_rptSettlement_Click:
MsgBox Err.Description
Resume Exit_rptSettlement_Click

The (mdb) does not work but the (mde) created last year works fine. How do I solve the problem so that my (mdb) file works?

This is the error I'm getting. A little obscure, I know, but this is happening in an executable Access application (2010 accde) when I click the close button on a form. The code behind the form is checking a lot of stuff (data validation, etc.), but "Object or class does not support the set of events" is the error. Then the application continues as if nothing had happened. Does anyone have an idea about what might be causing this? The app was converted not long ago from XP ACC2003 to Win 7 ACC2007-2010.

Thanks in advance,
Glenn

hello all,

i have created this very simple to use DB that prints out the information you put in.

i get the following message, which is attached. this is happening for both the "Print and Exit" button as well as the "exit without printing".

the code that runs is:


Option Compare Database

Private Sub txt_print_click()
RunCommand acCmdSaveRecord
Call PrintLabels
DoCmd.Close acForm, Me.Name
End Sub

Private Sub txt_exit_click()
Me.Undo
DoCmd.Close acForm, Me.Name
End Sub

The strange thing is that if i close the form, and reopen it again from the switchboard is that it works (sometimes).

not sure what is happening here, any help/suggestions would help.

thank you. Attached Thumbnails   Reply With Quote 12-09-2011, 04:13 PM #2 aytee111 Expert Windows 7 32bit Access 2010 32bit Join Date Nov 2011 Posts 550 Sometimes I find that if I add the VB Extensibility reference then things start working. I don't know enough about any of it to know it this is your problem or not. In the VBA editor, go to Tools and References and add that one - can't remember what it is called exactly.

I have a place on my form that will open the record


=IIf(IsNull([ID]),"(New)","Open")



Now when I click on this to open the record it gives me an error....

Object or class does not support the set of events!





What would cause this??

Thanks!

This is probably a very basic question:

I have two tables: a master table and a linked table that contains multiple entries for each unique ID in the master table. Both tables are also linked by a query that pulls from both.

I've created a subform that displays the multiple entries from the linked table for each unique ID: IE the sub table shows all the referrals and the data for each of those referrals for the specific ID in the master form/table (I hope that makes sense).

I need to be able to add new referral information (new records?) to the referral table using the subform, and to have the new data appear on the linked table under the appropiate unique ID (so it the subform needs to automatically generate a new record using the existing ID).

I've tried so many different things (and broken the database on a few of those attempts) and I'm just not making headway. I don't really know VBA or SQL language so I need some real help.

Thank you so very much.

Tried hard to write an appropriate title but I dont know what the problem is sorry.

I have a large database:
Tables: 74
Queries: 253
Forms: 114
Reports: 121
Modules: 10

Database is in use with multiple users and I edit it making small tweaks as required. I have been trying to make a small mod for the last 2 weeks without any success. For example if I just change the version number (a public variable in a module) then create an MDE file the MDE will not open instead come up with the error:
"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."

Steps taken so far to resolve the issue:
1. Check all references: they seem fine and I can create an MDE if I dont make any changes so their can't be a problem with references. To be sure I removed references, re-registered and added them back in - still no luck
2. Rebuild database in case corrupt: created a new database and linked and imported all objects. Even without any changes this new database could not create an MDE that would run.
3. Try to pin point problem: changed the database to just run (from start-up) a simple form with a single cmd button. Form loaded but clicking on the button produced the same error, even with no code in the OnClick procedure.

Next step: Recreate the database with all the tables and queries and then add one object at a time. That could be a very lengthy process. If anyone has any better ideas I would love to hear from you.

Thanks,

Rob

I keep getting the following error when i click an important button.
I even tried recreating a new button with one line of code behind it and still no joy.

Anybody any idea?

the error is:

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.

Thanks

Martin

p.s. this is driving me nuts.

I'm trying to put together a database that is capable of exporting mde files.
The database is currently in 2000/03 format, but will most likely be run on 2007 machines, which will produce 2007 mde (or accde) files.
The people that need to run the mde files, will most likely have Office 2003 installed, so I've been looking at packaging in the Access 2007 runtime for them to run these mde files.
Here are the findings on my machine, which is currently running Office 2003:
1. Install Access runtime, and then the mde created under Office 2007 will open fine.
2. Try to open an old mdb file, this gives an error - "There was a problem sending the command to the program." The file still opens though, but gives an error "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"
3. Uninstalling the runtime and reopening an old mdb repairs the 2003 installation and everything works fine again.

So, is there a way to install Access Runtime 2007 without destroying my 2003 install?

Hello - I have two Databases in 2003 that i built and use for work. Never had any problems until the IT installed 2010 on all computers, so i have both 2003 & 2010 on my PC. Although i still open my original Databases in 2003 i now receive the above message on both databases. Does anyone have the same problem and know how to correct the error?
Cheers

Hi there,

To start off, Yes, i have done a search, and every result does not help.

When I launch my Database file, it would normally run some scripts (I don't actually know what they do, the file is not used by me, only colleagues).
Instead i get this error:
The expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events. When I click 'OK' another error appears:
The expression On Timer you entered as the even property setting produced the following error: Object or class does not support the set of events. Once i click 'OK' on this error, another error sometimes occurs:
The expression MouseMove you entered as the even property setting produced the following error: Object or class does not support the set of events. But strangely enough the third error doesn't occur every time i move the mouse.

After these errors have been closed, all i have is my 'form' with a loading bar. I cant access the actual database. Nor can i get into the Visual Basic to try and find the cause.
This is happening to multiple clients of mine, and me personally.
Running Windows 7, Server 2008 (64bit), Windows 7 (64bit)
Running Access 2007 and Access 2010.

I have tried changing permissions on the file, this doesnt work.

Any help is greatly appreciated!

hi there;

i am trying to enter the date in a box of a form (in datasheet view) using a macro. as soon as the box is clicked, the date must be entered into the box.

i have been able to do this before using macros but i have forgotten how to do it! which action do i use when creating the macro?

currently i am using the SetValue action (not avaliable in access 2010) with the item "[Forms]![HILL]![DATE IN]" and expression "Date()".

i am using access 2010

im getting the error message "object or class does not support the set of events".

note: i do not know how to read or write VBA.

many thanks for any help in advance.

I am not a new user but I am having a problem that has me stumped!

I have a large database that I have been trying to fix for the last 2 weeks and tried everything I can think of. Problem is that code wont run (I know there are a lot of things to try and fix this).

Today I decided to start at the beginning (would have been nice to think of that earlier) and create a new simple database with only a single form with a single command button running some simple code:
MsgBox "Code has been run", vbOKOnly, "Test"

I get the following error:
Error: "Object or class does not support the set of events"

My conclusion is that my computer is no longer capable of running MS Access. I would love to know why. Let me know if you have any ideas. If not it looks like I will have to uninstall and reinstall.
OS: Vista
Access: 2003

Thanks,
Rob

Hello : )
I've tried a ton of different ways to go about this and i'm completly stumped.

I have a main form with subform. On the Subform's beforeupdate event i want to change somehting on the mainform. so my code looks liek this:

	Code:
	Private Sub Form_BeforeUpdate(Cancel As Integer)
Forms![new1]![Date Modified] = Now()
End Sub

i've tried me.parent![Date Modified]
i've tried creating a function in a module that runs this code and calling the function from the subform's beforupdate procedure.

idk what to do please help.

the Error message i get: "The Expression before update you entered as the event property setting produced the following error: object or class does not support the set of events."

Sometimes I get the below error message when I open a form; I can't figure out what causes it; I have to close, compact db, and reopen until it goes away.
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.
To highlight my row, I am using:

txtCurrentRecord =
txtBackground = IIf([EventID]=[txtCurrentRecord],String$(200,"g"),"")


Here is the code on that form:


	Code:
	Private Sub Form_Current()

On Error GoTo ErrorHandler
    
    Me!txtCurrentRecord = Me!EventID


CleanUpAndExit:
    Exit Sub

ErrorHandler:
    Call MsgBox("An error was encountered" & vbCrLf & vbCrLf & _
        "Description:  " & Err.Description & vbCrLf & _
        "Error Number:  " & Err.Number, vbCritical, gstrAppTitle)
    Resume CleanUpAndExit

End Sub

Private Sub Form_Load()

On Error GoTo ErrorHandler
    
    DoCmd.MoveSize 4480, 1460
    
    If Not IsNull(Forms!frmViewEventHistoryList!ActivityType) Then
        Me!txtAppls = ActivityTotal(1)
        Me!txtAttachments = ActivityTotal(2)
        Me!txtConductJobFair = ActivityTotal(3)
        Me!txtCallsIncoming = ActivityTotal(19)
        Me!txtCallsOutgoing = ActivityTotal(20)
        Me!txtConductInterviews = ActivityTotal(8) + ActivityTotal(9) + ActivityTotal(10) + ActivityTotal(11)
        Me!txtMeeting = ActivityTotal(16)
        Me!txtNotes = ActivityTotal(17)
        Me!txtEvaluations = ActivityTotal(18)
        Me!txtPhoneSurvey = ActivityTotal(21)
        Me!txtPrep = ActivityTotal(22)
        Me!txtReceived = ActivityTotal(4) + ActivityTotal(6) + ActivityTotal(14)
        Me!txtCVS = ActivityTotal(23)
        Me!txtSearchedOnline = ActivityTotal(24)
        Me!txtSends = ActivityTotal(5) + ActivityTotal(7) + ActivityTotal(15)
        Me!txtTesting = ActivityTotal(25)
        Me!txtToDos = ActivityTotal(27)
        Me!txtTraining = ActivityTotal(28)
    End If
    

CleanUpAndExit:
    Exit Sub

ErrorHandler:
    Call MsgBox("An error was encountered" & vbCrLf & vbCrLf & _
        "Description:  " & Err.Description & vbCrLf & _
        "Error Number:  " & Err.Number, vbCritical, gstrAppTitle)
    Resume CleanUpAndExit

End Sub


Any suggestions on getting rid of this problem?

Hi

I have a small database with one form containing 4 small subforms. Whenever I click any of the buttons on the form I get this error:

"The expression OnClick you entered as the event property setting produced the following error: object or class does not support the set of events"

I've seen this before many times, went into the event procedure of the OnClick event and fixed it. Problem this time is I can't get into the event procedure. When I try and get into the code for any button access crashes and throws me out. I can't even get in to copy it.

I've tried compact and repair and creating a new db file/importing everything again.No joy. Tables,queries, reports all work fine.

Looks like corrupt code on the form but i'd rather not spend time rewriting it as some was quite tricky to get working in the first place, any suggestions?

p.s. I had 2 backup copies of this database (one saved locally) and both of them are doing the same thing which is really puzzling me! Tried it on another PC as well!

Is there any way to avoid the following error when opening older databases with Access 2007:

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.

I am getting the following error when I try to open a database created in an older version of Access:

"The expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events."

This database is in the Access 2000 format, but it appears that 2007 tries to take over. Any ideas? I have several databases in the old format that I need to be able to maintain and I can't have this error popping up.

Greetings everyone. This is my first post in this forum. It has been several years since I've done anything Access-related and I'm looking to relearn what I've forgotten and expand my knowledge base. Right now the following problem at work has me stumped:

My company built an MS Access 2003 database on our computers, which run Windows XP as our operating system. We burned the database onto a CD and shipped it to a client for them to open on their Vista-based computers. When they open the database on the CD it works fine, but when they attempt to copy or save it to their local drive the database forms will not open and the computer creates a duplicate database in the local drive. They get the following error message whenever they try to open any forms:

"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"

Is this a Windows to Vista thing, or is there something else going on?

Here is the bottom line. What I am trying to accomplish is not having duplicate enteries in a combo box. I think I am close now. Here is what I have so far:

1. Main Form called FrmBatch2b
2. Subform Called TblName subform
Link Master field is ID
Link Child field is Name_ID
In the Subform I have two fields
1. Called Name_ID
2. Called FullName (I have changed Fullname to a combo box)
Control Source is Fullname
Row Source is SELECT TblEmpName.FullName, TblEmpName.Name_ID FROM TblEmpName ORDER BY TblEmpName.FullName;
Row Source Type is Table/Query

I have pasted this code:
Private Sub LastName_BeforeUpdate(Cancel As Integer)
If DCount("*", "[TblEmpName]", "[lastname_ID] = '" & Me.[Lastname_ID] & "'") 0 Then
Cancel = True
MsgBox "cannot save duplicate", vbExclamation, "Duplicate"
End If
End Sub

I receive a error Object or class does not support the set of events

The above 2007 MS Security patch was processed to all of company computers. Now I have two Access db's that are receiving errors when agents try to sign in.
The expression MouseMove you entered as the event property setting produced the following error:Object or class does not support the set of events.
and
The expression On Unload you entered as the event property setting produced the following error: Object or class does not suopprt the set of events.
I am new to Access and think that the security patch is creating the errors but I am not sure. Any assistance would be greatly appreciated.

My 2003 Access DB opens fine in 2007 but errors out when opening in 2010 with this error message: " 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 On Open Event of my start-up form contains silly stuff regarding objects being visible or not depending on whether an Open Args is passed - even when I RIM out all info in the On Open event for that form, the form will not open.

I have a feeling it might be due to missing references but I can't find any. I have the same references listed in my 2007 Access and my 2010 Access.

Any suggestions? Thanks so much! Yvette

Having a problem here after installing 2007. All my previously created databases work fine in 2007 (after clicking the enable, which is a pain,but don't know any other way) When I return to 2002 and try to open the databases I get different errors all something like this on....... "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. Whats up here?????


I have found a site here...http://allenbrowne.com/bug-17.html
Mentions this problem,but refers to Vista..... Does the same apply to XP? And which is the best fix?


Not finding an answer? Try a Google search.