Dates triggering events

C

Christopher

I am trying to write a sub procedure that will take a date entry, add a fixed
number to that date, and then on that subsequent date, execute either code or
a sub procedure. Can someone point me in the right direction?
 
D

David Benyo via AccessMonster.com

I would setup another database with whatever info the trigger needs to spit
out. The database would also contain a table/query with all of your trigger
dates. You should build all of your procedures in this database too. You
should also have either 1) an AutoExec Macro, or 2) a script that opens the
database and runs the procedures. Use the Windows Task Scheduler to open the
database or run the script. Your first part of the procedure would simply
test the trigger dates to see if one matches. If one does, run the procedure
(s). If not, stop the application.

Good luck.
 
K

Klatuu

Not enough info to give you a complete answer. Which event you use will be
determined by whether you want to change the date entered so the record is
updated with the modified date or whether you want to retain the date entered
in the form and do something different with the modifed date.

If you could provide a bit more detail on what you want to do, we can show
you how to do it.
 
Top