HELP (VB)
OK we are using ADO here,
I need to search in a table to find some data.
For example locate a customer ID, then also retrieve the customer firstname, last name etc,
Thanks :o)
Printable View
HELP (VB)
OK we are using ADO here,
I need to search in a table to find some data.
For example locate a customer ID, then also retrieve the customer firstname, last name etc,
Thanks :o)
Dim g_Db As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sTmp As String
Dim sQry As String
sTmp = "File Name=" & App.Path & "\Database.UDL"
g_Db.Open sTmp
sQry = "select firstname, lastname from table where customerid='" & Trim(form.textfield) & "'"
rs.Open sQry, g_Db
[Edited by JHausmann on 06-05-2000 at 06:39 PM]