sweensterpng
New member
- Local time
- Today, 18:32
- Joined
- May 2, 2006
- Messages
- 7
I have been developing a database for a security company for the past several weeks, and am looking forward to having it finished. Imagine how dissapointed I was yesterday when I was creating the last form, and realized that the VBA wasn't working at all. I had typed out a fairly long IF statement, and I was anticipating a little debugging, but I did not get an error message I was expecting.
"A problem occurred while Microsoft Office Access was communicating the the OLE server or ActiveX control"
I went back to the code, noticed I had forgotten to end my IF statement, fixed it, tried running it again, got the same error. I should have gotten a completely different error message, right? Anyway, I tried to simplify things, got rid of the IF statement and threw in a simple message box, just to see what would happen. Sure enough, I get the same error message. I turns out that any code, for any event procedure won't work. Does anybody know what might be wrong with this form?
"A problem occurred while Microsoft Office Access was communicating the the OLE server or ActiveX control"
I went back to the code, noticed I had forgotten to end my IF statement, fixed it, tried running it again, got the same error. I should have gotten a completely different error message, right? Anyway, I tried to simplify things, got rid of the IF statement and threw in a simple message box, just to see what would happen. Sure enough, I get the same error message. I turns out that any code, for any event procedure won't work. Does anybody know what might be wrong with this form?