No VBA code will work in form

sweensterpng

New member
Local time
Today, 00:08
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?
 
Have you tried to compact and repair?
 
Hmm, I just did, and it still is giving me this error. It's only a problem in the subform in this form.
 

Users who are viewing this thread

Back
Top Bottom