Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MSChart
- Thread starter gazflat33
- Start date
- Thread starter
- #2
Hello gazflat33,
you should use an array and then pass the data to the Chart.
With chtData
.chartType = VtChChartType2dBar
.ChartData = retrdata.GetData(vColNames)
.TitleText = "Weekly Pharmacy Data"
end with
the retrdata is a module created by me so just create a module with a function called getdata or similar.
declare the method as a public one like
Public Function GetData(ColNames() As Variant) As Variant
remeber to declare a variant type in the form as well "vColNames".
inside the methos read the data from the db using adodb.recordsets and pass the values to the array and the assign the array to the function.
hope it was clear.
you should use an array and then pass the data to the Chart.
With chtData
.chartType = VtChChartType2dBar
.ChartData = retrdata.GetData(vColNames)
.TitleText = "Weekly Pharmacy Data"
end with
the retrdata is a module created by me so just create a module with a function called getdata or similar.
declare the method as a public one like
Public Function GetData(ColNames() As Variant) As Variant
remeber to declare a variant type in the form as well "vColNames".
inside the methos read the data from the db using adodb.recordsets and pass the values to the array and the assign the array to the function.
hope it was clear.
- Status
Similar threads
