MsgBox Alerting Call Ending?

[charlesandrews]

Hi,

I am creating a small call logging database and I would like the user to receive a message 1minute before the call is due to end.

I was thinking something like:

if [callend] =now() then msgbox "Call Due To End"

Can anyone help?

Many thanks
Charlie

PS, I have searched, but to no avail as yet!!!!

 

[charlesandrews]

Anyone?

 

[Mile-O]

You may have to give more information about your database as the details you've given are very sparse.

 

[charlesandrews]

Hi SJ,

I see exactly what you mean. Sorry

Ok, here goes ....

I have three fields as follows:

CallStart, CallEnd and Cost.
If the user clicks on call start on a form, the call start field is automatically set with the date and time as per click. On the cost field, If the user types in £10.00 then the call end automatically logs the duration as 15mins. If the user enters £20.00 then the call end field sets the duration as 30min call.
There will be times when many calls are in progress and I would like a pop up message informing the user that a call is due to end.

Many thanx