Re: ADP Access 2003 Linking problem.

From: Paul D (pdspam_at_highstream.net)
Date: 04/21/04

  • Next message: Hsiao: "Re: Data access page not active" 
    Date: Wed, 21 Apr 2004 15:39:20 -0400

    Well, I haven't had much luck with client side filters (see my past post)
    but here is how with a server filter

    in Microsoft access, open the DAP and have the data outline visible (there
    should be a button labeled data outline that when clicked will toggle the
    visibility of this window).
    Now you want to right click the recordset that defines your data (you know
    you have the correct one if the title of the dialog box that opens says
    RecordsetDef:...). After right click select properties and one of the
    choices should be serverfilter. In that box type the filter you want to
    set. i.e. code_field = "P"

    This can also be done with scripting. If you want to see an example of
    this, let me know.

    Paul D

    "David C" <dispdave@yahoo.com> wrote in message
    news:2bbddda1.0404201440.fae71a4@posting.google.com...
    > Greetings,
    >
    > I hope this is the right forum to post this in. I am working with a
    > past employee's Data Access Page and have a question.
    >
    > I have 2 fields - one is a name field and the other is a simple code
    > field attached to each record (codes are P,F & E).
    >
    > The current page shows all the names. However I'd like it to only
    > show those names with the code P.
    >
    > Thanks for any help you can offer
    >
    > Dave C
    > dispdave@yahoo.com

  • Next message: Hsiao: "Re: Data access page not active"