Error Message - problem with OLE Server or ActiveX Control - HELP!

[Scitea]

Hi guys, I hope someone can help me with this as I have got no idea what has
happened (ow what I have done if it's because of me!)

I have created a form which includes fields from 3 different tables, and
have set up the form to be filtered to 1 records from 3500 so you can easily
see the details that are needed without trawling through everything.

It's all working fine, but now I have added a 'Close Form' Command button,
and now everytime I click the command button to close the form the following
error message appears;

"The expression On Click you entered as the event property setting produces
the following error: A Problem occured while Microsoft Access was
communicating with the OLE server of ActiveX Control"

I can't understand it as all the other 'Close Form' commands on my other
forms work fine and I haven't changed the expression/event proceedure at all,
just added the button.........................

Aargh! Help please! It's driving me nuts!

Jenni x

 

[Al Campagna]

Scitea,
Hmmmm... this feels like "deja vue"... all over again! :-D

I had this exact problem yesterday. (Access 2003) A form that was
working fine, started to post the same error message, along with suggested
fixes that don't work.

I narrowed it down to the form's Current event... which... like your
code... was perfectly legitimate.

Sounds like your form is corrupted. Some possible solutions...
1. Check your references, just to be sure.
2. Try a Compact and Repair
3. Create a new Blank form, and copy and paste all your form
objects to the new form
4. Do the same with all your module/macro code.
That fixed my problem...
A fellow MVP suggested a Decompile - Compact - Recompile, but he wasn't
sure if that was a cure or not. Try mine first... then give that a go.\ if
you still have the problem.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Scitea]

Thanks for that, I ended up creating a new form and pasting the contents to
the new form and the 'Close Form' button worked fine after that.

Dratted glitches!

Sci x