Garan,
You can use the OnTimer event of a form which will always be open in
the database, to check the time every so often, and run the macro if
your date/time condition is met. This assumes the database will be
open at the time you want to run the macro. If not, you can use a
Scheduling programme such as Windows Task Manager, to launch it at a
specified time.
If you need more specific help, please post back with more details of
what you want, and how precise you need the timing to be.
- Steve Schapel, Microsoft Access MVP