Group:  Microsoft Access ยป microsoft.public.access.macros
Thread: Specifying Where Condition when Using Apply Filter Action

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

 Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Specifying Where Condition when Using Apply Filter Action
Ted 31.01.2006 17:45:28
i am trying to get the macro to parse the following condition

[FollowUp] Between # & Forms![Tracking Print By Site]![StartDate] & # And
# & Forms![Tracking Print By Site]![StopDate] & #

but it will not.

what does it need?

thanks for any help.
Re: Specifying Where Condition when Using Apply Filter Action
Steve Schapel <schapel[ at ]mvps.org.ns> 31.01.2006 18:09:51
Ted,

Like this...

[FollowUp] Between Forms![Tracking Print By Site]![StartDate] And
Forms![Tracking Print By Site]![StopDate]

--
Steve Schapel, Microsoft Access MVP


Ted wrote:
[Quoted Text]
> i am trying to get the macro to parse the following condition
>
> [FollowUp] Between # & Forms![Tracking Print By Site]![StartDate] & # And
> # & Forms![Tracking Print By Site]![StopDate] & #
>
> but it will not.
>
> what does it need?
>
> thanks for any help.
>
>
Re: Specifying Where Condition when Using Apply Filter Action
Ted 31.01.2006 18:53:27
yes it is :-)

"Steve Schapel" wrote:

[Quoted Text]
> Ted,
>
> Like this...
>
> [FollowUp] Between Forms![Tracking Print By Site]![StartDate] And
> Forms![Tracking Print By Site]![StopDate]
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> Ted wrote:
> > i am trying to get the macro to parse the following condition
> >
> > [FollowUp] Between # & Forms![Tracking Print By Site]![StartDate] & # And
> > # & Forms![Tracking Print By Site]![StopDate] & #
> >
> > but it will not.
> >
> > what does it need?
> >
> > thanks for any help.
> >
> >
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net