By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Recordsets .. why the error message?

P: n/a
Help please .. going nuts. Using Access XP

Dim db As DAO.Database

Dim rec As DAO.Recordset

Set db = CurrentDb

Set rec = db.Openrecordset("tblAppointment")

DoCmd.GoToRecord , , 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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, 5 Feb 2004 04:38:37 -0000, "Geoff" <g.*****@ntlworld.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.GoToRecord does not work on a recordset
object? With recordsets you use rec.MoveLast.

-Tom.
Help please .. going nuts. Using Access XP

Dim db As DAO.Database

Dim rec As DAO.Recordset

Set db = CurrentDb

Set rec = db.Openrecordset("tblAppointment")

DoCmd.GoToRecord , , 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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.