Re: Form filter works in 2000-2002 but fails in 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 03/09/05 

Date: Wed, 9 Mar 2005 12:40:43 +0800

There have been other reported problems with Access 2003 not recognising
that syntax.

Try referring to the form in the subform control, i.e.:
    forms![client information].[policy info header only].Form![ClientNumber]

Explanation of the ".Form" bit:
    http://allenbrowne.com/casu-04.html 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Greg O" <obermier1@cox.net> wrote in message
news:mquXd.49420$755.36634@lakeread05...
>I have a client with an Access 2000 format database sitting on a shared
> drive on his server.  Several of his forms are filtered based upon the
> current value of other open forms.
>
> The form's filter looks like this:
> [ClientNumber]= forms![client information].[policy info header
> only]![ClientNumber]
> And [PolicyNumber] = forms![client information].[Policy info header
> only]![PolicyNumber]
>
> Allow filters is set to Yes.
>
> Some users have Access 2000 and some have Office XP with 2000 or 2002. 
> The
> owner has Office XP with Access 2003, and only his filtered forms will not
> retrieve the data whatsoever.  The rest of the database functions normally
> on his machine, all queries, forms, reports, etc.  Did Access have a form
> reference syntax change in 2003 that would cause this?
>
> I don't have the 2003 version here to test it on, but on my 2002 version 
> it
> runs just fine.  Any help would be appreciated.
>
>
>
> Greg Obermier
> IT Consultant
> Choctaw Engineering, Inc.
>
>

Relevant Pages

  • Re: Shrink large file according to REG_EXP
    ... I've as input a large text file which I need to filter ... different syntax, and I have syntax files which tell me how to split ... split the file in chunks and let each thread work on a chunk of the ... If your program is I/O bound, then it might be faster to work on ...
    (comp.lang.perl.misc)
  • Re: Struggling to get the report I need FOR MTG TOMORROW
    ... I scopied and made a new calendar I made ... However, when I applied it, gave it one of the resource ... You just need to chop that syntax into fields, ... In the filter ...
    (microsoft.public.project)
  • Re: A really good reference on digital filters
    ... of course that's an s-plane thing, but is directly mappable via the bilinear xform to a digital filter with fixed ripple in passband and stopband with with a tradeoff between transition bandwidth and, say, the minimum stopband attentuation. ... It is by no means a dead language. ... now i remember 77 and even Fortran IV, ... how does F2003 group statements together into blocks (what's the syntax for delimiting the beginning and end) to make a compound statement. ...
    (comp.dsp)
  • Re: get opacity value [a bit more]
    ... The latter is being changed now to follow CSS 2.1 Syntax: ... there does appear to be a "need" for a third isHost* function. ... The other one mentioned is designed to filter ... ActiveX objects, so it is used for properties that may need to be ...
    (comp.lang.javascript)
  • Re: Extension problem
    ... >> except the filter ring cap is the other side of the filter, ... >> the master socket one is direct on the line. ... > without DSL and no reported problems. ...
    (uk.telecom)