Access Vba Loop Through Table Fields. If rsRecordCount 0 Then set the cursor to the first row rsMoveFirst Dim BucketTermUnit As String Dim BucketDate As Date Dim MarkAsOfDate As Date Dim InterpRate As Double Dim b As String loop the rows Do Until rsEOF endoffile b. We use this form to select the date for the report we want to create.
Paste the code in the window that opens. Is there a way to gain access to the Field Properties using VBA. In the database explorer window choose Modules on the left.
You can loop through recordsets with a while or Do loop.
You will be taken into a new instance of Excel with your tables and fields listed. VBA loop through Tables. You can even nest loops within each other. I have a table with 6 columns with about 500 records in the table.
