Server Filter by Form

Discussion in 'Microsoft Access ADP SQL Server' started by kai, Dec 9, 2004.

  1. kai

    kai Guest

    Hi, All
    I have created ADP application with Access2003. I run into a problem when
    apply Server filter by form. After I applied Server fiter by form, I cannot
    toggle back to the original state like in Access MDB application can toggle
    back by click the filter again. Please help

    Thanks

    Kai
     
    kai, Dec 9, 2004
    #1
    1. Advertisements

  2. Hi Kai,

    Thanks for your posting!

    From your descriptions, I understood that you are not able to go Back to
    full Table View after applying Filter by Form only in ADP. Have I
    understood you? Correcct me if I was wrong.

    Based on my test, when we click Apply Filter menu in Toolbar, it will turn
    out to be Remove Filter menu so that we are able to view all data in table
    view again. I am not able to reproduce the scenario as you described, is it
    possible for you show me how to reproduce it on my side? More detailed
    information, I believe, will make us closer to the resolution.

    Thank you for your patience and corporation. If you have any questions or
    concerns, don't hesitate to let me know. We are always here to be of
    assistance!


    Sincerely yours,

    Michael Cheng

    Online Partner Support Specialist
    Partner Support Group
    Microsoft Global Technical Support Center
    ---------------------------------------------------------------
    Get Secure! - http://www.microsoft.com/security

    This posting is provided "as is" with no warranties and confers no rights.
    Please reply to newsgroups only, many thanks!
     
    Michael Cheng [MSFT], Dec 9, 2004
    #2
    1. Advertisements

  3. kai

    kai Guest

    Michael,

    Thank so much to your response.

    Normally in Access MDB form, after I fitter by form, I click Filter button
    again, it will go back to full table view. In Access ADP form (I connect to
    SQL Server 2000), the Server Filter By Form button icon look is different
    from normal Filter By Form button icon, it has an arrow pointing to the
    right on the icon, also the Filter button is different, it also has an arrow
    pointing to the right on the Filter icon.



    After I click Server Filter By Form button, and click Filter button (for
    Sever filter, not the normal filter button), I get the result. But the
    Filter button (for Server ) is gone, I cannot click it again to get full
    table view. In MDB Access, after click Filter button, the Filter remains
    and show pushed down look, if you click it, full table view will come back.



    I will be really appreciated your help because it is very powerful feature
    to miss!



    Kai


    "Michael Cheng [MSFT]" <> wrote in message
    news:gu3j%...
    > Hi Kai,
    >
    > Thanks for your posting!
    >
    > From your descriptions, I understood that you are not able to go Back to
    > full Table View after applying Filter by Form only in ADP. Have I
    > understood you? Correcct me if I was wrong.
    >
    > Based on my test, when we click Apply Filter menu in Toolbar, it will turn
    > out to be Remove Filter menu so that we are able to view all data in table
    > view again. I am not able to reproduce the scenario as you described, is
    > it
    > possible for you show me how to reproduce it on my side? More detailed
    > information, I believe, will make us closer to the resolution.
    >
    > Thank you for your patience and corporation. If you have any questions or
    > concerns, don't hesitate to let me know. We are always here to be of
    > assistance!
    >
    >
    > Sincerely yours,
    >
    > Michael Cheng
    >
    > Online Partner Support Specialist
    > Partner Support Group
    > Microsoft Global Technical Support Center
    > ---------------------------------------------------------------
    > Get Secure! - http://www.microsoft.com/security
    >
    > This posting is provided "as is" with no warranties and confers no rights.
    > Please reply to newsgroups only, many thanks!
    >
     
    kai, Dec 10, 2004
    #3
  4. Hi Kai,

    It seems strange. What Access are you using? Access XP 2002 or Access 2003?
    Anyway, I made some screen shot from my Access 2003's ADP and send to the
    email address

    Sincerely yours,

    Michael Cheng

    Online Partner Support Specialist
    Partner Support Group
    Microsoft Global Technical Support Center
    ---------------------------------------------------------------
    Get Secure! - http://www.microsoft.com/security

    This posting is provided "as is" with no warranties and confers no rights.
    Please reply to newsgroups only, many thanks!
     
    Michael Cheng [MSFT], Dec 13, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. J.D.

    Undo or Sort Causes Form to Save Server Filter

    J.D., Mar 11, 2004, in forum: Microsoft Access ADP SQL Server
    Replies:
    0
    Views:
    307
  2. E. Kwong

    Server Filter value on Form property sheet got set mysteriously

    E. Kwong, Apr 14, 2004, in forum: Microsoft Access ADP SQL Server
    Replies:
    2
    Views:
    628
    Richard Heinen
    May 3, 2004
  3. Malcolm Cook
    Replies:
    0
    Views:
    317
    Malcolm Cook
    Apr 22, 2004
  4. kai

    Re: Server Filter By Form

    kai, Dec 10, 2004, in forum: Microsoft Access ADP SQL Server
    Replies:
    0
    Views:
    215
  5. Bonno Hylkema

    Adp form looses filter when filter criteria are updated

    Bonno Hylkema, Jun 16, 2006, in forum: Microsoft Access ADP SQL Server
    Replies:
    4
    Views:
    317
    Bonno Hylkema
    Jun 19, 2006
Loading...

Share This Page