PC Review


Reply
Thread Tools Rate Thread

Server Filter by Form

 
 
kai
Guest
Posts: n/a
 
      9th Dec 2004
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


 
Reply With Quote
 
 
 
 
Michael Cheng [MSFT]
Guest
Posts: n/a
 
      9th Dec 2004
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!

 
Reply With Quote
 
 
 
 
kai
Guest
Posts: n/a
 
      10th Dec 2004

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]" <(E-Mail Removed)> wrote in message
news:gu3j%(E-Mail Removed)...
> 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!
>



 
Reply With Quote
 
Michael Cheng [MSFT]
Guest
Posts: n/a
 
      13th Dec 2004
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 (E-Mail Removed)

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!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does unlinked sub form lose filter when main form filter is turned off?? jgeniti Microsoft Access Forms 4 29th Jan 2007 05:13 PM
Filter Filter Filter =?Utf-8?B?YW1zdXJpYQ==?= Microsoft Access Form Coding 5 28th Nov 2006 11:37 AM
Combine a Group Filter Control and Hyperlink/Server Filter on 1 DA =?Utf-8?B?U011cnBoeVBFUw==?= Microsoft Access 0 13th Oct 2006 02:42 PM
Last filter value stuck in forms Server Filter property Stever Microsoft Access Form Coding 3 4th Jun 2004 05:09 PM
Filter by Selection/Filter by Form Report Alan Microsoft Access 1 22nd Jul 2003 05:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:19 PM.