Query results into an array / string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cowji - 09 Mar 2005 12:41 GMT

Hi Masters of Access Programming,

I am trying to produce an array or a string from a query. I can do this when
producing array/string from a row, BUT i want to produce array/string using
information in one column.

Thanks in advance
Cowji

Reply to this Message

Sandra Daigle - 09 Mar 2005 13:46 GMT

Take a look at the GetRows method of DAO - it returns a two-dimensional
array where the first subscript identifies the field and the second
identifies the row number.

FWIW, I have found that it is almost always easier to work with the
recordset rather than using an array. If you'd like help figuring out how to
use the recordset to do whatever it is you're doing just post back.
Granted - you may have another reason why you must use an array.

Signature

Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

> Hi Masters of Access Programming,
>
[quoted text clipped - 4 lines]
> Thanks in advance
> Cowji

Reply to this Message