I'm just again getting back into Access after nearly six years and unfortunately starting from square one.
Problem: The recordset loop only populates the first record of the table although the code loops properly. Using the immediate window it seems that the recordset record is not stepping.
The query is simply the entire database and the form used also includes as visible all of the necessary table fields to which it is bound.
Your help is certainly appreciated and will help me to again start my Access adventure. Damn, what fun starting over!
~ grinnz ~
Problem: The recordset loop only populates the first record of the table although the code loops properly. Using the immediate window it seems that the recordset record is not stepping.
Code:
Option Compare Database
Option Explicit
Private Sub btnFill_Click()
Dim dbs As Database, rst As DAO.Recordset
'Open Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("qrySongsDB")
'Fill Records
With rst
.MoveFirst
Do While Not .EOF
With Me
.sngSeconds = CalculationHere
.txtArtist = CalculationHere
.txtAlbum = CalculationHere
.txtSong = CalculationHere
End With
.MoveNext
Loop
End With
'Release memory & system resources from object variables
rst.Close
Set dbs = Nothing
End Sub
The query is simply the entire database and the form used also includes as visible all of the necessary table fields to which it is bound.
Your help is certainly appreciated and will help me to again start my Access adventure. Damn, what fun starting over!
~ grinnz ~