Question:
I know VB insists on a _constant_ for the array subscript. Has anyone found a way around this? I would like to set an array length equal to the number of records in an Access 2.0 table.
Answer:
The best way to do this is to first Dim the array as one record, for instance. Then, when you have the RecordCount from the database, use the ReDim Preserve command to expand the array to fit the record set.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
