Popup notification

[Luong]

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.

 

[kevin watkins]

Luong,

What you need to do is create a report from a querry that
checks the data field and results in a certain date based
on todays date. Then create a report from that query.
Once this is done the rest can either be done via, on open
or by selecting a button. If you create your Autoexec
macro and in this macro you have print report and this is
the report you want it will run the report. You can fully
automate this so that it prints the report without you
having to do anything. Or you can configure it to just
show the report on the screen. Then in order to print
they would need to click on a button.

You can also have this open a form but I would do the
report thing so that yo could easily print it for sending
to another deprtment or something for confirmation and
scheduling type things.

Hope this helps,

Kevin