I have a Macro that is running a query and then emails the report associate
to a person. I would like to see if it is possible to cancel this event if no
records are returned in the query? THanks

Sonofroy,

You can use a Condition in your macro like this:
DCount("*","NameOfQuery")>0
This means the macro will nony run if there are records returned by the
query. "NameOfQuery" refers to the name of the query that the report is
based on. I am not sure what exactly you mean by "running a query" in your
original question, but assuming this is an action query, that this is not
the query I am referring to, I mean the Record Source of the report.

--
Steve Schapel, Microsoft Access MVP


"sonofroy" <(E-Mail Removed)> wrote in message
news:51317D5B-AC3F-42B0-BF2D-(E-Mail Removed)...
> I have a Macro that is running a query and then emails the report
> associate
> to a person. I would like to see if it is possible to cancel this event if
> no
> records are returned in the query? THanks

Yes the first step in the Macro is to run an action query and the next step
is to send a report by email. I wanted to stop the macro completely if the
before the email if the action returns no results.


"Steve Schapel" wrote:

> Sonofroy,
>
> You can use a Condition in your macro like this:
> DCount("*","NameOfQuery")>0
> This means the macro will nony run if there are records returned by the
> query. "NameOfQuery" refers to the name of the query that the report is
> based on. I am not sure what exactly you mean by "running a query" in your
> original question, but assuming this is an action query, that this is not
> the query I am referring to, I mean the Record Source of the report.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "sonofroy" <(E-Mail Removed)> wrote in message
> news:51317D5B-AC3F-42B0-BF2D-(E-Mail Removed)...
> > I have a Macro that is running a query and then emails the report
> > associate
> > to a person. I would like to see if it is possible to cancel this event if
> > no
> > records are returned in the query? THanks
>
>

Sonofroy,

Ok, that's fine. Well, my earlier reply is applicable. Use what I showed
you as the Condition for the first action in the macro after the OpenQuery,
and then put ellipsis (...) in the Condition for all actions after that.

An alternative approach would be to put like this in the Condition:
DCount("*","NameOfQuery")=0
.... and put this for a StopMacro action, straight after the OpenQuery.

As I said before, substitute the actual name of the query for my
"NameOfQuery", but this is not the action query, it is the query the report
is based on.

Make sense?

--
Steve Schapel, Microsoft Access MVP


"sonofroy" <(E-Mail Removed)> wrote in message
news:2DA26786-D7F9-41D7-BCBD-(E-Mail Removed)...
> Yes the first step in the Macro is to run an action query and the next
> step
> is to send a report by email. I wanted to stop the macro completely if the
> before the email if the action returns no results.
>