Dim WithEvents rs As ADODB.RecordsetPrivate Sub rs_FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset) ProgressBar1.Max = MaxProgress ProgressBar1.Value = Progress End Sub
Dim WithEvents rs As ADODB.RecordsetPrivate Sub rs_FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset) ProgressBar1.Visible = True ProgressBar1.Max = MaxProgress ProgressBar1.Value = Progress ProgressBar1.ReFresh End SubPrivate Sub rs_FetchComplete(ByVal pError As ADODB.Error, _ adStatus As ADODB.EventStatusEnum, _ ByVal pRecordset As ADODB.Recordset)
If adStatus <> adStatusOK Then Debug.Print "Failed" MsgBox "Error: " & pError.Number & vbCrlf & pError.Description, , "Failed" Else Set DataGrid1.DataSource = pRecordset MsgBox "Done" End If ProgressBar1.Visible = False End Sub
ProgressBar1.Max = MaxProgress
ProgressBar1.Value = Progress
End Sub
ProgressBar1.Visible = True
ProgressBar1.Max = MaxProgress
ProgressBar1.Value = Progress
ProgressBar1.ReFresh
End SubPrivate Sub rs_FetchComplete(ByVal pError As ADODB.Error, _
adStatus As ADODB.EventStatusEnum, _
ByVal pRecordset As ADODB.Recordset)
If adStatus <> adStatusOK Then
Debug.Print "Failed"
MsgBox "Error: " & pError.Number & vbCrlf & pError.Description, , "Failed"
Else
Set DataGrid1.DataSource = pRecordset
MsgBox "Done"
End If
ProgressBar1.Visible = False
End Sub