Object or class does not support set of events

[penfold1992]

Hello,

I have wrote a database in access 2010 and the database works fine for me (I am the db admin with full control)

I gave the database to a group in which most of them also have no issue with the file. They are able to use the database with no issues

One of those members gets an error message when completing the initial step in the database: (select a drop down item from a combo box)

The expression After Update you entered as the event propoerty setting produced the following error: Object or class does not support the set of events

Something I cant seem to understand is why is this happoening on 5 machines but not on the 6th, they all have the same PC set up so there should be no error on one particular machine.

Kind Regards,
Grant

 

[JackKaptijn]

What happens after update?
It must be something with a library but first you need to know which functions is activated....

 

[penfold1992]

This is the code that fails.

Private Sub Progcmb_AfterUpdate()
Me.Clientcmb.RowSource = "SELECT DISTINCT [ID].Prog, [ID].Prog" & _
                           " FROM [ID]  WHERE Prog = '" & Me.Progcmb.Value & _
                           "' ORDER BY Prog"
 
Me.Clientcmb.Value = Null
Me.IDcmb.Value = Null
Me.Clientcmb.Enabled = (Not IsNull(Me.Progcmb))
Me.IDcmb.Enabled = (Not IsNull(Me.Clientcmb))
End Sub

 

[JackKaptijn]

As far I can see, these are all normal Access library functions.
On my Access 2013 the library is C:\Program Files\Microsoft Office\Office15\MSACC.OLB
Is there a difference on the sixth machine with this file?

 

[penfold1992]

As far I can see, these are all normal Access library functions.
On my Access 2013 the library is C:\Program Files\Microsoft Office\Office15\MSACC.OLB
Is there a difference on the sixth machine with this file?

Few things... firstly its a 64 machine so the location is:

C:\Program Files(x86)\Microsoft Office\Office14\MSACC.OLB

Also you will notice Office14, I think Office15 is in Office 2013? were all using 2010.

EDIT: This file exists on there machine.

 

[JackKaptijn]

I do not have an Access 2010 environment.
One machine is running 64-bit Windows 8 with 64-bit Access 2013.

Then the library is stored in C:\Program Files\Microsoft Office\Office15\MSACC.OLB

The other machine is 64-bit Windows 7 with 32-bit Access 2007.
Then the library is stored in C:\Program Files(x86)\Microsoft Office\Office12\MSACC.OLB

Indeed, Access 2010 is Office14.

Are the files the same on working and not working machines?

Jack

 

[missinglinq]

When apps run fine on one machine and not on another, or run fine in one version and not when run under a newer version, one the first things you have to think about are missing references.

If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

Access Reference Problems

Also, is this app split into a Front End/Back End configuration?

Linq ;0)>