Error message

[Scott]

I have a front-end and back-end databases of Access 2003. Recently, I added
an event procedure of before update on a text box of an input form. I
tested correctly on one workstation and put back onto the file server. Most
of workstations generated the below error message once I enter data on that
textbox and hit enter. A few workstations work correctly. Can someone
advise the possible causes and fixes.

Microsoft Office Access


The expression Before Update you entered as the event property setting
produced
the following error! A problem occurred while Microsoft Office Access was
communicating with the OLE server or ActiveX Control.

*The expression may not result in the name of a Macro, the name of User
Defined Function or [Event Procedure].

*There may have been an error evaluating the function, event or macro."

Thanks,

Scott

 

[Marshall Barton]

I have a front-end and back-end databases of Access 2003. Recently, I added
an event procedure of before update on a text box of an input form. I
tested correctly on one workstation and put back onto the file server. Most
of workstations generated the below error message once I enter data on that
textbox and hit enter. A few workstations work correctly. Can someone
advise the possible causes and fixes.

Microsoft Office Access
The expression Before Update you entered as the event property setting
produced
the following error! A problem occurred while Microsoft Office Access was
communicating with the OLE server or ActiveX Control.

*The expression may not result in the name of a Macro, the name of User
Defined Function or [Event Procedure].

*There may have been an error evaluating the function, event or macro."

When something works on one machine, but not on another
machine, it's almost always a References problem. Either a
library has not been installed, it's installed in a
different folder, or it's a different version. See Allen
Browne's article at http://allenbrowne.com/ser-38.html for
more details and tips.

 

[Scott]

Marshall,

Thanks for advice. I checked that there was no missing reference and tried
to uninstalled and reinstalled DAO without any effect. Bad luck!

Scott

I have a front-end and back-end databases of Access 2003. Recently, I
added
an event procedure of before update on a text box of an input form. I
tested correctly on one workstation and put back onto the file server.
Most
of workstations generated the below error message once I enter data on
that
textbox and hit enter. A few workstations work correctly. Can someone
advise the possible causes and fixes.

Microsoft Office Access
The expression Before Update you entered as the event property setting
produced
the following error! A problem occurred while Microsoft Office Access was
communicating with the OLE server or ActiveX Control.

*The expression may not result in the name of a Macro, the name of User
Defined Function or [Event Procedure].

*There may have been an error evaluating the function, event or macro."

When something works on one machine, but not on another
machine, it's almost always a References problem. Either a
library has not been installed, it's installed in a
different folder, or it's a different version. See Allen
Browne's article at http://allenbrowne.com/ser-38.html for
more details and tips.