any vb programmer in the house? need help got stuck somewher while codiing need code to do search/find from database when search buton is clicked. i'd used the 'recordset.additem' "recordset.delete" to add and delete records from the database(access) please help out.

Private CmdSearch ()
Dim ask As String
ask = InputBox("Enter Client ID")
With rs
.FindFirst "REG_NO='" & ask & "'"
If .NoMatch = True Then
MsgBox "Record Not Found", vbInformation, Me.Caption
Else
txtreg = !reg_no
txtname = !Name
txtic = !iCOM
txtword = !ms_word
txtpp = !power_point
txtexcel = !ms_excel
txtaccess = !ACESS
txtpm = !pmaker
txtinternet = !internet
lblgp = !GPA
lblresult = !grade
lbl1 = !ic
lbl2 = !wd
lbl3 = !pp
lbl4 = !ex
lbl5 = !ac
lbl7 = !In
lbl6 = !PM
End If
End With

Good!

@Georgem.
You should at least let's know if this solve your problem

can someone help me with linking vb6.0 and mssql server 2000 and mysql too. i've been having lots of problem creating a database tht works fine with vb on both.

tolubonnke,

I have attached a document for you to guide you to create an ODBC through the Windows Control Panel. And subsequently, System DSN to link your database and use the name when writing your VB code.

When you create a System DSN for your database, any name you gave it is available for you to use in your Visual Basic code.