Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / March 2006

Tip: Looking for answers? Try searching our database.

ADP Project gives error when using the filter by selection option on a stored procedure

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
singhneeta@gmail.com - 13 Mar 2006 22:37 GMT
Hi all,

I have a funny issue. I have a stored procedure that opens up as a
datasheet. User can use the filter by selection option in Access to
filter records. For some reson, some of the columns cannot get
filtered. I get an error "Cannot apply filter on one or more fields
specified in the filter property". However, if I sort the stored
procedure after opening it, then I am able to filter it.

I tried removing the dbo. from the stored proc , then it works
perfectly but only for admin logins. What am i doing wrong?

-Neeta Singh
Jerry Boone - 17 Mar 2006 19:09 GMT
I recently moved my ADP to Access 2003 and that particular problem went
away!  Of course it may not help if you are filtering by form on a locked
field or something.

To my astonishment, a lot of other bugs/problems went away as well.  After
previously attempting to move from Access 2000 to Access XP (and having
same/similar & more problems) I was doubtful that anything would get fixed.

Signature

Jerry Boone

> Hi all,
>
[quoted text clipped - 9 lines]
>
> -Neeta Singh
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.