Coo - the email bounced. Ok - contents of your email:
Originally Posted by Greenway
Private Sub Try_Click()
On Error GoTo Try_Error
'DAO objects to get the data
*Dim db As DAO.Database
Dim rs As DAO.Recordset
"User-defined type not defined" and the line with the star is
I am not so good with some code used in vb coding so I am not clear on
I am getting that error.
So can you assist me in correcting where I have gone wrong! Note that I
trying to use the code you provide in an access 2000 database.
Originally Posted by Poots
No probs :0)
This is common problem. Any code you use in VBA comes from a code library
(VBA, Excel etc). One of these libraries is the DAO library. You need to
point your project to the DAO library (refernce it).
Click Tools -> References and scroll down to Microsoft DAO 3.6 Object
Library (or similar) and select it.