John thomas
Registered User.
- Local time
- Today, 11:16
- Joined
- Sep 4, 2012
- Messages
- 206
Hi
im New to record sets
and have copied this code as a test
Option Explicit
Public Sub LoadArray()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("chimneysweep")
With rs
Debug.Print .RecordCount
.Close
End With
Set rs = Nothing
Set db = Nothing
In my immediate windoww it shows 1 record there are in fact 321 what am i doing wrong
I have tried different table still it only returns 1 record
many thanks john
im New to record sets
and have copied this code as a test
Option Explicit
Public Sub LoadArray()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("chimneysweep")
With rs
Debug.Print .RecordCount
.Close
End With
Set rs = Nothing
Set db = Nothing
In my immediate windoww it shows 1 record there are in fact 321 what am i doing wrong
I have tried different table still it only returns 1 record
many thanks john