Hi
I have a VB6 program that connect to a table"Schedule",this table has 2 fields:Meeting Description and Date,when the program loads,it should read each record and compare its date field with now(),if it's equal,a MsgBox appears telling the user about the meeting,this process must be done every 3 minutes.
My problem is that I don't want to open a recordset every 3 minutes to compare the date with now,so i was thinking of storing the recordset obtained from the form load and instead of looping through the recorset to view the meeting that has a date=now() to loop through the stored recorset.
can anyone have an idea about how to do it?
thanks