4/Fields to 4/arrays??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenneth - 29 Aug 2003 08:50 GMT

Hello,

I have an Access database with one table and 4/fields with a lot of data.
How can I read in these 4/fields to 4 arrays and then paste the data to
4/list boxes????

Can anyone please show me any example that I can modify???

// Kenneth

Reply to this Message

Maarten - 29 Aug 2003 09:15 GMT

Data1.Recorset.MoveFirst

Do While not Data1.Recorset.Eof

List1.Additem Data1.Recorset("Field1")
List2.Additem Data1.Recorset("Field2")

Data1.Recorset.MoveNext

Loop

Reply to this Message

Kenneth - 29 Aug 2003 10:13 GMT

Thanks for your replay but I will use these values to other things also,
therefore I need to have these values in 4/arrays..

Do you know how I can do' it

// Kenneth

> Data1.Recorset.MoveFirst
>
[quoted text clipped - 6 lines]
>
> Loop

Reply to this Message

Jason - 29 Aug 2003 18:24 GMT

if you use the recordset in more that one place then open two recordsets.
One for populating the listboxes and the other for the other things.

Jason

> Thanks for your replay but I will use these values to other things also,
> therefore I need to have these values in 4/arrays..
[quoted text clipped - 13 lines]
> >
> > Loop

Reply to this Message

Val Mazur - 30 Aug 2003 01:53 GMT

Hi Kenneth,

I would keep information in a recordset. You could use functionality of the
recordset to sort, filter and navigate data. Nobody says that you have to
use all the fields at same moment of time, but ADO could help you. But if
you still want to dump data into arrays, then check GetRows method of ADO
recordset. It allows to transfer values from recordset to array

Signature

Val Mazur
Microsoft MVP
Check Virus Alert, stay updated
http://www.microsoft.com/security/incident/blast.asp

> Thanks for your replay but I will use these values to other things also,
> therefore I need to have these values in 4/arrays..
[quoted text clipped - 13 lines]
> >
> > Loop

Reply to this Message

VB Forum / Database Access / August 2003

4/Fields to 4/arrays??