Access keeps crashing :(

[Phonesa]

Well. What can I say? I'm so confused right now. As soon as I try and tab out of my text box, I keep crashing. It's always the same control, too. The weird thing is, I have no code in there at all so I'm totally stumped. I feel like banging my head on my desk atm. I don't suppose someone has any ideas?

 

[missinglinq]

The first thing I'd do is delete the control and add a new one in its place.

The Missinglinq

 

[Phonesa]

Yeap. I did that. I deleted both controls just in case. I've been backtracking for over 2 hours now tryng to find it.


Well, I think I finally found what's causing it and I'm still confused. I had changed the query my form was based on and it's crashing because there is no matching record. Let me try to explain.

My query for my form is based on three tables:
DefendantInfo: DefendantID , DefendantDetails
Citations: CitationNo , DefendantiD, CitationDetails
TransportInfo: CitationNo, TransportDetails

A Citation may only have one transport record, but it's not required. I clicked on the join property to show all Citationrecords and any transport records with a matching CitationNo. When I run my query, it picks up all the records.

When I go to form view ... BOOM!

Without the Transport details in my query, everything works fine ...

Edit: Well, back at home now and the EXACT version at home works .... go figure. I don't know if it somehow got corrupted or something when burned a copy of the db and took it to work.

 

[missinglinq]

Phonesa,

I have to go off-line for the night in the next minute or so, but I will check back in the A.M. (1300 GMT); maybe in the meantime someone else can step in and help. The one problem I do see, if your last post of tables/records is accurate, is that:

the field CitationNo ties the Citations table and the TransportInfo table together, but there is no common field tying the DefendantInfo table to either of these tables. I think you need to include the DefendantID field in the Citations table. This will be the tie that binds and should cause a record to be returned for each defendant.

Hope this helps.

The Missinglinq

 

[Phonesa]

Thanks for responding. I forgot to include the DefendantID when I listed the tables. I do have it in my Citations table. For whatever reason, the exact version just wouldn't run properly at work today. I had burned a copy of it to take to work this morning. I'll burn another copy and see what happens tomorrow. I'll be keeping my fingers crossed and hoping it doesn't crash again tomorrow. Thanks again for your input.


Yes ... I suffer from emotitis.

 

[Phonesa]

Well. Back at work and it still keeps crashing. I tried it on another computer and when I click on debub it is saying that it can't find certain files. It only shows part of the path, but it looks like it's trying to find files that were on my hard drive at home!

When I hit debug on the computer I'm running at work, I get this:
The instruction at "0x1b0c6d8e" reference memory at "0x0000004". The memory could not be "read".

Am I missing something? I'm just basically working on my db at home, then burning a copy, then loading it up at work ...