User Defined type not defined

T

Tim

I have this statment at the start of a module:

Dim DBS as Database

....but it does not recognise this type...which is weird
as it does in other applications that I have. Just re-
installed everything to be sure (Access 2002 SP3) but
still have the same problem.

Is there a way around this? Is this common?

TIA
Tim
 
S

Steve Schapel

Tim,

In your module, go to the Tools|References menu. There should be a
Reference set to Microsoft DAO 3.6 Object Library. If there isn't, find
it on the list, and select it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate XL cells with values from a user defined type 3
File in use by another application or user 2
Can't Compile: User-defined type not defined 2
Need help with user-defined types 1
QueryDef is a user-defined type? 3
Office 2003 SP3 broke my vba code "user-defined type not defined" 3
Help --> Compile Error - User defined type not defined 2
User-Defined type not defined 6

Top