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
3  1485 
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*******@yaho o.comwrote in message
news:11******** **************@ n67g2000cwd.goo glegroups.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
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.Recordse t.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*******@yaho o.comwrote in message
news:11******** **************@ n67g2000cwd.goo glegroups.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
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.Recordse t = qryMyQuery
Adodc1.requery
End If
Assuming that "adodc1" is the name of your form/report.
-Ed
"amir" <ma*******@yaho o.comwrote in message
news:11******** **************@ 16g2000cwy.goog legroups.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.Recordse t.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*******@yaho o.comwrote in message
news:11******* *************** @n67g2000cwd.go oglegroups.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Robin Cull |
last post by:
Imagine I have a dict looking something like this:
myDict = {"key 1": , "key
2": , "key 3": ,
"key 4": }
That is, a set of keys which have a variable length list of associated
values after them. What I want to do is filter out a subset of this
dict to produce another dict that satisfies a set of criteria (in this
case whether it contains all four values) to end up with something
|
by: Robert Neville |
last post by:
I would like to add filter functionality to my database whether
through the Main form or the subform. This question may be
rudimentary, yet I have not less experience with filtering data
outside from queries. Let me just add that Allen Browne excellent
article about this subject may not apply to this scenario on an
elementary level. (Here's the link to the article; Filter a Form on a
Field in a Subform -...
|
by: CSDunn |
last post by:
Hello,
I have a problem with field filtering between an Access 2000 Project form
(the application is called CELDT), and the report that shows the results of
the filter. Both the form and the report are based on the same View
addressed in the Record Source of both as 'dbo.CLMain_vw'. The View resides
in a SQL Server 2000 database. There are two different problems I am having
with filtering: The first involves filtering in the form by date...
|
by: Richard |
last post by:
Hi,
I have a form based on a table. When I filter the form I want to run a
report based on the same table with the same filter as the form. No problem
until I want to filter a combo box where the text value is on a different
table. The me.filter is then a text instead of the id-number from the lookup
table. This causes the report to prompt for the parameter.
How do I get by this problem? Do I need to create a temporary table? I
rather...
|
by: dick |
last post by:
I am just trying to print/report the results of a "filter by
selection" which is done by right-clicking a form, filling in values,
and "applying the filter."
I have searched the newsgroups, and there are many examples. BUT, they
fail sometimes.
The techique is to pass the form's Me.filter as the "where condition"
in a
Docmd.openreport statement in code behind a "print button" on the
form.
| | |
by: Salad |
last post by:
I have a log file with a list of records. The log file can be
unfiltered or filtered.
I have a command button to call a data entry form from the log. At
first I was only going to present the record the user selected. Then I
thought, what the heck, give the user all of them but start out at the
record the user is currently on.
If I pass the current filter that resides on the log this causes
problems. For example, if the filter is...
|
by: Mike Sweetman |
last post by:
I have a form Form1 which when the Advanced Filter/Sort is used
creates a form(maybe) with a title 'Form1Filter1 : Filter'. When I
apply the filter to Form1 it is applied, but the value of Form1.Filter
is ''.
How do I obtain the Advanced Filter/Sort criteria as a string ?
I cannot reference the object 'Form1Filter1 : Filter' by using
Form1Filter1.
|
by: marcus.kwok |
last post by:
I am having a weird problem and I have can't figure out why it is
happening. I create an OpenFileDialog and set a filename filter. When
the dialog first opens, the filter works correctly, and only the files
I want to see appear in the file list box. When I change the filter to
one of the other filters, all the files in the list disappear. If I
then manually type a filter into the "Filename" textbox, then the files
appear and the filter...
|
by: Briansmi1116 |
last post by:
I created two buttons, that filter my form, They filter in different Fields, and if one is filtered, and the other is not there is a certain amount of record, if they are both pushed, then there is less. This works great, but now I want to filter within what is left in the form, without adding the other records.
The code I use to filter using my buttons is:
Private Sub filter_closed_Click()
If filter_closed.Caption = "Filter Closed"...
|
by: woodey2002 |
last post by:
Hi Everyone and many thanks for your time.. I am trying to begin access and a bit of VBA i am enjoying it but I have a annoying problem I just can’t get any where on.
My databse mostly includes bits of code for different examples. I have one last thing to finish.
I am trying to create a search form that will allow users to select criteria from multiple sources eg ,multi select list boxes , combo boxes.
I have a subform showing all the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
