Re: CRecordset::m_strFilter - what is the character limit? (newbie)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bill Thompson (billt61_at_rgv.rr.com)
Date: 11/10/04 

Date: Tue, 9 Nov 2004 22:09:20 -0600

"A C" <no@reply.please> wrote in message
news:2pgkd.446$944.22209@news.xtra.co.nz...
> Hi
>
> What is the maximum length (number of characters) can I make the filter
> string?
> Can you also tell me how it was you found this value out, I looked in the
> help but couldn't see any info on the max length this variable may be.
>
> If I have a very long where clause that I would like to apply (dummy
> example: a list of 1000 allowable surnames) what are my options if the
> string containing all those filter texts exceeds the max length of the
> m_strFilter? What alternatives exist?
>
> Thanks
> A
>
>

I think thats what 'joins' are for.

Relevant Pages

  • Re: Filtering records on a form using multiple combo boxes
    ... So, then, you will need to build the Where string from that information, ... these 3 combo boxes have command buttons to activate the filtering ... filter the field in the record list box.. ... For the Agent Combo Box, ...
    (microsoft.public.access.forms)
  • RE: Set Filter from Startup form to another form
    ... Private Sub Form_Load ... Dim strPrg As String ... Private Function StartProgramAs String ... Now all that is necessary is to set the filter for each form where you want ...
    (microsoft.public.access.formscoding)
  • Re: Filter for Report not working?????
    ... cno2, cField string ... contFilter DynArrayString ... I surround the value with quotes to make it a string otherwise the filter ... I decided to go with a table in PRIV for the report. ...
    (comp.databases.paradox)
  • data access page search code
    ... Dim SerVal As String 'Value to search against ... Dim strWhere As String 'The filter to use ... Dim strPrompt As String 'MsgBox prompt to use ...
    (microsoft.public.access.modulesdaovba)
  • RE: Query form coding
    ... What is the record source of the report? ... Dim strSource As String ... ' Remove Filter ... For Each varItem In Me.namelst.ItemsSelected ...
    (microsoft.public.access.formscoding)