James, I did not have a filter to do that, so I used NotePad Lite and
converted the text to ASCII which I think would achieve the same thing. I
have now tried both your suggestions, and unfortunately, Access is still
randomly closing when I open the form. I thought I may have had too many
controls in the form and have just removed about 7 controls that were left
overs from early development, but alas, still the same problem. I forgot to
mention that I have used Total Access Analyser on this form and it reports
no errors. I am afraid that I might have to build this form from scratch
and that would be a very large task as it is quite a complex form. The
worry is that if I invest the time to do that, it might still have a
problem, as every thing I have tried so far has failed to fixed it. I have
also tried repairing the Access installation and running it on another
computer, so at least I can eliminate any worries that it is either my copy
of A2k or something computer specific.
Oh, well, back to the drawing board.
dixie
<ji********@compumarc.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
dixie wrote: I have an Access 2000 form which has been running OK for a long time.
Lately, it is playing up and doing things like causing Access to
close suddenly when the form is opened or when saving the form in design
view after a change. Today, I got the following message from the form
when using a combo box.
"The expression After Update you entered as the event property
setting produced the following error: A problem occurred while Microsoft
Access was communicating with the OLE server or ActiveX Control."
It seems like the form is somehow corrupted. I have tried creating a
new database container and importing a new version of the form. I have
gone back about 2 months of development and redeveloped the form up to its
current state, yet the problem persists.
There is no such thing as an Access virus is there? Something is
wrong and it is driving me around the twist.
dixie
Hi Dixie,
I certainly sympathize with your frustrating problem. I had a similar
problem when Access somehow embedded a control character into my form
code. Perhaps try copying all the code behind your form into a .txt
file and running it through a filter that strips out all unprintable
characters. Make sure the filter counts how many unprintable
characters were omitted. If you catch any you've found the problem.
Also try Decompile (after compacting a backup) before doing all that.
James A. Fortune