recordset clone and search

[Sweetu]

Hey dears!

May I expect any help from you...
How to make recordset from query and than search via VB code from query by entering data into Textbox?

[ranman256]

If the textbox ,txtName, is to search only the name box then make a query, qsFind, to look at the box:

select * from table where [name]=forms!myForm!txtName

then the find button will run the macro with the command,
Openquery "qsFind"

[Sweetu]

I'm searching on query...

Before I'm using this code

Me.txtsearch = Like "*" & Forms!navigationform.forms!txtsearch
Me.filter=true

It's very slow...
I need to search by another method either recordset clone or recordset...
Where txtsearch is Textbox name...

[Sweetu]

If the textbox ,txtName, is to search only the name box then make a query, qsFind, to look at the box:

select * from table where [name]=forms!myForm!txtName

then the find button will run the macro with the command,
Openquery "qsFind"

I'm searching on query...

Before I'm using this code

Me.txtsearch = Like "*" & Forms!navigationform.forms!txtsearch
Me.filter=true

It's very slow...
I need to search by another method either recordset clone or recordset...
Where txtsearch is Textbox name...

[ranman256]

No ,the filter is fast.
cloning is slower.

[Sweetu]

No ,the filter is fast.
cloning is slower.

I've 1 lac rows where filter takes 2 minutes to search and find the record...
Some friends suggested to create ADODB connection to sql server and use ADODB record set...
Can you please help there?