Alerting

[ohio]

Anyone know how to write a code in order to alert those outstanding call logs after 7 days. My form has Status field and Date Logged field, how to link up in order to alert such way.

I think can use DateAdd or DateDiff but i am new to VB code, hence will need some expertise.

 

[DES]

Your right it will need to use a DateDiff statement somewhere. The question becomes where do you want it and how do you want it to visually appear.

I can think of a number of different ways to do it. It can be done on an OnCurrent so that when you are at the record it will tell you if it is not right. It can be done from a single location telling you how many are late. Etc.

If you would like to be a little more specific about what you are looking for or just want to talk it over email me

 

[ohio]

Nice to hear from you, I think the better way is when the user open a new form to create new log, the alert will popped up to tell him those > 7 days outstanding logs. Something as your 1st suggestion. Any clues?

Really appreciate your guidance. Thanks!

 

[DES]

OK we will try it this way! A little slower but here goes.

First of all you are going to need some way to capture the fact that there is an error. This is going to probably done the easiest in a query. Once you capture the fact that one or more records have the error you want then you have to figure out what to do with it.

A method I use a lot is to put an unbound text box on the form you want to be notified from of the error. The datasource for this text box is then a DCount of the query you just made. This will display a number of how many records match this error.

At this point you can add a button beside this text box to open a form which uses the query you made as a datasource and allows the user to see and or fix the error.

Of course the error we are talking about deals with something being more then 7 days old. So the query will have to have a new field put in it for a datediff("d","[WhateverDateYouWant]","Now()") Of course it may be necessary to format the Now() statement to match the format for your date. The criteria for this field should be >6

Again if you need more info or want to discuss this more EMAIL me because I do not check back here very often.