John, what problem do you have with the configuration file storing the last credit check date and automatically running the routine daily? Does this not do what you require?
Joe
>hello christof.
>thanks. sounds like a good idea.but you have given solution considering that something event fires (like placing order)which will check the validation on ole server.but in my case i don't want credit limit , i want to check due date.
>so if there are not any forms open in my system and even if it is running in minimized mode, as soon as due date comes, it should popup the message.i have discussed this with others.and as such this is very odd requirement for dbms application.so i am thinking to drop idea and ask client to print report(simple!)still welcome any suggestion.
>thanksverymuch
>john still
Joseph C. Kempel
Systems Analyst/Programmer
JNC