I get a "Sub or Function not defined" message when I try to use the IsLoaded function.

The IsLoaded function is a sample Function procedure included with the Northwind sample database, and not a built-in Microsoft Visual Basic function. To use the IsLoaded function in your database, you must copy it to your database.

1. Open the Northwind sample database.

   How?

   1. On the Help menu, point to Sample Databases, and then click the database you want to open.
   2. If the database isn't currently installed, click Yes to install it now.
   Note   If you don't see a list of databases when you point to Sample Databases, you can install them by double-clicking Add/Remove Programs in Windows Control Panel and running Office Setup.

    

2. In the Database window of Northwind, click Modules under Objects.

3. Select Utility Functions, and then click the Design on the Database window toolbar.

4. Highlight and copy the function.

5. Close the Northwind sample database.

6. In the Database window of your database, click Modules under Objects and then click New on the Database window toolbar.

7. Paste the code into the module.

8. Close and save the new module.