Macro Conditional Expressions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Unit testing - Breaking bad habits
    ... This particular app, on startup, queries a DB with the last-used query and uses it to populate a JList control with objects for the user to manipulate. ... :-)), one was a subtler bug with the same consequences, and one was a devilish bug in the output-sorting routine (every comparator derived from a base class designed to fall back on a modification-date comparator on otherwise-equal items -- including the modification-date comparator, which therefore blew up with StackOverflowError. ... So when two parts of the query parse tree evaluate identical and are logical-or'd together (think "return all widgets that are green OR blue" -- so the output should be everything matching the first and everything matching the second -- and then think the default initial query if no saved file somehow wound up "return all widgets that are green OR green") it would go to remove exactly one of them, but the remove code would remove both. ...
    (comp.lang.java.programmer)
  • Re: Prompts and/or reminders?
    ... your query returns DateOfRetirement and RequestMedical when it runs. ... If you want something to run at startup, you can use a macro -- if you name ... alert when they reach retirement age. ... Would it be possible to setup some kind of alert when a user logs in? ...
    (microsoft.public.access.queries)
  • Re: Set a Checkbox value
    ... > CheckBox control on startup. ... I query the database successfully and then ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Set a Checkbox value
    ... > CheckBox control on startup. ... I query the database successfully and then try ...
    (microsoft.public.dotnet.languages.csharp)
  • Set a Checkbox value
    ... I want to query a database on startup of a web for and set the vale of a ... CheckBox control on startup. ... I query the database successfully and then try ...
    (microsoft.public.dotnet.languages.csharp)