How do I count the number of records in table using VB code? For instance, I have unkown record number in a particular table, and I want to do a loop statement to execute a query to fill data into ...

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data.