PDA

Click to See Complete Forum and Search --> : Urgent - Searching ADO Recordssets

HanneSThEGreaT
August 21st, 2001, 06:20 PM
How do I create a search ado record facility on my forms?
Can anyone help, Please...

Thanx

F. T. W.
Robert Moy
August 21st, 2001, 06:54 PM
Hello:

If I understand what you mean, you can use this program which will allow an user can input thier column and data to be searched.
[\vbcode]
Adodc1.RecordSource = "Select " & Text3.Text & _
" from " & Text4.Text & _
" WHERE " & Text5.Text & "=" & Text6.Text
Adodc1.Refresh
[/vbcode]

Good Luck
HanneSThEGreaT
August 22nd, 2001, 08:47 AM
Hi Robert. I haven't made use of the adodc control, I've selected the Ado Code Option on the DataForm Wizard, how can I do it without the adodc control?

Thanx
Hannes

F. T. W.
Iouri
August 22nd, 2001, 11:41 AM
sSQL = "select * from Table where Field = YourCriteria"

rs.Open sSQL, adOpenDynamic, adLockOptimistic

now recordset contains your search criteria and you can do whatever you want with it.

Iouri Boutchkine
iouri@hotsheet.com