Module doesn't recognize Nz from a query - why?? 2

[KHerm]

I just copied some queries, a macro and a module from one Access database to another. The macro calls a function from the module. The module opens the query. The query uses this format for a field:

Field_Heading: Nz(

.[COLUMN],0)

I can run the query just fine on it's own, but when the module calls it I get this error:

Run-time Error '3085':
Undefined function 'Nz' in expression.

It also works just fine in the first database.

What's missing??

Thanks for any help.

Ken

 

[ghubbell]

Hi Ken, please check via any module in your Db: Tools-References. Look for MS DAO 3.6 Object library on the list. If it's not there try adding it. If it is (well in both cases) make sure your Db will compile. No go? Move its priority on the list up a notch or two and try to compile again. Should do it. Gord
ghubbell@total.net

 

[KHerm]

Thanks Gord!

MS DAO 3.51 Object Library had been selected, and I had to uncheck that and check MS DAO 3.6. The priority was already as high as it would go. The module still didn't recognize Nz, so I recompiled the module. Still no go. Then I closed the database, restarted it, then it worked.

Thanks again!

Ken

 

[DonKsr]

I had a similar problem with a user defined function. Restarting the DB fixed my error 3085.