Unusual Access 2000 Forms Behavior?

[ctreed]

I was creating a form in Access 2000 when I found I couldn't access it. I had several forms and queries open at the time, and I shut them all down, expecting to be able to reopen the form I was working on again(the form also has a subform which will not open either). At this point, the form still would not open--I would click on the form, and nothing happens, no hourglass or anything. I have three or four other forms that still open correctly.

As a possible clue, I've tried renaming the form to see if I could open the renamed form. After I typed in a new name for the form, and hit 'enter', a message box came back to me saying 'You cancelled the previous operation', after clicking through this box, the same message popped up three times again before a final message box appeared saying, 'Module not found'.

A couple days ago, I installed Access2000 on my system after working with '97--would this be causing some of my issues?

Hmm, what other information is needed? What was the last thing I was doing/What was the last key I hit? I had three to four queries and forms open at the same time, and was moving between them. I've only got four forms, twelve tables, and a couple practice queries in the database.

Has anyone seen this behavior before? Am I smoking something? Is this clear, or is more information needed?

Thanks for all your help!

ctreed!

 

[Jack Cowley]

Sounds like your form is corrupt. You can try importing everything into a new db and see if that cures the problem. If not then create a quick form based on the same table/query and see if that one works.

Did you follow Microsoft's instructions on how to install Access97 and Access2000 on the same machine? I do not think this is the problem, but I thought I would ask....

hth,
Jack

 

[ctreed]

Thanks for the info--I've already moved the other tables and forms to a new db and they seem to work. It looks like it's a corruption issue, like you mentioned. I've just tried moving the forms across to the new db, and when I click on either of them, I'm told me that they can't be found.

Thanks for the assistance--at least I won't be chasing my tail trying to fix something that's already corrupted!

ctreed

 

[Jack Cowley]

I am glad you have sorted out your problem...

Jack

 

[casey]

I've encountered the same frustrating issues. It took re-installing Access and running the SR-1 patch from MS for it to clear up.("knock on wood!").