A
Alex
Hi anyone,
Here what I have for you:
1 Dim db As Database
2 Dim rs As Recordset
3 Dim strSQL As String
4 strSQL = "SELECT * FROM tbl_Orders"
5 Set db = CurrentDb
6 Set rs = db.OpenRecordset(strSQL)
At line 6 it says: "Type Mismatch.." code 13.
All compiles fine, I have DAO 3.6 checked.
What is the problem?
P.S. it seems to me it does not even sees the CurrenDB..
Thanks for you help, Wizards.
Here what I have for you:
1 Dim db As Database
2 Dim rs As Recordset
3 Dim strSQL As String
4 strSQL = "SELECT * FROM tbl_Orders"
5 Set db = CurrentDb
6 Set rs = db.OpenRecordset(strSQL)
At line 6 it says: "Type Mismatch.." code 13.
All compiles fine, I have DAO 3.6 checked.
What is the problem?
P.S. it seems to me it does not even sees the CurrenDB..
Thanks for you help, Wizards.