Hi, where can I find the "Apply Filter on Loading" setting in Access 2007?
Giorgio
--- In MS_Access_Professionals@yahoogroups.com, "acravenrohm" <yahoo@...> wrote:
>
> I haven't yet had a problem with
>
> .FilterOn = False
>
> The cases where setting a filter has shown an empty Form have the following workaround:
>
> .Filter = .Filter
> if .FilterOn = False then .FilterOn = True 'should be a "do nothing"
>
> Side thought:
> Upon saving a formular in Access 2000 (and later) it saves the Filter setting in the design but in the runtime this has never bothered me as the filter there doesn't get applied. In Access 2007 there's a further setting "Apply Filter on Loading" which if Access 2007 is interpreting differently to Access 2003 might result in you getting more filter than you bargained for.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Thomas" <thomas_lam_us@> wrote:
> >
> > yes, that's what I have noticed. It is still running fine on machines running MS Office 2003.
> >
> > The sub-form shows nothing even the 'Filtered' is posted at the bottom of the form.
> >
> > Were you able to resolve the problem and how?
> >
> > Regards,
> > Thomas
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "acravenrohm" <yahoo@> wrote:
> > >
> > > Maybe you're seeing an effect I'm seeing. A recent Microsoft Update is making some sub-forms in my Application(s) show no records where previously there would have been and where a requery does show them. A sum over the records in the sub-form also returns 0 until after the requery so Access really does not have any records to show but the requery shows that there should be.
> > >
> > > That's my analysis of the effect I'm seeing so far but the conclusion may be false as it might only *look* like the same thing that keeps happening (a Microsoft Update making Access react differently to previously working code.)
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Thomas" <thomas_lam_us@> wrote:
> > > >
> > > > I recently upgraded to 2007, it appears the Me.FilterOn = True (or Me.FilterOn = False) is not working.
> > > >
> > > > I notice at the bottom of the screen it said 'Filtered' but no data is displayed.
> > > >
> > > > Any suggestions what might be the cause?
> > > >
> > > > Thanks,
> > > > Thomas
> > > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar