The expression On Click....

[Sam H. Carson]

Hi there,

I use a database in work (Access 2000) that contains 4 Pivot Table Forms. I
have I have just run three of the four without problems. However, one of
them produces the following error message when I click the Edit PivotTable
Object button:

"The expression On Click you entered as the event property 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 evaluation the function, event, or macro."

I cannot see any missing References when I check. I'm completely stumped
and am unaware of any changes that have been made to the database since the
last time I worked on it.

Thanks for any help in advance,

Sam

 

[boblarson]

It almost sounds like you put code in the form's event property instead of in
the code window. Check this out
http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid/56/Default.aspx
and see if there is anything that you have that is similar.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Sam H. Carson]

Bob,

I have tried this but the database crashes everytime. I have compared the
coding on each of the pivot-tables and they all look identical. The coding
looks also looks the same.

I think I am going to put this one down to some sort of corruption and just
redo the pvit-table.

Thanks anyway.

Sam

p.s. The link you gave looks good. There seems to be other stuff in there
I'm interested in. Thanks.

--
Sam H. Carson

It almost sounds like you put code in the form's event property instead of in
the code window. Check this out
http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid/56/Default.aspx
and see if there is anything that you have that is similar.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Hi there,

I use a database in work (Access 2000) that contains 4 Pivot Table Forms. I
have I have just run three of the four without problems. However, one of
them produces the following error message when I click the Edit PivotTable
Object button:

"The expression On Click you entered as the event property 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 evaluation the function, event, or macro."

I cannot see any missing References when I check. I'm completely stumped
and am unaware of any changes that have been made to the database since the
last time I worked on it.

Thanks for any help in advance,

Sam