Remind me after hour variable

[lucour]

Hi,

I have developed an Access Input form, for a user responsible for tracking past due payment accounts within a company. This user is responsible for calling the people, and logging the date and time that the call was made. I have a command button setup on the form that the user clicks, and enters the time the call was made. My need ? There could be up to 100 people that a user is investigating at one time, so if they cannot reach one person they will move on to the next. However, they have to go back to the people who they miss. They have to be prompted to do so, however. Thus, I would like for them to be able to select a number, from a dropdown box, representing 'hours', and use this number against the last entry in the Last_Called field. For example, if they last contacted 'John Smith' at 07:06:19 AM, and they set the call back variable to 2 (hours), then at 09:06 AM, I want the user to be prompted to contact this person again. How do I add the hour variable, to the Last_Called field, and then prompt the user when the resulting time has arrived ?

Thanks !!

 

[missinglinq]

Calculating the "recall time" will be easy! You'll need a field we'll call Next_Call and a combobox we'll call ReCallCombo. Use the combobox wizard to create the dropdown, filling in the hours that you want to appear. Then this code

Private Sub ReCallCombo_Click()
  Next_Call = DateAdd("h", Me.ReCallCombo, Last_Called)
End Sub

The next part will take a bit of work that I simply don't have the time to do for you. Sorry! I have to tell you, having a "prompt" popup when each recall comes due sounds like a bad idea to me. You could do it, using the Timer event of the form to check and see who's due for a recall, then popping up a message box to announce it, but think about it! Say your user makes these calls that are unsuccessful:

Joe Blow 7:15
Jane Doe 7:16
John Smith 7:16
Alex Bell 7:17

User set recall at 2 hours

At 9:15 alarm goes off for Joe Blow. User calls Joe Blow gets him. While talking to him, alarms go off for:

Jane Doe @ 9:16
John Smith @ 9:16
Alex Bell @ 9:17
etc...

You see the problem? Very distracting for a CSR trying to talk to a client! I'd be more inclined to have a button to do a requery of your RecordSource for the form that would sort by the Next_Call field, so that the earliest calls to make would come up first. The user could then check to see who to recall at a time when he/she wasn't in the middle of something.

Just my 2 cents worth! Maybe someone else will have a better idea.

Good Luck!