[AccessD]

Marcus, Scott (GEAE, Contractor) scott.marcus at ae.ge.com
Wed Jul 30 10:32:41 CDT 2003


In that case, you need to set the 'filter on' property of the report to
true. Next, set the filter to the where condition of the SQL statement that
you would have if you knew all the criteria up front without the word
'where'.

for example...
Me.FilterOn = true
Me.Filter = "[field] = 'something' and [filed2] = 'something else'"

Scott

-----Original Message-----
From: Frank Tanner III [mailto:pctech at mybellybutton.com]
Sent: Wednesday, July 30, 2003 11:23 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] 


I thought of that.  My biggest problems is that It may
need to be based on more than one of the filter
queries at a time.  Like I might want to filter out
extension to extension calls AND local calls so that
they're not displayed on the report.

--- "Marcus, Scott (GEAE, Contractor)"
<scott.marcus at ae.ge.com> wrote:
> In the Open event of the report, determine which
> query the report needs to
> be based on(the form check boxes) and change the
> recordsource via code.
> 
> Scott
> 
> -----Original Message-----
> From: Frank Tanner III
> [mailto:pctech at mybellybutton.com]
> Sent: Wednesday, July 30, 2003 10:57 AM
> To: Database Advisors
> Subject: [AccessD] 
> 
> 
> Ok.  Stupid question time....hehehe
> 
> I have a report that I want to run.  The report, of
> course, is based on a query (it calls the query as
> it's record source).  I have other queries that I am
> using as "filters".  I want to activate these
> filters
> based on check/uncheck boxes.
> 
> I have the check/uncheck boxes on a form.  The form
> calls the report.  How can I get the report to
> filter
> based on the "filter" queries I have written based
> on
> whether or not a checkbox is checked or unchecked in
> the main form?
> 
> Thank you for your assistance.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list