Need Help ASAP Please!

[CS CS via AccessMonster.com]

Hi,

I'm facing this problem whenever I try to click on any button on my access
system. I get the following error message:

"" The expression on Click you entered as the event
property setting producedthe 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 a user
defined function, or [Event Procedure].

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

Note that the system works fine on another machine, but not on my computer!

any help will be very much appreciated!

 

[MacDermott]

When code runs on one machine, but not on another, it's most often a
question of references. From any code window, click Tools - References and
look for items marked MISSING. Remove the check in front of such
references. If the code still won't run, go back and re-create the
references.

HTH

 

[Guest]

Hi, i'm having the same problem with an mde front end on 2 pc's, how can i
find out which references are missing on thise pc's since the mde file will
not allow me to see the references, also i'ce used the same package on others
pc's whitout a problem. thanks in advance

When code runs on one machine, but not on another, it's most often a
question of references. From any code window, click Tools - References and
look for items marked MISSING. Remove the check in front of such
references. If the code still won't run, go back and re-create the
references.

HTH

Hi,

I'm facing this problem whenever I try to click on any button on my access
system. I get the following error message:

"" The expression on Click you entered as the event
property setting producedthe 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 a user
defined function, or [Event Procedure].

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

Note that the system works fine on another machine, but not on my computer!

any help will be very much appreciated!

 

[Allan Murphy]

Run the master copy, the one you used to create the mde, open up a module or
form code then check for missing references.

--
Allan Murphy
Email: (e-mail address removed)

Hi, i'm having the same problem with an mde front end on 2 pc's, how can i
find out which references are missing on thise pc's since the mde file will
not allow me to see the references, also i'ce used the same package on others
pc's whitout a problem. thanks in advance

When code runs on one machine, but not on another, it's most often a
question of references. From any code window, click Tools - References and
look for items marked MISSING. Remove the check in front of such
references. If the code still won't run, go back and re-create the
references.

HTH

Hi,

I'm facing this problem whenever I try to click on any button on my access
system. I get the following error message:

"" The expression on Click you entered as the event
property setting producedthe 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 a user
defined function, or [Event Procedure].

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

Note that the system works fine on another machine, but not on my computer!

any help will be very much appreciated!

 

[Guest]

Hi Allan, thanks for the prompt response, i tried it but it didn't allow me
to eneter to the application, because it has an autoexec macro. the execution
stops rigth there and the only option that i get it's to close the
application, if i run the mde the utoexec runs and it shows the main
switchboard but when i click one of the choices in it then is when it fails
and it gives the error message.

Run the master copy, the one you used to create the mde, open up a module or
form code then check for missing references.

--
Allan Murphy
Email: (e-mail address removed)

Hi, i'm having the same problem with an mde front end on 2 pc's, how can i
find out which references are missing on thise pc's since the mde file will
not allow me to see the references, also i'ce used the same package on others
pc's whitout a problem. thanks in advance

When code runs on one machine, but not on another, it's most often a
question of references. From any code window, click Tools - References and
look for items marked MISSING. Remove the check in front of such
references. If the code still won't run, go back and re-create the
references.

HTH

message Hi,

I'm facing this problem whenever I try to click on any button on my access
system. I get the following error message:

"" The expression on Click you entered as the event
property setting producedthe 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 a user
defined function, or [Event Procedure].

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

Note that the system works fine on another machine, but not on my
computer!

any help will be very much appreciated!