Error message previously working program - Added to it - wrecked,,it

[Avid Fan]

I was doing so well.

I have a form with a tab control and I got the first two tabs working
fine. The last thing I did was try and copy a group of controls into
another tab. I have deleted the new tab but no change.


I keep getting this error message. Sometimes instead of "Onload" it
says "after update" sometimes even "Keypress".

Error message

*********************************************************************
The expression On Load you entered as the Event property produced the
following: A problem occurred while Microsoft Access was communicating
with OLE Server or Active X control


This error occurs when an event has failed to run because Microsoft
Office Access cannot evaluate the location of the logic for the event.
For example, if the OnOpen property of a form is set to =[Field], this
error occurs because Access expects a macro or event name to run when
the event is fired.
*******************************************************************

I have commented out the form_load and listbox's after update events but
to no avail. Something is triggering it and I can't find the code.

Any Ideas please

 

[Marshall Barton]

I have a form with a tab control and I got the first two tabs working
fine. The last thing I did was try and copy a group of controls into
another tab. I have deleted the new tab but no change.

I keep getting this error message. Sometimes instead of "Onload" it
says "after update" sometimes even "Keypress".

Error message

*********************************************************************
The expression On Load you entered as the Event property produced the
following: A problem occurred while Microsoft Access was communicating
with OLE Server or Active X control


This error occurs when an event has failed to run because Microsoft
Office Access cannot evaluate the location of the logic for the event.
For example, if the OnOpen property of a form is set to =[Field], this
error occurs because Access expects a macro or event name to run when
the event is fired.
*******************************************************************

I have commented out the form_load and listbox's after update events but
to no avail. Something is triggering it and I can't find the code.

Sounds like something in the copying went south on you.

It also seems like you are not clear on the distinction
between the event **properties** (eg. OnLoad, OnClick, etc)
and the corresponding event **procedures** (eg. Sub
Form_Load() ...)

That error message may be misleading, but it usually means
that the event **property** has garbage (maybe only
mispelled) in it. Some folks have gotten that kind of
message when they mistakenly entered code into the
**property**. Note that the event properties normally
contain the text [Event Procedure] and Access determines
the name of the procedure from the name of the object with
the event and the name of the property.