I've been using this code for a while to retrieve data from an access database. I now need to count the number of records in the set before I write the data. I'm aware I could count the records by adding a count to the loop below, but I want to change the way this the whole thing works! I want to import my data to an array, so I would need to redim the array first. I have tried writing an SQL query that counts but I can't get thing thing to work. Can I build it into the query below? I'm actually extremely confused about how the whole thing works :|...
Bookmarks