Events in a Form have stopped working

  • Thread starter Thread starter Jack G
  • Start date Start date
J

Jack G

After working fine for months, one of the forms in my database will not
respond to any events (but all other forms in the database still work fine).
Any time I click on a textbox with an event I get,

"The expression On Click you entered as the event property setting produced
the following error: A problem occured while Project Tracker was
communicating with the OLE server or ActiveX Control."

I've checked every property I could think of both for the form itself and
for the textboxes. I've tried deleting and replacing textboxes, and I've
tried deleting and replacing the event codes, but to no avail.

Anyone know what this might be??

Jack
 
The form is probably corrupt. If you have a backup copy, it may be a good
idea to replace it. If not, you can try to repair it.

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
 
Thanks, Arvin.

Your're right, it must have been corrupted. Since it was a fairly simple
form, I just re-created it from scratch using the same control names as the
original, and then copied and pasted the code into the form from the
original form.

After verifying that the new form and its events worked, I replaced the
corrupt one with the new one, and all is working again.

Jack
 
Eric,

I did try compacting it with no success, but I didn't decompile and
recompile. But I'm not sure I know how to decompile??

I'd like to try that even though I've already fixed it by starting over on
the form. But this sounds useful in case it ever happens again.

Jack
 
Back
Top