Results 1 to 4 of 4

Thread: Filtering

  1. #1
    Join Date
    Feb 2008
    Posts
    28

    Unanswered: Filtering

    Hello,

    I would like to to show a report listing employees filtered by a variety of conditions specified by the values of a variety of fields on the form of the client whose record I am currently viewing. I cannot seem to get this right and I am looking for suggestions on how to properly do this. If anyone can offer any, please do.

    Example: I want to find all employees whose AvailableZip match ClientZip and who provide the Service that matches ClientService.

    My desired result is to show all employees available in the zip code of the client that provide the service desired by the client.

    Thanks

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    There's a report form example here: http://www.dbforums.com/showpost.php...2&postcount=36 (in the code bank) which may get you started as well as many other examples in the code bank.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Feb 2008
    Posts
    28
    Thanks, that is quite useful. I suppose i problem is I have no clue what the vbc means. How do i provide the query parameter with the information supplied by the record and displayed on the form? I suppose the answer to that is buried within one of the modules...

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Not sure what you mean here (can't recall what you're referring to with vbc) but the 2nd example might be a better example.

    The first example uses a function to open a recordset and create a temp table for the values on the report.

    The 2nd example uses a query to just open the report directly where the recordsource of report has the criteria which meets what was selected on the ReportForm.

    If you want to open a form based on criteria, perhaps some of the other search type examples might work better for your situation
    (http://www.dbforums.com/showpost.php...6&postcount=39)
    (http://www.dbforums.com/showpost.php...2&postcount=63)
    (http://www.dbforums.com/showpost.php...4&postcount=11)
    (http://www.dbforums.com/showpost.php...6&postcount=18)
    (http://www.dbforums.com/showpost.php...6&postcount=18)
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •