getting ActiveX error OnClick Event

[Jyan]

OK, major stumbling block here, trying to get a button to run any code results in the attached error, tried repairing Access 2010 but same thing happens even when I have an empty procedure. Any help much appreciated!

 

[Jyan]

same thing, as I said any code

 

[Jyan]

Thanks for your reply. Sorry if mine sounded sarcastic. I tried what you said. It didn't work. I got the same error message.

 

[DCrake]

What state is the application in? Is it a compiled version (MDE/ACCDE) If so Access reports undefined errors all the same way. Unlike an MDB it will say for example Invalid Use Of Null as the actual error, whereas the compiled version knows that an error has occurred but does not clearly know what is at fault only that an error occured when you click the button.

Thus becoming a generic error. Try in the mdb /accdb state to identify the error then trap it.

 

[boblarson]

It sounds like you have code put in the PROPERTY and not the VBA window.

See here for more about that.

And if that isn't it, post the code you have and a screen shot of the design view of the form with the property dialog showing the Events tab.

 

[boblarson]

I can't add to yours and others reputations....

It's Stupid .....

See Here:

I can't see your image because it is blocked at work. Why not just post images here on the site and the use that link to do an inline image. This is how you would do it.

And if I guess right, it is just the way the vBulletin software is and configured. It is meant to keep people from manipulating things. Personally I don't pay too much attention to it anymore as most of the people who might post reputation are new users and they don't have any reputation points yet.

 

[Jyan]

What state is the application in? Is it a compiled version (MDE/ACCDE) If so Access reports undefined errors all the same way. Unlike an MDB it will say for example Invalid Use Of Null as the actual error, whereas the compiled version knows that an error has occurred but does not clearly know what is at fault only that an error occured when you click the button.

Thus becoming a generic error. Try in the mdb /accdb state to identify the error then trap it.

Thanks for the reply, no it's not compiled.

 

[Jyan]

It sounds like you have code put in the PROPERTY and not the VBA window.

See here for more about that.

And if that isn't it, post the code you have and a screen shot of the design view of the form with the property dialog showing the Events tab.

Thanks for the reply, no it's not in the property. The code is in the VBA window.

 

[Jyan]

Thanks for the replies.

I now believe Access has somehow corrupted that instance of the form. I copied the form to same database and the copy works without changing anything, but the original still comes up with the same error. I will work with the copy and remove the original.