MsAccess 2000 crashing

[andzejek]

I did setup a module with public variables(12) declaration like:
Option Compare Database

Public glb_Job_descr As String
Public glb_zip_code As String
Public glb_sched_day As String
.
.
.

These variables have values assigned on a forms (with text and combo boxes) like:
Private Sub JOB_DESCRI_LostFocus()
glb_Job_descr = IIf(IsNull(Me.JOB_DESCRI.Value), "", Me.JOB_DESCRI.Value)
End Sub
It was working fine for a while but now access is crashing every time I click on combobox(try to open) any of them on one form. The only message popping up during a crash is the message which is asking to send report to Microsoft.
Can someone tell me what is wrong?

 

[scorpio1769]

Perhaps adding error descritpions to your code to see what happens?

 

[andzejek]

well, it is working again, but I don't have idea why.
Thanks

 

[Remou]

Back up and decompile. With complicated projects, that is projects with a number of forms and a lot of code, I find that creating a new database from time to time and importing everything from the old database keeps everything ticking away nicely.

You may find this useful:

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[sentineluk]

Google for "Decompile"

I like to do this reqularly when messing around in the design stages.

Garry