Access strange Error

Murray Brown
Murray Brown used Ask the Experts™
on
Hi
I am getting the following error on an Access form that has worked for years. I am not sure why

1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mark EdwardsChief Technology Officer

Commented:
No idea when or where this is happening.  No idea what the code is that's failing....  This may be due to old code that has never run until now because the conditions to run it have just now been met.  Sounds like it involves a Click() event, or an ill-formed error handler or some other code that has moved the code execution to a subroutine that is ill-formed.

Given what we know - that the code has been working for years and now it doesn't - here's the only help I can give - what did you change?
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Hi Mark. I deleted a button without deleting it's click event. I ended up just importing the form from a backup and deleted the same button and nothing went wrong. It may have been some kind  of corruption
Software & Systems Engineer
Commented:
Usually when something like this happens either is a bad reference or a corruption.
1st thing to do is to decompile your application and debug->Compile...a lot of interesting "errors" should popup.
I've seen this quite a few times. It can usually be solved by decompiling. For more information on what the decompile process does and how to do it see this article:
How to decompile an Access Application
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial