Jan: You helped me sooooo many times, I will give you my advice.
I tried R:azzak's idea using the timer. It did not work well for me. I set the timer to 86400000 (the number of miliseconds in a day). It would then check my database once a day and perform a task. The problem with this is that if the computer is rebooted, turned off, crashes, etc., the timer begins anew when the database is turned on regardless when the the last reminder was sent. Here is how I got around the issue:
My database contains a table called POC (Point of Contact). POC contains contact information regarding our Points of Contact at each of our partner hospitals. Such information includes Name, e-mail address and the date of the last time a record was updated. Each record should be updated by the Point of Contact every 90 days.
I developed a command file separate from my database application. In the command file I open my database. I then have the program in the command file check each record of the POC table and if a record is 83 days old, it will extract the pertinent information from the record (in particular the Name and e-mail address) and using R:Mail sends a message that the Point of Contact needs to update his/her information within a week. It will then check the POC Table for records that are 89 days old. If the program finds such a record, it sends the Point of Contact a message that his/her records needs to be updated by the next day. The program then checks for records that are 90 days old and reminds the Point of Contact that the update is due that day. If the record is over 90 days since the last update, the program reminds the Point of Contact that the update is past due, every day until he/she updates the record. Once the record is updated, the POC Form resets the update date automatically. We call this process compliance by spam.
Once the command file is completed, it is COMPILED using R:Base Compiler. Windows has a Task Scheduler. I set the Task Scheduler to run the COMPILED program Daily at 2:00 AM. At that point the COMPILED program checks the POC Table at 2:00 AM every day and sends out reminders as necessary.
I hope this helps Stuart J. Cohen, Ph.D. Major, Medical Service Corps Research Specialist Walter Reed Army Medical Center National Disaster Medical System Federal Coordinating Center Phone: 202-782-3636 Cell: 301-514-3975 Fax: 202-782-4360 E-mail: [EMAIL PROTECTED] jan johansen wrote:
Hello, Has anyone created a recurring reminders inside R:Base? Pretty sure Razzak will chime in with R:Scheduler but I 'm wondering about anything else some one has done. Jan p.s. Razzak. I'm not dissing R:Scheduler and am considering the product
