"User-defined type not defined"

[Guest]

Hello!

In Access2k, I have a form with 3 comboboxes to sequentialy filter records.
When I click on command button to open another form based in a query, return
an error message:

"Compile error.
User-defined type not defined"

and highlighted de first code row:

Dim db As DAO.Database

I would like help for this.

Thanks in advance.
an

 

[Dave Patrick]

From any module Tools|References and make sure you have DAO 3.6 checked.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hello!
|
| In Access2k, I have a form with 3 comboboxes to sequentialy filter
records.
| When I click on command button to open another form based in a query,
return
| an error message:
|
| "Compile error.
| User-defined type not defined"
|
| and highlighted de first code row:
|
| Dim db As DAO.Database
|
| I would like help for this.
|
| Thanks in advance.
| an
|
|

 

[Allen Browne]

From the code window, choose References on the Tools menu.

Scroll down, and check the box beside:
Microsoft DAO 3.6 Library

More info on the references you need for each version of Access:
http://allenbrowne.com/ser-38.html

 

[Guest]

Thanks for your reply and sorry for my delay.
1 - Tools\References is empty
2 - In Start\Run:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
return: Sucedded
3 - In code, don't recognized DAO
(?)
an

 

[Guest]

AB,

Thanks for your reply and sorry for my delay.
1 - Tools\References is empty
2 - In Start\Run:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
return: Sucedded
3 - In code, don't recognized DAO
(?)
an

 

[Douglas J Steele]

What do you mean by "Tools\References is empty"? Are you saying that there
is nothing visible when you go to the dialog? Is this the case for all of
your databases, or just this particular one?

Hopefully you realize that you were told to go into the VB Editor to open
this dialog. Make sure that no code is running when you do it.

 

[Allen Browne]

I don't understand:
Tools\References is empty

Do you mean to say that there are no items to choose from?

Are you logged in as a local computer administrator, or only as a limited
user?

There should be several dozen items to choose from, and you *must* have the
Access and VBA libraries selected or nothing is going to work properly.

 

[Dave Patrick]

The next step is to open any code module then Tools|References and make sure
you have DAO 3.6 Object Library checked

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Thanks for your reply and sorry for my delay.
| 1 - Tools\References is empty
| 2 - In Start\Run:
| regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
| return: Sucedded
| 3 - In code, don't recognized DAO
| (?)
| an

 

[Guest]

Thanks for yours ideas.
When it said empty wanted to say "extinguished".

Problem decided with the reinstallation of the Officce 2k for system
administrator...
Debtor for your aid.

an

 

[Guest]

Thanks for yours ideas.
When it said empty wanted to say "extinguished".

Problem decided with the reinstallation of the Officce 2k for system
administrator...
Debtor for your aid.

an

 

[Guest]

Thanks for yours ideas.

Problem decided with the reinstallation of the Officce 2k for system
administrator...
Yhanks too.

an