Forms that quit?

[Peanuts]

What would make a form just quit opening?

I have a database with 6 different forms in it. Only one is a sub form.

My main form, ( the one I use most) has quit opening. I click on that form, the hour glass runs then turns off and nothing opens. All other forms, tables,queries, reports open up instantly just like their susposed to. I have lost no data, the form just won't open!

I have a backup copie of which I import the main form from, then I import all the other tables, reports form my main form to the new DB an it works great for a couple three days then the main form decides to quit.

Does anybody have any ideas? I have tried compacting and repair which doesn't help.

Thanks for your help and suggestions

 

[Rich]

Have you compiled and saved all code?

 

[Peanuts]

Well, I'm not sure about compiling the code, I have saved the code.

I set my databases up to compact and repair on close. When I transfer everything over to a new database everything works great.

 

[Peanuts]

I have been trying to think of what might cause this to happen.

My form is where I enter the data. This data changes, so what I do is go into my form, deleate the old data (highlight and type over) and reinter the new data, save then compact and repair.

Some days I might have to do this 3 or 4 times. I have never had any problems before while doing this though.

 

[jon98548]

I am in the middle of the same problem myself. My form uses a union query to get its data. I had a problem with one user's machine that couldn't run the UNION SELECT query. I changed it to a UNION ALL SELECT and the query will run if I just look at it, but my form now does exactly what you say. I have an even longer description here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52569

Trouble is, I got no fix.

 

[Peanuts]

Sounds just like mine, except that I don't get an error message on anything, and I can't even get into the design view of my form.

 

[jon98548]

I wonder if anyone knows of the Access library would be associated with the unino query. I hate to arbitrarily add libraries, but I noticed I don't have the DAO 3.6 (is that right?) installed. Should I install and see if that helps?

 

[jon98548]

Just as an update, my problem was fixed when we had Win2K SP3 installed.