G
Guest
Is there any way to loop thru an action query row by row?
eg
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("my_action_query")
Do While Not rst.EOF
rst.MoveNext
Loop
Set rst = Nothing
Guess this is a common question, I don't want to use qdf.Execute as I want
to track the progress of the action query.
Thanks
Damien
eg
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("my_action_query")
Do While Not rst.EOF
rst.MoveNext
Loop
Set rst = Nothing
Guess this is a common question, I don't want to use qdf.Execute as I want
to track the progress of the action query.
Thanks
Damien