Opening form causes Access to Freeze/Crash

[Theresa Pistochini]

I am a beginning Access user, and I apologize for the broadness of this
question. I am really having trouble figuring out my problem and heading in
the right direction.

I have a database based on four tables. The first table is the "master"
table. The other three tables have a relationship with the master table (one
is based on two columns of data).

I have a form that uses three subforms to bring up all the data
corresponding to a paricular project. The main form reads the master table,
the three subforms each read from the other tables. The correct entries come
up because I defined the "master/child" relationships section.

I can get everything working fine, and then all of the sudden the form will
stop working. When I try and open the program will hang endlessly with the
little hour class. I have to end the program to stop it. Once this has
happened I can not delete the form, open the form in any view, export the
form, or basically do anything. However all my tables will still open. I
went to a backup version of my database and continued working from that, and
then it happened again! I am not sure what I am doing that it causing it to
occur.

I figure there must be something wrong with the structure that is causing a
endless loop, or something is corrupt, but I don't where to start. I tried
the "compress and repair" but that did not work.

Help please?

 

[SteveM]

Do you have any code or macros running?

Steve

 

[John W. Vinson]

I am a beginning Access user, and I apologize for the broadness of this
question. I am really having trouble figuring out my problem and heading in
the right direction.

I have a database based on four tables. The first table is the "master"
table. The other three tables have a relationship with the master table (one
is based on two columns of data).

I have a form that uses three subforms to bring up all the data
corresponding to a paricular project. The main form reads the master table,
the three subforms each read from the other tables. The correct entries come
up because I defined the "master/child" relationships section.

I can get everything working fine, and then all of the sudden the form will
stop working. When I try and open the program will hang endlessly with the
little hour class. I have to end the program to stop it. Once this has
happened I can not delete the form, open the form in any view, export the
form, or basically do anything. However all my tables will still open. I
went to a backup version of my database and continued working from that, and
then it happened again! I am not sure what I am doing that it causing it to
occur.

I figure there must be something wrong with the structure that is causing a
endless loop, or something is corrupt, but I don't where to start. I tried
the "compress and repair" but that did not work.

Help please?

Does your Form have any code in it - even wizard generated code? This sounds
like some program is going in an endless loop.

Try opening the form in design view and click the Code icon on the toolbar. Is
there any VBA code there? If so copy and paste it to a message here, maybe
someone will see the loop.

John W. Vinson [MVP]

 

[Theresa Pistochini]

Okay, so I can't open the crashing form in Design View (because it hangs even
trying to go to design view). But a slightly older version of the database
where the form will still open has:

'This code links to a group of word documents
Private Sub Command15_Click()

Dim strDoc As String

Application.FollowHyperlink [ContactFile]

End Sub

And also there is this code under the main form:

Option Compare Database


Any ideas? Maybe there is something in my crashing form that is not here.

 

[John W. Vinson]

Okay, so I can't open the crashing form in Design View (because it hangs even
trying to go to design view). But a slightly older version of the database
where the form will still open has:

'This code links to a group of word documents
Private Sub Command15_Click()

Dim strDoc As String

Application.FollowHyperlink [ContactFile]

End Sub

And also there is this code under the main form:

Option Compare Database

Nothing in this code should cause problems (particularly if you don't click
the Command15 command button <g>).

I suspect your VBA project is corrupt. Check out the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm - you may want to Decompile
your database, certainly compact and repair it, and perhaps create a new
database and import all your objects into it. Starting from your older
database version would be prudent! Some corruption cannot be cured.

John W. Vinson [MVP]