How can I fetch data from a table in ms-access row by row using sql and vba then showing every value in msgbox. How can I use for loop statement to achieve that.
Asked
Active
Viewed 18 times
0
-
Have a look here https://docs.microsoft.com/en-us/office/vba/api/access.docmd.gotorecord – Máté Juhász Nov 29 '20 at 18:41
-
https://docs.microsoft.com/en-us/office/vba/access/concepts/data-access-objects/move-through-a-dao-recordset – Gord Thompson Nov 29 '20 at 18:52