<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<META content="MSHTML 6.00.3790.59" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=062450518-29092003><FONT face=Arial color=#0000ff size=2>I must
also throw in my thanks, I was beginning to think I would never get an
anwer.</FONT></SPAN></DIV>
<DIV><SPAN class=062450518-29092003><FONT face=Arial color=#0000ff
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=062450518-29092003><FONT face=Arial color=#0000ff
size=2>Nancy</FONT></SPAN></DIV>
<DIV><BR><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of
</B>A.D.Tejpal<BR><B>Sent:</B> Monday, September 29, 2003 1:41 PM<BR><B>To:</B>
Access Developers discussion and problem solving<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>
<DIV dir=ltr align=left> Thanks <STRONG>William! -</STRONG>
for your kind observation.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=wdhindman@bellsouth.net href="mailto:wdhindman@bellsouth.net">William
Hindman</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, September 29, 2003
13:53</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Removing a filter
from a report</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>...nice explanation ...this goes in my scrap book
:)</FONT></DIV>
<DIV> </DIV>
<DIV>William Hindman<BR><<A
href="http://www.freestateproject.org">http://www.freestateproject.org</A>>
- Do you want liberty in your lifetime?</DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=adtp@touchtelindia.net
href="mailto:adtp@touchtelindia.net">A.D.Tejpal</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, September 29, 2003 12:33
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Removing a
filter from a report</DIV>
<DIV><BR></DIV>
<DIV>
<DIV><STRONG>Nancy,</STRONG></DIV>
<DIV> </DIV>
<DIV> I have not seen any reply to your post so far.
Certain points arising out of my experimentation on the subject are given
below.</DIV>
<DIV> </DIV>
<DIV> When passing the filter criteria string as an
argument while opening the report via DoCmd method, no need
to tinker with the filter properties of the report through any of its
internal events. In any case whatever is done in the close event of the
report does not necessarily get saved for next occasion.</DIV>
<DIV> </DIV>
<DIV> Following steps are recommended -</DIV>
<DIV> (a) Open the report in design view</DIV>
<DIV> (b) In the properties dialog box, make sure that
-</DIV>
<DIV> (i) Filter is set to
<STRONG><EM>Blank</EM></STRONG></DIV>
<DIV> (ii) FilterOn is set
to<STRONG><EM> No</EM></STRONG></DIV>
<DIV> (c) Remove all statements reg filter properties (e.g
Me.Filter = "" and Me.FilterOn = False) from report's
events.</DIV>
<DIV> </DIV>
<DIV> After the above steps, there should be no problem in
getting proper response if the following statements are
executed one after the other. (R_TEST is the name of report while Crs1
& Crs2 are criteria strings). <EM>The report should be in closed
state before executing fresh statement</EM> -</DIV>
<DIV>(1) DoCmd.OpenReport "R_TEST", acViewPreview, , Crs1 </DIV>
<DIV>(2) DoCmd.OpenReport "R_TEST", acViewPreview, , Crs2<BR>(3)
DoCmd.OpenReport "R_TEST", acViewPreview</DIV>
<DIV> (Statement 3 means no filtering
action)</DIV>
<DIV> </DIV>
<DIV> Note - To help appreciate what is
happening - Open the report as per (1) or (2) and then
change its view to design view. On opening the property window, it
would be observed that Filter property carries the value Crs1 or Crs2 as the
case may be. FilterOn property continues as <STRONG><EM>No.</EM></STRONG>
<EM><U>Do not click save button at this stage.</U></EM> When
the report is finally closed and then opened in design view, the filter
property will be found <STRONG><EM>Blank</EM></STRONG>.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=nancy.lytle@auatac.com href="mailto:nancy.lytle@auatac.com">Nancy
Lytle</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Accessd</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 24, 2003
14:53</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Removing a filter
from a report</DIV><BR>I know this should be simple but I have tried
everything I can think of....and it was pushed to the back burner and now
it is on the hot plate again so...<BR>The problem is I have a few reports,
which users choose from a form. This form allows the user to choose the
report they want, the year (one year, ie 2003 or all years) for the data,
and the dept (either one dept. ie EDP or all depts), then a click of
a button and the report opens for viewing with the selected records.
But what seems to happen on occassion is that a<BR>"filter" will stick to
the report, thus making the next selection not work.<BR><BR>I selected the
reports using the good old stDocName for the report and stLinkCriteria for
the filter, ie DoCmd.OpenReport<BR>stDocName,,,stLinkCriteria<BR><BR>On
the close of each report I use Me.filter = "" and Me.applyFilter =
false<BR><BR>What am I doing wrong?<BR>PS, I also have the same problem
with forms when I want to open one report<BR>based on criteria from
another form.<BR><BR>TIA<BR><BR>Nancy Lytle<BR><A
href="mailto:nancy.lytle@auatac.com">nancy.lytle@auatac.com</A><BR>202-314-1393</BLOCKQUOTE></DIV></BLOCKQUOTE></BLOCKQUOTE></DIV><BR>
<P><FONT size=2>---<BR>Incoming mail is certified Virus Free.<BR>Checked by AVG
anti-virus system (http://www.grisoft.com).<BR>Version: 6.0.521 / Virus
Database: 319 - Release Date: 9/23/2003<BR></FONT></P>
<P><FONT face=Arial size=2></FONT></P></BODY></HTML>
<BR>
<P><FONT SIZE=2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.521 / Virus Database: 319 - Release Date: 9/23/2003<BR>
</FONT> </P>