Is there any way to get the status back from a call to Execute off of a ADODB Connection? This is a tall order I know but I thought I would ask.
If impossible, how do I get my timer control to fire so that I can update an elapsed time section in a status bar, like Query Analyzer?
I have implemented my timer like this:
Private ProcessStartTime datetime
Private bInProcess as boolean
Dim conDB as New ADODB.Connecton
bInProcess = True
ProcessStartTime = Now()
bInProcess = False
Private Sub tmrProgress_Timer()
If bInProcess = True Then
frmMain.stbrMain.Panels(4).Text = Mid(CDate(Now() - ProcessStartTime), 4, 5)