Popup message

[Cam]

Hello,

I created a database to store tool/equipment calibration.
Is there a way in Access to create a form? to popup a list
of tools that are due for calibration (field= NextCalDue)
every time the database is opened or keep popping up until
the NextCalDue field is greater than today's date?
Thanks for any help

 

[Fredg]

See Access help regarding AutoExec macros.
In Access 2002, look for:

AutoExec
+ Control how an Access file looks and behaves when it opens
+ Create a Macro that runs when Access first opens

Make a form with whatever info you need.
Then make the Macro to open the form.
Follow the instructions of the above Help file.
Set the macro condition to:
[NextCalDue] <= Date()
As long as the record [NextCalDue] field is less than or equal to the
current date, the macro will fire when the database is opened.

 

[Fredg]

Cam,
My previous answer, I see this morning, was incomplete.

See Access help regarding AutoExec macros.
In Access 2002, look for:

AutoExec
+ Control how an Access file looks and behaves when it opens
+ Create a Macro that runs when Access first opens

Make a Continuous Form with whatever info you need.
Set the Form's RecordSource to a query that will
filter the records and show only those records where
[NextCalDue] <= Date()

Then make a Macro to open the form.
Follow the instructions of the above Help file and
name the macro AutoExec.

The form will open when you open the database.