VBA code doesn't run, no errors
Posted on 2008-06-13
I developed a tool for my company that I'm pretty proud of. It gets rolled out to the whole company next month so that we can do our credit card reconciliation easily. It consists of a front end that lives on each person's desktop and a backend behind the scenes in a common drive. Each person has their own full copy of the front end, so there are no sharing issues. However, I have a couple of users helping me beta test that have problems. There are no error messages when the tool opens the form, and to the untrained eye, there appears to be no problems. However certain command buttons and so forth that should be hidden On Load are actually showing. That tells me right there something is off. Also, regular queries run, but queries that are fully coded in VBA do not execute. I can see this because some fields that should update do not. Finally if they click any command buttons or try to close the form normally they get this message: 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. The expression may not result in the name of a macro..... etc. We all have the same version of ACCESS. They can come back to a PC in my area, log into the network as themselves, pull a new copy of the tool and it works smooth as silk. Also, I had them reload the tool to their own machine and it still didn't work.
I checked Tools > Macro > Security and it is set to Low. I have called it into our help desk but of course they say it is my tool, which I have conclusively proven that it is not. So I'm trying to see if I can figure out the problem on my own. What else should I check?