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:

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

An event for an ActiveX control uses OLE_COLOR for a parameter

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