ACC: Same Named Module & Function Cause Error After Conversion

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

If a database that has been converted from Microsoft Access 2.0 to Microsoft Access 7.0 or Microsoft Access 97 contains a user-defined procedure and a module with identical names, 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.

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

In Microsoft Access 97:

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

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

   Expected variable or procedure, not module.

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, which does allow a user-defined function and module to have the same name.

MORE INFORMATION

Steps to Reproduce Behavior

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

         Option Explicit
   

2. Type the following procedure:

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

3. Save the module as Test.

4. Create the following blank form and save it as Test1:

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

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

6. Quit Microsoft Access version 2.0.

7. Start Microsoft Access 97.

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

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

10. Open the Test1 form in Form view.

11. Click My Button. Note that you receive the error message mentioned

        in the "Symptoms" section.