It seems that every time I instantiate a new datareport and then call the
show method the memory usage on my machine goes up but when I close the form
the memory usage does not go down. Then every subsequent time or so I show
it again, the usage goes up even further and does not leave until I shut
down the entire program. Even if I close down the form that called it in
the first place, the memory usage still stays up.
Any Ideas?
Case "Worksheet"
Set DRReport = New drWorksheet
Set DRReport.DataSo urce = Nothing
Set DRReport.DataSo urce = deReports
DRReport.DataMe mber = "cmdContactWork sheet"
If deReports.rscmd ContactWorkshee t.state <> 0 Then
deReports.rscmd ContactWorkshee t.Close
deReports.cmdCo ntactWorksheet CDbl(parameter)
Else
deReports.cmdCo ntactWorksheet CDbl(parameter)
End If
DRReport.Refres h
DRReport.Show 'vbModal
show method the memory usage on my machine goes up but when I close the form
the memory usage does not go down. Then every subsequent time or so I show
it again, the usage goes up even further and does not leave until I shut
down the entire program. Even if I close down the form that called it in
the first place, the memory usage still stays up.
Any Ideas?
Case "Worksheet"
Set DRReport = New drWorksheet
Set DRReport.DataSo urce = Nothing
Set DRReport.DataSo urce = deReports
DRReport.DataMe mber = "cmdContactWork sheet"
If deReports.rscmd ContactWorkshee t.state <> 0 Then
deReports.rscmd ContactWorkshee t.Close
deReports.cmdCo ntactWorksheet CDbl(parameter)
Else
deReports.cmdCo ntactWorksheet CDbl(parameter)
End If
DRReport.Refres h
DRReport.Show 'vbModal