Weird Error

skunk711

Registered User.
Local time
Today, 07:21
Joined
Jun 19, 2002
Messages
24
Hi All,

I am working on this DB that is quite big, and it is split.
Last night whilst working on a form, another one of my forms completely stopped working.

Whenever i tried to open it, nothing at all happened. Whenever i tried to design it nothing happened. The same for some of the subforms that were within the main form. I went into the Modules and went through the Object Browser, and all of the code for the forms was still there. When clicking on Compile Project in the module, it came up with the error message:

"You cancelled the previous action."

five times, then came up with "Module not Found."

I tried for ages to get it back, I even tried importing from a previous backup, but whenever my form was named the same as before the same thing happened.

I was just wondering has this type of thing ever happened to anyone before, is there a cause, and more importantly, is there a way to prevent this from happening in the future?


Thanks
Ben

PS: No one else wa logged in at the time, and there didn't appear to be any problems as far as corruption goes
 
I experienced this problem once. I believe that, in my case, I had some code that was referring to something that I had gotten rid of and yet didn't change the code or finish the code. So I had a piece of unfinished code in either a form that I wasn't using, or a module I wasn't going to use that was causing the problem.

However, when I ran the compile to show me where the error was, it didn't show me, it highlighted something that should have been fine (and was). I just had to go through every place that code could be and make sure it was all correct and that there were no "hanging chads," so to speak.
 
I am having this exact problem.

I have identified the culprit, but I have no idea how to fix the problem.

I was working on a form that I had imported from another database, I had made some changes to the forms module, but was unhappy with the changes I made. I closed the VB editor, and the Form, then Deleted the form so that I could re-import it and start over. After Deleting the form, I was unable to import it again, and nothing happened when I imported. I tried to copy a form and name it the same, and that form just disappeared.

After doing some digging from the VB editor, it turns out that the old module that went with the form is still in the database, but I can't find any way to delete it.

Importing the objects to a blank database is not very appealing because I'll have to redo all of the object permissions, and there are literally hundreds of forms, reports, and queries in the database. Writing a module to store the permissions and restore them has been on my list of things to do, just hasn't been a priority to this point. :rolleyes:

Any help is greatly appreciated.
 
Install the Office SP-3 and see if that cures your ailments.
 

Users who are viewing this thread

Back
Top Bottom