Microsoft KB Archive/210098

= ACC2000: Same Named Module and Procedure Causes Errors =

Article ID: 210098

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q210098



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

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



SYMPTOMS
When you run a procedure from an object's events, you may receive the following error message:

The expression [event name] you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Access can't find.

If you use the RunCode action in a macro to call a function, you may receive the following error message:

The expression you entered has a function name that Microsoft Access can't find.

If you try to run a procedure from the Immediate window, you may receive the following error message:

Compile Error:

Expected variable or procedure, not module.

NOTE: All the modules in the database or project will appear to compile successfully.



CAUSE
A user-defined function or a subroutine have the same name as a module. These errors occur even if the procedure is not contained in the module with the same name.



RESOLUTION
Change the name of the module so that it is different from the name of any procedure that you have in the database or project.



Steps to Reproduce Behavior
 Create a new Microsoft Access database, and then create a module.  Type the following procedure: Function Test MsgBox "Does this work correctly?" End Function  Save the module as Test.  Type the following line in the Immediate window, and then press ENTER: Test 

Additional query words: conversion name prb

Keywords: kberrmsg kbprogramming kbprb KB210098

-

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

© Microsoft Corporation. All rights reserved.