MartyConnelly
martyconnelly at shaw.ca
Thu Mar 11 19:05:15 CST 2004
Acckk. Is there some reason you haven't gone to Access or Office 2000 SR-3? It has been out almost 3 years. Francisco H Tapia wrote: > That's not really the problem tho I didn't know things got worse as > you upgraded down the MS Access path :(. > > The problem occurs when you have for example Columns Priority, OnDate, > and Status, and you filter of any combination of the 3, in order to > get your view of the subset down. > > When you then turn around and want to modify data in either one of the > filtered/sorted columns, the Datasheet proceeds to drop the filter and > sort dumping you out of your filter and previously set sort. > > however if you sort on a set of fields (mirrors) > (sproc looks like this: > Select > Priority As SortPriority, > Priority, > OnDate AS SortOnDate, > OnDate, > Status AS SortOnStatus, > Status > From Table1 > ) > > now you can use the Sort columns to filter and sort w/o loosing your > filter and sort settings in the datasheet. my current workaround is > to lock out the sort columns and remember NOT to try to type into them > :)... this totaly bites, but it's Access2000 SR1a of course there's > gonna be bugs. :( > > > MartyConnelly wrote: > >> I don't know if this is the cause; just came across it in fixes >> manifest of Access XP SP3 just released >> >> >> ACC2002: Error Message: Cannot Apply Filter on One or More Fields That >> Are Specified in the Filter Property >> >> http://support.microsoft.com/default.aspx?kbid=814094 >> >> This problem may occur when you connect to Microsoft SQL Server with >> credentials that are different from the credentials of the owner of >> the table that you want to filter. >> >> Francisco H Tapia wrote: >> >>> re-posted from the SqlServer list :) >>> >>> Quick questions, has anyone on the list tried to use a datasheet >>> view form bound to a view or sproc and found that if you filter out >>> the display (datasheet) that upon making changes to any field the >>> datasheet looses it's Filter? >>> >>> Thanks, >>> >> > > -- Marty Connelly Victoria, B.C. Canada