Error Message OnClick

[Guest]

I get the following message on one form with several command buttons that
Open other Forms. The message is:

The expression On Click 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 a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

Now, I created the Command Button and used the Wizard to set up the OpenForm
function. It ran perfectly fine, then all of a sudden stopped working. I
have other Forms with other Command Buttons that do the same thing Open up
other Forms, and they're working. Help Please.

 

[Steve Huff]

If it worked fine and you made no changes it could be a corruption issue.
Make a back up of the database then do a Compact/Repair on it. If that does
not work post the actual VBA code behind the command button for us to see.

 

[Guest]

I tried Compacting and Repairing it didn't work. Since the code was so
simple, I just deleted the code altogether and the Form itself and did it
again, so far no issues, it's just I'm a contractor here, and I'd hate for
that problem to come up after I'm done here. Thank you though.

If it worked fine and you made no changes it could be a corruption issue.
Make a back up of the database then do a Compact/Repair on it. If that does
not work post the actual VBA code behind the command button for us to see.

--
_______________________
Steve Huff
http://www.huffs.us
Generic email: null(removethis)@huffs.us

I get the following message on one form with several command buttons that
Open other Forms. The message is:

The expression On Click 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 a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

Now, I created the Command Button and used the Wizard to set up the
OpenForm
function. It ran perfectly fine, then all of a sudden stopped working. I
have other Forms with other Command Buttons that do the same thing Open up
other Forms, and they're working. Help Please.

 

[Jochen]

I hava had the same problem about 3 times now when creating new command
buttons.
What I did to solve it was the following:

Close your DB
create a new empy DB
Import EVERYTHING from your old DB (tables, forms, queries, modules,
reports,....)
That's it.

I haven't figured out yet why this problem occurs, but this is -for now -
the only way i found how to solve it

I tried Compacting and Repairing it didn't work. Since the code was so
simple, I just deleted the code altogether and the Form itself and did it
again, so far no issues, it's just I'm a contractor here, and I'd hate for
that problem to come up after I'm done here. Thank you though.

If it worked fine and you made no changes it could be a corruption issue.
Make a back up of the database then do a Compact/Repair on it. If that does
not work post the actual VBA code behind the command button for us to see.

--
_______________________
Steve Huff
http://www.huffs.us
Generic email: null(removethis)@huffs.us

I get the following message on one form with several command buttons that
Open other Forms. The message is:

The expression On Click 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 a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

Now, I created the Command Button and used the Wizard to set up the
OpenForm
function. It ran perfectly fine, then all of a sudden stopped working. I
have other Forms with other Command Buttons that do the same thing Open up
other Forms, and they're working. Help Please.