Corruption, and now strange things happening ...

[justme]

I've been working on a major form with several tabs and subforms for awhile
now. My database "encountered an error" yesterday when running the form
while testing and I was locked out. I followed several steps in a
comprehensive list of things to try to open it that I found on this site. I
ended up getting almost to the end of the list, which was to create a new
blank db and import everything except the problem subform. I then imported a
previous version of that form and started working on it again. Here is what
I have found from testing:




The problem all boiled down to one textbox, which, when removed, clears up
the whole problem. When it is there, the db gets locked out.

This subform has only 8 controls:
txtStyle (text), which is actually in the header in case the form needs
to be run on its own.
CommentDate (formatted with just the weekday)
txtCommentDate (medium date & time)
CommentReg (integer)*
txtCommentReg (unbound)
Style (text, FK)
CommentOmittedFromReport (checkbox)

txtCommentReg is the problem textbox. In it I have:
=IIf([CommentReg]=1,"domestic","international")

I have this same exact setup with a different query in another subform of
the parent that works just fine. I have tried deleting the problem box and
re-creating it. As soon as I put that expression in and run it the db closes.
I have looked in the parent form for references to the controls on the
subform which could be causing it, but there are none except the parent/child
link. The wierd thing is that even with the problem textbox, the form will
run ok by itself, but not once it is opened from within the parent form.

So now, the two other problems I am noticing with the new database with
everything imported is:

1) some of the checkboxes have lime green checks instead of black checks. I
have no idea why.

2) In the parent form, I had used a colored rectangle behind the tab control
to change the color of the form. After importing a working form from a
previous database version, the color does not show. It shows white. I check
everything (transparency of the tab control, color of the rectangle, etc...)
I tried re-creating a new rectangle from scratch, which didn't work. Tthen
tried importing the other working one again. It works in the old db but as
soon as it is imported, the color does not show through.

 

[Allen Browne]

That's good trouble-shooting! You've (almost) rescued the database, and you
have pin-pointed the remaining problems. No doubt it has involved quite a
bit of time, but well done.

To address the problem with the tab control and check box, try unchecking
the box under:
Tools | Options | Forms | Use Windows Themed controls.
The themed controls do mess up the transparencey of tab controls, and do
affect check boxes as well (Null doesn't show as a separate state.)

The problem with the text box is more enegmatic. It's like Access is
confused about and remembering (mis-remembering?) an old name. That can
happen in Name AutoCorrect is turned on. Double-check you have unchecked the
boxes under:
Tools | Options | General | Name AutoCorrect.
Then compact the database, decompile, and compact again.

If that doesn't solve the problem, post back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I've been working on a major form with several tabs and subforms for
awhile
now. My database "encountered an error" yesterday when running the form
while testing and I was locked out. I followed several steps in a
comprehensive list of things to try to open it that I found on this site.
I
ended up getting almost to the end of the list, which was to create a new
blank db and import everything except the problem subform. I then
imported a
previous version of that form and started working on it again. Here is
what
I have found from testing:

The problem all boiled down to one textbox, which, when removed, clears up
the whole problem. When it is there, the db gets locked out.

This subform has only 8 controls:
txtStyle (text), which is actually in the header in case the form needs
to be run on its own.
CommentDate (formatted with just the weekday)
txtCommentDate (medium date & time)
CommentReg (integer)*
txtCommentReg (unbound)
Style (text, FK)
CommentOmittedFromReport (checkbox)

txtCommentReg is the problem textbox. In it I have:
=IIf([CommentReg]=1,"domestic","international")

I have this same exact setup with a different query in another subform of
the parent that works just fine. I have tried deleting the problem box
and
re-creating it. As soon as I put that expression in and run it the db
closes.
I have looked in the parent form for references to the controls on the
subform which could be causing it, but there are none except the
parent/child
link. The wierd thing is that even with the problem textbox, the form
will
run ok by itself, but not once it is opened from within the parent form.

So now, the two other problems I am noticing with the new database with
everything imported is:

1) some of the checkboxes have lime green checks instead of black checks.
I
have no idea why.

2) In the parent form, I had used a colored rectangle behind the tab
control
to change the color of the form. After importing a working form from a
previous database version, the color does not show. It shows white. I
check
everything (transparency of the tab control, color of the rectangle,
etc...)
I tried re-creating a new rectangle from scratch, which didn't work.
Tthen
tried importing the other working one again. It works in the old db but
as
soon as it is imported, the color does not show through.

 

[justme]

That's good trouble-shooting!

Wow, I consider that a high compliment, coming from you, Mr. Browne!

I can't believe the accuracy of your assessments from just my little blurb.
Both fixes you gave me worked like *MAGIC* I am much indebted to you for
these two lessons, now easily learned!