error in access

[subwoofer]

Hi all,

Does anyone know what causes the following problem in Access:

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

and what the possible solutions may be for this???

The database displays this error message when trying to click on any of the buttons on the main form of the database application. When I restore it to a previous version, it starts working fine. This has happened twice since the database was created (March 2005) , and both have occured within 6 months of each other, so resolving this issue is important.

Access 2000 is the version being used.

Thanks in advance for any help!

 

[Dennisk]

this may be a corruption. try these option
1) run the repair command from the tools menu.
2) Create a blank form and paste controls and any event code from the form in error.
3) create a blank db and import from the original db.

 

[boblarson]

It could also be that when someone tries to add an event manually (Access manages those and you can't add one manually).

In other words, if someone were to have a command button named cmdButton and wanted to put code in the ON Click event and they didn't select the click event, but while in the code window actually typed:
Private Sub cmdButton_Click()
to create that event, that would also cause the error.

 

[subwoofer]

Hi,

Sorry for the VERY late response! Been very busy the past few weeks!

I just opened a copy of the 'corrupt' database (or what I assumed was corrupt) and everything seems to be working perfectly - haven't changed anything in the database or on my computer/network!

Strange!!!

Any ideas folks???

 

[subwoofer]

Ahh...tried on other computers on the network - worked okay. Then came back to my machine and opened the 'corrupt database', and when clicking on any of the main forms buttons the error described in my first post occurs!!!