Database shutdown

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

I just click on any of the field in subform.It gives that error and the
database is shutdown

Microsoft Access and windows has encountered a problem and needs to
close.We are sorry for the invonvenience. I did

following things but its a same problem.

1.I run Tools-Repair database but same problem.
2. Copy all files to a new databse but it wont work.
3. Copy whole form as a text file and then load it from that file but
still same proble.
4. demcompile
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "d:\My
Documents\access\mayapp.mdb" /decompile

Both forms run separately fine.

Thanks.
 
Just a thought, but is there a circular reference going on here? I had
something similar happen once when I accidentally set a subforms control
source to equal the subform (for example [Forms]![frmMainForm]![Subform]).

Lee
 
I always do work in that way. For eg if i need to check something in
subform from mainform:

If Forms!tbl_PPVResearch!tbl_ValidDisputes!ListAccount.Value = 1 then
.........
end if


Just a thought, but is there a circular reference going on here? I had
something similar happen once when I accidentally set a subforms control
source to equal the subform (for example [Forms]![frmMainForm]![Subform]).

Lee

Anna said:
I just click on any of the field in subform.It gives that error and the
database is shutdown

Microsoft Access and windows has encountered a problem and needs to
close.We are sorry for the invonvenience. I did

following things but its a same problem.

1.I run Tools-Repair database but same problem.
2. Copy all files to a new databse but it wont work.
3. Copy whole form as a text file and then load it from that file but
still same proble.
4. demcompile
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "d:\My
Documents\access\mayapp.mdb" /decompile

Both forms run separately fine.

Thanks.
Click to expand...
Click to expand...
 
I always do work in that way. For eg if i need to check something in
subform from mainform:

If Forms!tbl_PPVResearch!tbl_ValidDisputes!ListAccount.Value = 1 then
.........
end if


Just a thought, but is there a circular reference going on here? I had
something similar happen once when I accidentally set a subforms control
source to equal the subform (for example [Forms]![frmMainForm]![Subform]).

Lee

Anna said:
I just click on any of the field in subform.It gives that error and the
database is shutdown

Microsoft Access and windows has encountered a problem and needs to
close.We are sorry for the invonvenience. I did

following things but its a same problem.

1.I run Tools-Repair database but same problem.
2. Copy all files to a new databse but it wont work.
3. Copy whole form as a text file and then load it from that file but
still same proble.
4. demcompile
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "d:\My
Documents\access\mayapp.mdb" /decompile

Both forms run separately fine.

Thanks.
Click to expand...
Click to expand...
 
Hi Anna,
I would start commenting out all of the event code in the SubForm but not the
event itself. If the problem goes away then uncomment your code until it
comes back. I would suspect code in the Current event but it might be
anywhere. I assume you can compile the code and you have checked for MISSING
references. I would also temporarily go to a code page and then
Tools>Options>General Tab and set to Break on All Errors.
I always do work in that way. For eg if i need to check something in
subform from mainform:

If Forms!tbl_PPVResearch!tbl_ValidDisputes!ListAccount.Value = 1 then
........
end if
Just a thought, but is there a circular reference going on here? I had
something similar happen once when I accidentally set a subforms control
Click to expand...
[quoted text clipped - 21 lines]
Click to expand...
 
Back
Top