If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
prevent application of filters that pull WAY too many records to the client
I've created a form in 'single form view' for users. The form always opens
with a filter to greatly limit the number of records that are returned to the client. However, I'd like the users to be able to modify the filter criteria using 'Filter by Form' to access other underlying records that aren't accessible via the initial filter, but I DO NOT want the user to be able to clear ALL filter criteria, because I don't want the users to be able to pull all records to the client. Is there a way to allow filtering by form, but prevent the clearing of all filter criteria? Or to somehow prevent the application of a filter that pulls over X number of records? |
#2
|
|||
|
|||
prevent application of filters that pull WAY too many records to t
Jesse,
I don't know whether or not the programmer has access to the FilterByForm tool to prevent clearing the filter, but you could easily build your own and prevent the clearing. You don't mention *why* you wish to limit the number of records. If it is to limit network traffic, I can't think of a way to limit them prior to applying the filter. However, if it's for some other reason such as limiting the number of locked records so that they're available for edit by others, you can apply the filter first, check the RecordCount, and display a "The filter returns over x records. Please apply a finer filter." message, and allow the user to fine-tune it. Hope that helps. Sprinks "Jesse Aufiero" wrote: I've created a form in 'single form view' for users. The form always opens with a filter to greatly limit the number of records that are returned to the client. However, I'd like the users to be able to modify the filter criteria using 'Filter by Form' to access other underlying records that aren't accessible via the initial filter, but I DO NOT want the user to be able to clear ALL filter criteria, because I don't want the users to be able to pull all records to the client. Is there a way to allow filtering by form, but prevent the clearing of all filter criteria? Or to somehow prevent the application of a filter that pulls over X number of records? |
Thread Tools | |
Display Modes | |
|
|