Cannot fill multicolomn into List Box

[dave_yd]

Dear Chandoo,

I want to fill some data with criteria into Listbox, please click find tools beside Date in the sheet "Input Hauling". It will excecute find form.

I have already create syntax below, but it cannot run well

Do While Not rs.EOF
Listcari.AddItem rs.Fields(0)
Listcari.AddItem rs.Fields(1)
Listcari.List(I - 6, 0) = rs.Fields(0)
Listcari.List(I - 6, 1) = rs.Fields(1)
Listcari.List(I, 2) = rs.Fields(2)
Listcari.List(I, 3) = rs.Fields(3)
Listcari.List(I, 4) = rs.Fields(4)
Listcari.List(I, 5) = rs.Fields(5)
Listcari.List(I, 6) = rs.Fields(6)
Listcari.List(I, 7) = rs.Fields(7)
'rs.MoveNext
I = I + 1
Loop

Please help me to solve this

 

[Nebu]

Hi:

I am not completely sure is this what you are looking for. Find the file with modified code.

Thanks

 

[dave_yd]

Nebu,

I want to take data from Daily Log directly with condition likes in the string : "strsql"

I don't want to show in the sheet Input Hauling if my syntax already shown datas in the list box.

Actually rs record already have datas in the memory, that shown in syntax "CopyFromRecordset rs", I want them to be shown up in the list box.

Could you please help me again?

Regards

 

[Nebu]

Hi:

I am afraid that I understood you correctly. I assume that the data on the tab "Input Hauling" is pulled based on SQL query, that is what you want to display on your list box correct me if I am wrong.

Thanks

 

[dave_yd]

Yes, Nebu absolutely right. That sql query shall display directly to listbox thats what I want.

 

[NARAYANK991]

Hi Dave ,

I am not sure whether all that the code is doing is correct ; see if this takes care of your posted problem.

Narayan

 

[Nebu]

Hi:

Why can't you pull data to a different location than "J15" on your "Input Hauling" tab say any column to the extreme right of your "Input Hauling" tab and refer that data to be displayed on your list box with the same code I have provided earlier.

Thanks

 

[dave_yd]

thanks Narayank,

this what I am looking for.

Also thanks for you Nebu, its solved

regards

Hi Dave ,

I am not sure whether all that the code is doing is correct ; see if this takes care of your posted problem.

Narayan