423,113 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,113 IT Pros & Developers. It's quick & easy.

Filter

P: n/a
How can I filter again my previous filtered records, I mean when I
filter an entire I can filter again and again the filtered data.
Many thanks for your help.

Amir

Dec 13 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You can simply use SelectQuery1 as the datasource of SelectQuery2, then use
#2 as the datasource of SelectQuery3, etc. When you run Query#n, all the
underlying queries will be run in sequence.
-Ed

"amir" <ma*******@yahoo.comwrote in message
news:11**********************@n67g2000cwd.googlegr oups.com...
How can I filter again my previous filtered records, I mean when I
filter an entire I can filter again and again the filtered data.
Many thanks for your help.

Amir

Dec 13 '06 #2

P: n/a
Dear Ed
This is my query:
I used adodc & datagrid with this code

Dim MyQuery as string

MyQuery = cbo_catagory & " " & cbo_Operator & " '" & text1.text & "' "

If Text1.Text <"" Then
Adodc1.Recordset.Filter = MyQuery
End If

So what is your suggetion on this matter. Pls help me.

Thanks for your reply.

Amir

Ed Robichaud wrote:
You can simply use SelectQuery1 as the datasource of SelectQuery2, then use
#2 as the datasource of SelectQuery3, etc. When you run Query#n, all the
underlying queries will be run in sequence.
-Ed

"amir" <ma*******@yahoo.comwrote in message
news:11**********************@n67g2000cwd.googlegr oups.com...
How can I filter again my previous filtered records, I mean when I
filter an entire I can filter again and again the filtered data.
Many thanks for your help.

Amir
Dec 14 '06 #3

P: n/a
You're not actually creating a filter with your string. What value(s) of
[category], [operator] or [text] do you want to filter on? Try creating
your filter with a select query in design mode (and set your criteria for
those fields); save that query; reference that query in your code:

If Text1.Text <"" Then
Adodc1.Recordset = qryMyQuery
Adodc1.requery
End If

Assuming that "adodc1" is the name of your form/report.

-Ed
"amir" <ma*******@yahoo.comwrote in message
news:11**********************@16g2000cwy.googlegro ups.com...
Dear Ed
This is my query:
I used adodc & datagrid with this code

Dim MyQuery as string

MyQuery = cbo_catagory & " " & cbo_Operator & " '" & text1.text & "' "

If Text1.Text <"" Then
Adodc1.Recordset.Filter = MyQuery
End If

So what is your suggetion on this matter. Pls help me.

Thanks for your reply.

Amir

Ed Robichaud wrote:
>You can simply use SelectQuery1 as the datasource of SelectQuery2, then
use
#2 as the datasource of SelectQuery3, etc. When you run Query#n, all the
underlying queries will be run in sequence.
-Ed

"amir" <ma*******@yahoo.comwrote in message
news:11**********************@n67g2000cwd.googleg roups.com...
How can I filter again my previous filtered records, I mean when I
filter an entire I can filter again and again the filtered data.
Many thanks for your help.

Amir

Dec 14 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.