Popup message

  • Thread starter Thread starter Cam
  • Start date Start date
C

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
 
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.
 
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.
 
Back
Top