Display Data From DB To List Box? - Xtreme Visual Basic Talk

12-23-2004, 12:45 PM

jkserial

Newcomer

Join Date: Dec 2004

Posts: 4

Display Data From DB To List Box?

What I am doing is using a query to get specific data from the db and then have the first and last names (each are seperate fields in db) display in the list box. I do not know how to go about doing this, please help?

12-24-2004, 02:19 AM

TopCat

Regular

Join Date: Oct 2004

Location: Liverpool, England

Posts: 81

Have a look at my replie for Jonathan_Bs post 'Searching' this should answer all of your questions

12-26-2004, 09:31 AM

Zero Ice

Newcomer

Join Date: Nov 2004

Posts: 13

Quote:

Originally Posted by jkserial

I assume you got RC as your recordset variable ( ADO Version )

Code:

Function GET_REC(ByVal Table_Name$,ByVal s_Criteria$,ByVal sIndx$)
RC.Open "SELECT * FROM [" & Table_Name & "] WHERE [" & sIndx & "]='" & s_Criteria & "'"
   If Not RC.EOF Then '// we found the target
      '// fill up the listbox
      List1.Additem RC!First_Name & VbTab & RC!Last_Name
   End If
   Set RC = Nothing '// Nill

'//Using Code : GET_REC "Table1",txtSearch,"Primary Key Of Yours"

End Function

Happy coding, bye . . .

Last edited by Zero Ice; 12-26-2004 at 09:41 AM.