Can someone please recommend a database type software that can do this for me......

[net1994]

Hi, I need to buy a piece of Database (or some other type/title of software that can do what I?m talking about below) software that can do something like this; Calculate the time in between training session events for employees, and then alert me to the next date that the employee needs to attend. Like if Employee ?X? needs to go to Safety training on August 1, 60 days after the last Safety training session. I need software that will calculate the next necessary session date an employee needs to attend, and then send me some type of alert like a day, or week before the scheduled training session. It would be cool if an on screen notice could be sent to me via E-mail for the next employee that needs training , or maybe when I start the program . Hopefully, there is a drop down type menu where I can set the Notice interval in increments of 1, 5, 10, or 14 days. Can MS Access do something like this? I am sure that SQL or Oracle can do all of this, but is over kill and not needed. So please give me some suggestions as I need a piece of software like this rather soon. Thanks a lot.

 

[Elledan]

(my)SQL is no more overkill than Access.

Depending on the number of employees, you could even use text files for this. Then with a programming language like PHP, Perl, Java, C/C++ or any other, similar language, you can create a program which reguarly checks the database/textfile for employees who must be notified.

 

[net1994]

Unfortunately, I do not have any experience with any of the above-mentioned programming languages; so I am just looking for a on the shelf Program I can go out and buy. Any Ideas??

 

[Elledan]

Hotscripts.com has some good PHP, Perl etc. scripts. These are web based, so you'll have to run them on a webserver.

Anyone with a little experience could write a script which does everything you want BTW. It's not such a complicated task, unless you've any specific preferences regarding how often the program should check the text file/database.

 

[Ladi]

Why go overboard?

Outlook can be set to do this with recurring events/appointments...About all it won't do is send you email, but you can have a popup or just see it in your calendar (or Today screen).

~Ladi