ACC2000: Error Message: The Expression May Not Result in the Name...

ID: Q224344


The information in this article applies to:
  • Microsoft Access 2000

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).


ERROR MESSAGE

When you run a procedure, you may receive the following error message:

The expression <expression> you entered as the event property setting produced the following error:

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: Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to enable this functionality for this and other error messages in Microsoft Office 2000, please download the Microsoft Office 2000 Customizable Alerts file from the Microsoft Office Update Web site at the following address:
http://officeupdate.microsoft.com/2000/downloadDetails/alerts.htm
NOTE: If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.


CAUSE

You may receive this error for one of the following reasons:


WHAT TO TRY

A user-defined function or a subroutine has the same name as a module

This type of error can occur even if the procedure is not contained in the module with the same name. To avoid this type of error, change the name of the procedure or function so that it is different from the name of any module that you have in the database or project.

Back to Top

An event for an ActiveX control uses OLE_COLOR for a parameter

When handling an event for an ActiveX control in a form, you may see this error if any of the events use OLE_COLOR for a parameter.

If you have the source code for the control, change the parameter that is using OLE_COLOR to a different type, such as Long. Otherwise, you cannot catch the event of the control.

Back to Top

Additional query words: OFF2000

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: September 15, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.