Re: Macro Conditional Expressions

I tried "[expired]![Badge]>0" Then got the following error "You may have
specified a control that wasn't on the current object" the it gives the
example to specify the location for example "Forms![expired]![Badge]>0"
However when I type the location "Queries![expired]![Badge]>0" it
automatically changes it to "[Queries]![expired]![Badge]>0" So I am stuck and
at a loss.

Steve

"JohnFol" wrote:

> The criteria should work. Can you post what you have? I would expect
> something like
>
> DCount("*", "Queryname") > 0
>
>
> "Steve Murphy (Kuwait in Army**US)"
> <SteveMurphyKuwaitinArmyUS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:28000A85-AA07-4804-BAAC-9E14B94B97CD@xxxxxxxxxxxxxxxx
> >I have a query that finds if an employee's qualifications have expired and
> > shows a form and alert at startup with a macro named as autoexec.
> > Unfortunately it shows the message even if there is no expired employees.
> >
> > My question is how do I not run the macro when it does not meet a
> > criteria?
> > I have tried setting a condition but for some reason it doesn't work on a
> > query??
> >
> > Thank you in advance STeve
>
>
>
.

Relevant Pages

  • RE: Filtering a subform using many combo boxes
    ... "Steve Sanford" wrote: ... SELECT AssignedPriority, AssignedPriorityDetail FROM tblAssignedPriority ... I followed you instructions to the letter and every one of the criteria ... open the query "qryProjects" in design view. ...
    (microsoft.public.access.forms)
  • Re: filtering by month
    ... Change the calculated query column to: ... Steve S ... FROM Enrollment ... you suggestion along with the criteria. ...
    (microsoft.public.access.queries)
  • Re: filtering by month
    ... Steve S ... (I came; I saw; I stuck around.) ... Would you post the SQL of the query? ... you suggestion along with the criteria. ...
    (microsoft.public.access.queries)
  • Re: filtering by month
    ... Steve S ... Would you post the SQL of the query? ... you suggestion along with the criteria. ... The reason to Format the dates is to discard the day of the ...
    (microsoft.public.access.queries)
  • Re: filtering by month
    ... Would you post the SQL of the query? ... Steve S ... you suggestion along with the criteria. ... The reason to Format the dates is to discard the day of the ...
    (microsoft.public.access.queries)