"User-defined type not defined"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

an - 16 Jan 2006 02:35 GMT

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

Reply to this Message

Dave Patrick - 16 Jan 2006 03:24 GMT

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

Signature

Regards,

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

| Hello!
|
[quoted text clipped - 13 lines]
| Thanks in advance.
| an

Reply to this Message

an - 16 Jan 2006 12:27 GMT

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

> From any module Tools|References and make sure you have DAO 3.6 checked.
>
[quoted text clipped - 17 lines]
> | Thanks in advance.
> | an

Reply to this Message

Dave Patrick - 16 Jan 2006 14:13 GMT

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

Signature

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
[quoted text clipped - 4 lines]
| (?)
| an

Reply to this Message

an - 16 Jan 2006 17:08 GMT

Thanks for yours ideas.

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

an

> The next step is to open any code module then Tools|References and make sure
> you have DAO 3.6 Object Library checked
[quoted text clipped - 7 lines]
> | (?)
> | an

Reply to this Message

Allen Browne - 16 Jan 2006 03:27 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello!
>
[quoted text clipped - 10 lines]
>
> Dim db As DAO.Database

Reply to this Message

an - 16 Jan 2006 12:27 GMT

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

> From the code window, choose References on the Tools menu.
>
[quoted text clipped - 18 lines]
> >
> > Dim db As DAO.Database

Reply to this Message

Douglas J Steele - 16 Jan 2006 13:03 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> AB,
>
[quoted text clipped - 29 lines]
> > >
> > > Dim db As DAO.Database

Reply to this Message

an - 16 Jan 2006 17:08 GMT

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

> 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
[quoted text clipped - 36 lines]
> > > >
> > > > Dim db As DAO.Database

Reply to this Message

Allen Browne - 16 Jan 2006 13:03 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> AB,
>
[quoted text clipped - 29 lines]
>> >
>> > Dim db As DAO.Database

Reply to this Message

an - 16 Jan 2006 17:04 GMT

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

> I don't understand:
> Tools\References is empty
[quoted text clipped - 40 lines]
> >> >
> >> > Dim db As DAO.Database

Reply to this Message