Count commas and use as array size

[Duhuhude]

Hello everyone

I need to use VBA to retrieve a record from a query, count the number of commas, and use that number +1 as the size of an array. How do I go about doing this?

Thanks

 

[DJkarl]

I would use something like

myInteger = ubound(split("This,is,my,test,string,",","))+1

 

[Duhuhude]

Thanks, but before I try that, how do I retrieve a record from a query?

 

[DJkarl]

Thanks, but before I try that, how do I retrieve a record from a query?

You would use a recordset object most likely.

Dim rs as DAO.Recordset
 
set rs = CurrentDB.OpenRecordset("QueryName")
 
'Work with recordset here

 

[gemma-the-husky]

i think the understanding was that you knew how to work with queries, and were needing help with analysing the data.

thinking again, though, if you have a query - why would you have any embedded commas within the query records? A query normally consists of a number rows, each one consisting of a number of independently addressable named fields.