mtairhead
Registered User.
- Local time
- Today, 06:25
- Joined
- Oct 17, 2003
- Messages
- 138
I'm having a problem with an adapted VBA script. I just want to loop through the recordset, but Access keeps giving me grief.
The error I get is: "Compile error: User-defined type not defined"
Well, dang. What's that mean? I found a thread or two with similar problems, and the diagnosis seemed to involve placing "DAO." in front of "database" and "recordset" when the variables are dimmed. Of course, this code snippet already does that...
Thanks for any help you can provide.
~Andrew
PHP:
Dim dbs As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("(02)Unique Merchants")
rs.MoveFirst
Do While Not rs.EOF
MsgBox ("Test to see if actually looping. One will appear for each record.")
rs.MoveNext
Loop
End Sub
The error I get is: "Compile error: User-defined type not defined"
Well, dang. What's that mean? I found a thread or two with similar problems, and the diagnosis seemed to involve placing "DAO." in front of "database" and "recordset" when the variables are dimmed. Of course, this code snippet already does that...
Thanks for any help you can provide.
~Andrew