reading/using rowsource properties in VB6

[R. de Vos]

Hi all you experts,

I have a 'small' problem

In a mdb I have a column called "PLACE"
its value type = text
rowsourcetype=list with values
Rowsource = HOME;SCHOOL;STATION

What I would like is, one way or the other, to use the items in Rowsource in
a listbox in a VB-Form. I have tried all kind of things and spent days on
the internet, but nothing worked, sadly.
Maybe you can help me, I desperatly need to know howto do this or to be told
it's impossible

Please Help

Thanx

[Pieter Linden]

"R. de Vos" <hu******@planet.nl> wrote in message news:<41**********************@news.wanadoo.nl>...

Hi all you experts,

I have a 'small' problem

In a mdb I have a column called "PLACE"
its value type = text
rowsourcetype=list with values
Rowsource = HOME;SCHOOL;STATION

What I would like is, one way or the other, to use the items in Rowsource in
a listbox in a VB-Form. I have tried all kind of things and spent days on
the internet, but nothing worked, sadly.
Maybe you can help me, I desperatly need to know howto do this or to be told
it's impossible

Please Help

Thanx

Much easier if you use a table to store the values... then you can
just use a regular query... or is that not an option?

ie. SELECT Place FROM SomeTable ORDER BY Place;

[R. de Vos]

What You suggest should be an option is i hadn't over 100 columns with
various list-items. So I would have an completly new table with all
list-items stored or I would need over 100 tables with just a a few
list-items.

The main idea behind the way I did it now, is to make it possible for users
to create a simple table with the list-values the would like to use, and use
my frontend to insert de values.
The program will be used by answerlists and serveys.

So If You would know the answer to the question in top of the tree, please
help me

Thanx

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

"R. de Vos" <hu******@planet.nl> wrote in message

news:<41**********************@news.wanadoo.nl>...

Hi all you experts,

I have a 'small' problem

In a mdb I have a column called "PLACE"
its value type = text
rowsourcetype=list with values
Rowsource = HOME;SCHOOL;STATION

What I would like is, one way or the other, to use the items in Rowsource in a listbox in a VB-Form. I have tried all kind of things and spent days on the internet, but nothing worked, sadly.
Maybe you can help me, I desperatly need to know howto do this or to be told it's impossible

Please Help

Thanx

Much easier if you use a table to store the values... then you can
just use a regular query... or is that not an option?

ie. SELECT Place FROM SomeTable ORDER BY Place;

[James Fortune]

"R. de Vos" <hu******@planet.nl> wrote in message news:<41**********************@news.wanadoo.nl>...

Hi all you experts,

I have a 'small' problem

In a mdb I have a column called "PLACE"
its value type = text
rowsourcetype=list with values
Rowsource = HOME;SCHOOL;STATION

What I would like is, one way or the other, to use the items in Rowsource in
a listbox in a VB-Form. I have tried all kind of things and spent days on
the internet, but nothing worked, sadly.
Maybe you can help me, I desperatly need to know howto do this or to be told
it's impossible

Please Help

Thanx

I think you have to add each item to the listbox one by one in a loop
similar to the way you add a single item to a combobox in Access. I
don't have the code handy or I'd post a sample of how to do this.

James A. Fortune