Recordsets .. why the error message?

[Geoff]

Help please .. going nuts. Using Access XP





Dim db As DAO.Database

Dim rec As DAO.Recordset



Set db = CurrentDb

Set rec = db.Openrecordse t("tblAppointme nt")



DoCmd.GoToRecor d , , acLast



etc...





Can't get past the first line of code. This Error message is blocking me
from working with Recordsets?



Compile Error: User defined type not defined. WHY???



Thanks

Geoff

[Tom van Stiphout]

Re: Recordsets .. why the error message?

On Thu, 5 Feb 2004 04:38:37 -0000, "Geoff" <g.friar@ntlwor ld.com>
wrote:

Interesting spacing...

You apparently don't have a reference set to the DAO library. Code
window / Tools / References / Microsoft DAO 3.6 Object Library.

BTW, you know that DoCmd.GoToRecor d does not work on a recordset
object? With recordsets you use rec.MoveLast.

-Tom.


[color=blue]
>Help please .. going nuts. Using Access XP
>
>
>
>
>
>Dim db As DAO.Database
>
>Dim rec As DAO.Recordset
>
>
>
> Set db = CurrentDb
>
> Set rec = db.Openrecordse t("tblAppointme nt")
>
>
>
> DoCmd.GoToRecor d , , acLast
>
>
>
>etc...
>
>
>
>
>
>Can't get past the first line of code. This Error message is blocking me
>from working with Recordsets?
>
>
>
>Compile Error: User defined type not defined. WHY???
>
>
>
>Thanks
>
>Geoff
>[/color]