ACC: Same Named Module and Function Cause Error After Conversion

ID: Q148529

The information in this article applies to:

Microsoft Access versions 7.0, 97

SYMPTOMS

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

If you convert a database from Microsoft Access 2.0 to Microsoft Access 7.0 or Microsoft Access 97, and that converted database has a user-defined procedure and a module with the same name, you may receive the following error message when the procedure is run from an object's events.

In Microsoft Access 97:

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.

In Microsoft Access 7.0:

The expression [event name] you entered as the event property setting produced an error. There was an error compiling this function.

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

In Microsoft Access 97:

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

In Microsoft Access 7.0:

There was an error compiling this function. The Visual Basic module has a syntax error. Solution: Check the code and then recompile it.

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

Expected variable or procedure, not module.

These errors occur even if the procedure is not contained in the module with the same name.

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

NOTE: This behavior is exposed only when the function is initially run because Microsoft Access 7.0 and 97 do not load a module until a function or subroutine within the module is called.

CAUSE

This behavior is likely to occur after you convert a database from Microsoft Access version 2.0. Microsoft Access 7.0 and 97 do not allow a user-defined function and module to have 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.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new Microsoft Access 2.0 database, create a module, and type the following line in the Declarations section:


Option Explicit

Type the following procedure:


Function Test()
   MsgBox "I am working correctly"
End Function

Save the module as Test.

Create a new form and add the following command button. Then save the form as Test1:

Command button:
Name: Button0
Caption: My Button
OnClick: =Test()

Switch the Test1 form to Form view. Note that the button behaves as expected by displaying a message box when you click the button.

Quit Microsoft Access version 2.0.

Start Microsoft Access 97.

On the File menu, click Open, and select the database you created in step 1.

When prompted to Open or Convert the database, select Convert.

Open the Test1 form in Form view.

Click My Button. Note that you receive the error message mentioned in the "Symptoms" section.

Additional query words: conversion name

Keywords : kberrmsg kbprg MdlGnrl
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbprb