I have a database that uses a simple module DoCmd to print a set of reports.
I have a Query that designates the day of the week based on a date chooen on
a form.

What I want is; if the day in the query equals Sunday, or any other day of
my choosing, I do not want the DoCmd to activate for a particular report. How
can I do this? I have tried everything I can think of.

Any help is greatly appreciated
Stephen

Look at the Weekday function. It returns a number representing the day of
the week.

If Weekday(Me!txtDate) = 7
DoCmd.Something
Else
DoCmd.SomethingElse
End If

"SJW_OST" <(E-Mail Removed)> wrote in message
news:F31AC466-542C-4B92-AD61-(E-Mail Removed)...
>I have a database that uses a simple module DoCmd to print a set of
>reports.
> I have a Query that designates the day of the week based on a date chooen
> on
> a form.
>
> What I want is; if the day in the query equals Sunday, or any other day of
> my choosing, I do not want the DoCmd to activate for a particular report.
> How
> can I do this? I have tried everything I can think of.
>
> Any help is greatly appreciated
> Stephen

I am getting and error;

Database can't find the field '|' referred to in your expression.

Should (Me!txtDate) be pointing to the query or form?


"Scott Lichtenberg" wrote:

>
> Look at the Weekday function. It returns a number representing the day of
> the week.
>
> If Weekday(Me!txtDate) = 7
> DoCmd.Something
> Else
> DoCmd.SomethingElse
> End If
>
> "SJW_OST" <(E-Mail Removed)> wrote in message
> news:F31AC466-542C-4B92-AD61-(E-Mail Removed)...
> >I have a database that uses a simple module DoCmd to print a set of
> >reports.
> > I have a Query that designates the day of the week based on a date chooen
> > on
> > a form.
> >
> > What I want is; if the day in the query equals Sunday, or any other day of
> > my choosing, I do not want the DoCmd to activate for a particular report.
> > How
> > can I do this? I have tried everything I can think of.
> >
> > Any help is greatly appreciated
> > Stephen
>
>

I found my problem. I was not including [Forms] in the path for the code to
follow. with that change it works like a charm.

Thank you very much!

"SJW_OST" wrote:

> I am getting and error;
>
> Database can't find the field '|' referred to in your expression.
>
> Should (Me!txtDate) be pointing to the query or form?
>
>
> "Scott Lichtenberg" wrote:
>
> >
> > Look at the Weekday function. It returns a number representing the day of
> > the week.
> >
> > If Weekday(Me!txtDate) = 7
> > DoCmd.Something
> > Else
> > DoCmd.SomethingElse
> > End If
> >
> > "SJW_OST" <(E-Mail Removed)> wrote in message
> > news:F31AC466-542C-4B92-AD61-(E-Mail Removed)...
> > >I have a database that uses a simple module DoCmd to print a set of
> > >reports.
> > > I have a Query that designates the day of the week based on a date chooen
> > > on
> > > a form.
> > >
> > > What I want is; if the day in the query equals Sunday, or any other day of
> > > my choosing, I do not want the DoCmd to activate for a particular report.
> > > How
> > > can I do this? I have tried everything I can think of.
> > >
> > > Any help is greatly appreciated
> > > Stephen
> >
> >