John thomas
Registered User.
- Local time
- Today, 06:02
- Joined
- Sep 4, 2012
- Messages
- 206
I m new to record sets and need help Please
The code underneath works well in a unsplit data base but in my split data base does not work
I tried to find the answer and it seems you have to alter the code for split databases
Would it be possible for someone to alter this code so that it works
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim rsFiltered As DAO.Recordset
Dim strSQL As String
Dim i As Integer
strSQL = "SELECT tblClass.ClassID, tblClass.ClassDate, tblClass.ClassDate;"
Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
Many Thanks John
The code underneath works well in a unsplit data base but in my split data base does not work
I tried to find the answer and it seems you have to alter the code for split databases
Would it be possible for someone to alter this code so that it works
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim rsFiltered As DAO.Recordset
Dim strSQL As String
Dim i As Integer
strSQL = "SELECT tblClass.ClassID, tblClass.ClassDate, tblClass.ClassDate;"
Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
Many Thanks John