Compile Error on Autoexec macro?? 1

[quest4]

This is a strange one in deed. I have a dbase that I use an autoexec macro on with a public function, RunOncez() where I dim dbs As Database. I mase a second dbase for archiving some of the data from the first dbase. I imported the macro and the module from the first dbase to the second dbase and did not change any names. I just tried to open the second dbase and I get this error message:
"Compile error: User-defined type not defined" the debugger has the Dim dbs As Database hi-lited. Any ideas on this erroe? It works great in the first dbase, I can not understand why it doesn't work in the second dbase and no they are not in the same directory. Any ideas and hopefully solutions will be greatfully appreciated. Thanks in advance.

 

[jebry]

Hi!

You need to set a reference to the DAO library. Go to the VB window, select Tools - References. Find the reference to DAO 3.6 and check it. Now use the arrow keys and move the reference up until it is above the reference to the ADO object library. Alternatively to moving the DAO reference up, you can change your dim statements to read:

Dim dbs As DAO.Database and
Dim rst As DAO.Recordset

hth
Jeff Bridgham
bridgham@purdue.edu

 

[quest4]

Jeff, That did the trick. Thanks a lot.