Microsoft KB Archive/224344

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

Article ID: 224344

Article Last Modified on 12/2/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q224344



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

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



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

The 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://www.microsoft.com/downloads/details.aspx?FamilyID=8FBEE1D3-C5BB-4A36-A2F7-DC63DE2A818C

NOTE: If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.



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.

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.

Additional query words: OFF2000

Keywords: kbdownload kbprb KB224344

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.