Access 2003 and alarms

[Guest]

Creating a data base with 'expiry dates' as part of the data. Is there a
way to trigger a message/alarm prior to the arriving at the entered date?

I can see a macro that will give a message when an action is taken, but not
act as an alert due to date count down.

regards,

 

[Larry Linson]

Creating a data base with 'expiry dates' as part of the data. Is there a
way to trigger a message/alarm prior to the arriving at the entered date?

I can see a macro that will give a message when an action is taken, but
not
act as an alert due to date count down.

A query can use the Date() function which returns the current day's date in
a criteria to select records whose "expiry dates" fall within a specific
time range from today... that list of records could be displayed in a
continuous forms view Form using that Query as its Record Source. This could
be the first Form shown whenever the DB is opened. And then, double-clicking
on a particular record could open the detail in a separate Form so you could
take whatever action is necessary. But, this is dependent on your opening
the database... there's no "wake up the database" option to make it open on
its own, unless you chose to use the Windows scheduler
function to open it, on a regular basis.

Larry Linson
Microsoft Access MVP

 

[Allen Browne]

Create a query, with criteria that select the records where the date is
close.
This example picks records for the next 3 days and before:
<= Date() + 3

Create a report based on this query, to show the user these records. Cancel
the report's NoData event if there are no records.

At some suitable point (e.g. AutoExec macro, or in the Open event of your
switchboard, or the Click event of a button), OpenReport. You will probably
want to use code to do this, so you can trap and ignore the error 2501 that
occurs when the OpenReport is cancelled by the NoData event.