Re: Prompts and/or reminders?

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

So, your query returns DateOfRetirement and RequestMedical when it runs.

Could you create another query, based on the first one, that only returns
the rows for which those two are, say, in the next week?

If you want something to run at startup, you can use a macro -- if you name
it Autoexec, it runs at startup. Or you could create a procedure tied to
the first form that opens...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"BetaMike" <BetaMike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8F37BC13-EDDD-42A6-B717-38D0E2379405@xxxxxxxxxxxxxxxx
We record each employee's DateOfBirth in tblEmployees and want to create
an
alert when they reach retirement age (65yrs in the UK). Employees can
choose
to work beyond their 65th birthday if they wish so we need some kind of
prompt to remind us to contact them in advance.

I have entered the following expressions in the relevant qryEmployees

DateOfRetirement: DateAdd("m",780,[DOB])
RequestMedical: [DateOfRetirement]-90

This shows the date of retirement and displays a date 90 days prior to
this.
Would it be possible to setup some kind of alert when a user logs in? Any
suggestions would be appreciated :)

Thanks.


.

Relevant Pages

  • Macro Conditional Expressions
    ... 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. ...
    (microsoft.public.access.queries)
  • 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: duplicate data
    ... If you choose to create a report of this that sorts it first by a unique key ... Now, with a bit of work, this actually can be done in a query. ... different alert number. ...
    (microsoft.public.access.queries)
  • Re: Cache Hit Ratio from system views
    ... We are working on a simple alert like when ... the cache hit ratio falls below a given threshold. ... with a query that uses the V$BUFFER_POOL_STATISTICS view. ...
    (comp.databases.oracle.server)
  • Re: Cache Hit Ratio from system views
    ... We are working on a simple alert like when ... the cache hit ratio falls below a given threshold. ... with a query that uses the V$BUFFER_POOL_STATISTICS view. ...
    (comp.databases.oracle.server)