object exists

[Guest]

i have a module and a function in it called object exists. it works great in
one of my databases but in another it does not work. its exactly the same in
both databases. when i try to run a macro, it keeps coming up with an error.
it goes right to the function and highlights the Dim db as database. gives
me an errror message compile error user defined type not defined. any idea
why?

 

[David C. Holley]

Check the references you're probably missing one. Specifically, the ref
for the type of code that you're using to access the database - ADO or
DAO. Once you've got the ref fixed (if there's one missing), I would go
ahead and qualify the DIM as in Dim db as DAO.Database or ADO.Database