When I try to declare a DAO.Recordset I'm getting an error saying user-defined type not defined. I have a vague recollection of having to change a setting somewhere for this, but can't find it now .... help!

Cheers
Donna

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

Add a reference to
Microsoft DAO 3.6

More info on references:
http://allenbrowne.com/ser-38.html

--
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.

"Donna Watling" <Donna (E-Mail Removed)> wrote in message
newsC0E1125-74DF-40DF-8738-(E-Mail Removed)...
> When I try to declare a DAO.Recordset I'm getting an error saying
user-defined type not defined. I have a vague recollection of having to
change a setting somewhere for this, but can't find it now .... help!
>
> Cheers
> Donna

Cheers! (working now)

"Allen Browne" wrote:

> From a code window, choose References on the Tools menu.
>
> Add a reference to
> Microsoft DAO 3.6
>
> More info on references:
> http://allenbrowne.com/ser-38.html
>
> --
> 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.
>
> "Donna Watling" <Donna (E-Mail Removed)> wrote in message
> newsC0E1125-74DF-40DF-8738-(E-Mail Removed)...
> > When I try to declare a DAO.Recordset I'm getting an error saying
> user-defined type not defined. I have a vague recollection of having to
> change a setting somewhere for this, but can't find it now .... help!
> >
> > Cheers
> > Donna
>
>
>