Hi Guys,
I am stuck on this one.
If I try the SQL:
I get the expeced 1500 odd records.
If I try:
prints to console 1 (which is empty anyway).
I am not sure how to debug from here.
Tables are split if thats relevant.
I am stuck on this one.
If I try the SQL:
Code:
SELECT * FROM MAS
I get the expeced 1500 odd records.
If I try:
Code:
Dim rs As DAO.RecordSet
Dim db As DAO.Database
Dim strSQL As String
strSQL = "SELECT * FROM MAS"
Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
debug.print(rs.RecordCount)
prints to console 1 (which is empty anyway).
I am not sure how to debug from here.
Tables are split if thats relevant.