Posted on 2002-06-26
I need to call a SQL SP with this following idea:
Start January 10th
Run once every 2 weeks until January 10th
I don't know how to code VB for this. I know how to code the following:
Do While frmmain.Caption = "Employee Time Tracking Tool"
If Hour(Now) = 6 And Minute(Now) = 35 Then
Set qy9ActiveConnection = conn1
qy9.CommandType = adCmdStoredProc
qy9.CommandText = "sp"