Multi Select Listbox

[database]

Hi everyone....

I am trying to design a form in which i have a listbox with suppose 5 number of groups listed in it. What i would like to do is that when a user clicks on any group or groups, the names are transfereed in another listbox. When the user is done selecting the groups, he clicks on a cmd button, which will use these group name and run the query to display a the labels of all the people who belong to the selected groups. Also I would like to store a name for the groups selected , so that later on the user can just clcik on the name and he is done with it. He doesnt have to keep rememebring which groups he wants for a particular set.

Seems a lot of work here. Can anyone help me to get started on this one?

Thanks,
dB

 

[smercer]

Groups of what? This could mean anything from a group of parts, group of musicans, group of records etc.

Please be more specific

 

[WayneRyan]

database,

I was just tinkering with listboxes. Here's a sample of some manipulations
that can be done.

Don't really know what it does, but it was interesting making it do different
things.

Wayne

 

[Mile-O]

Groups of what? This could mean anything from a group of parts, group of musicans, group of records etc.

Either way they are all groups. It shouldn't be relevant to know what they are groups of - you wouldn't treat parts and musicians differently. Not if they are normalised.

 

[smercer]

Either way they are all groups. It shouldn't be relevant to know what they are groups of - you wouldn't treat parts and musicians differently. Not if they are normalised.

I mean is he refering to subrecords or something else.

 

[database]

database,

I was just tinkering with listboxes. Here's a sample of some manipulations
that can be done.

Don't really know what it does, but it was interesting making it do different
things.

Wayne

Thanks Wayne for the smaple db . This is eactly what i wanted.

Although i have a little problem in coding. I am not able to use DAO since it gives and error: "User defined type not defined"... what should i do?


smercer, by groups i mean group names. They are groups in itself. They are just the names of the groups.


Thanks a lot for all ur help !
dB

 

[Mile-O]

Although i have a little problem in coding. I am not able to use DAO since it gives and error: "User defined type not defined"... what should i do?

I've written an FAQ in the FAQ forum that addresses this - look at the sticky called Index and it will be listed near the bottom.

 

[database]

I've written an FAQ in the FAQ forum that addresses this - look at the sticky called Index and it will be listed near the bottom.

Hey mile... Didnt get it... what do i excatly search for?

Thanks
dB

 

[database]

database,

I was just tinkering with listboxes. Here's a sample of some manipulations
that can be done.

Don't really know what it does, but it was interesting making it do different
things.

Wayne

I am getting an error in this line when i run it from my dB....
Set rst = dbs.OpenRecordset("Select * From tblList Order by Group_name")


it gives an error "Type mismatch"

Even whe i import the tables and form from ur db to my db it gives and error...whereas when i run ur db sepeartely it doesnt....why is that so?????


dB

 

[WayneRyan]

dB,

Can you post a sample of your database?

Wayne

 

[database]

dB,

Can you post a sample of your database?

Wayne

Wayne...this is the sample database

Thanks
dB

 

[WayneRyan]

dB,

The recordset is DAO too.

Dim rst as DAO.Recordset

I'll look at it more closely later.

Wayne

 

[database]

dB,

The recordset is DAO too.

Dim rst as DAO.Recordset

I'll look at it more closely later.

Wayne

Hey thanks lot !!... I knew it had to be something simple... took me such a long time to detect the fault !...thansk to u !

dB

 

[WayneRyan]

dB,

Good to hear.

BUT, this exercise was very heavy on the VBA. The listboxes mandated
that, because queries can't pick them apart.

Keep us posted as to how the rest of this goes.

Wayne

 

[database]

dB,

Good to hear.

BUT, this exercise was very heavy on the VBA. The listboxes mandated
that, because queries can't pick them apart.

Keep us posted as to how the rest of this goes.

Wayne

Hey Wayne I now have another problem...
I am very new at Vb so i keep asking such qs...
When i choose the group names, I want to open a report for those those groupnames... Can you help me here?

 

[Mile-O]

Hey mile... Didnt get it... what do i excatly search for?

this

 

[database]

this

Thanks Mile... Got it !