L
leon
I have written the undermentioned function but it won't work and i do
not know why . it returns the following error:
user defined type not defined
and it highlights the line: Dim db as database.
does anybody know what is wrong??
Public Function test()
Dim db As Database
Dim rs As Recordset
Dim strSQL As String
strSQL = "Select * from tbl_ic_matchers"
Set db = CurrentDb()
Set rs = db.OpenRecordset(strSQL)
End Function
not know why . it returns the following error:
user defined type not defined
and it highlights the line: Dim db as database.
does anybody know what is wrong??
Public Function test()
Dim db As Database
Dim rs As Recordset
Dim strSQL As String
strSQL = "Select * from tbl_ic_matchers"
Set db = CurrentDb()
Set rs = db.OpenRecordset(strSQL)
End Function