User alerts for Call log Database

[NealeBabb]

Hi Guys,
I have a call log database that is used to log calls (Obviously), i have serveal users over a network and everything works great, but i have been asked to create an alert function that notifies the user when a new call is logged assigned to them by a different user, similar to outlook when a new email is recieved.

i have an idea of how it will work but need a bit of help,

was planning on having a timer even which checks for new calls every few mins or so and opens up a form to display the new calls which have not been delt with i thought it was gonna be simple but i have come across a few problems.

1. varifying if a new call has been logged
2. displaying only new calls
3. only displaying alert once per new call

I have attached the database but have had to remove all information from the tables for security reasons

i know the coding is messy but it has had several people adding bits to this and has got a bit cluttered, but i will do my best to explain any bits if there is something that looks weired

Thanks in advance

 

[Sketchin]

How do I log in?

 

[NealeBabb]

Passwords for users are their 1st names, all lowercase

 

[NealeBabb]

If any of you are interested, ive managed to create an alert, every 10 seconds it checks for a new call and opens up a form and displays only the calls that have not been read, have attached a copy incase anyone else would like to see how ive done it or wish to improve it at all.