HSdba
asked on
Microsoft Chart 6.0 in Access 2000 OLE Error
I have created a report and placed a Microsoft Chart 6.0 ActiveX object in it, and I was attempting to link the chart to a query result set...
I've gotten to the following point with my code:
Dim objChart As Chart
Set objChart = Me.MyChart.Object.Applicat ion.Chart
objChart.DataTable = "Qry Milestones by Program 04"
And on the set objChart line I keep getting an error message that states:
Run-time error '2771':
The bound or unbound object frame you tried to edit doesn't contain an OLE object
Please help - The query results contain data categorized and totaled by month, and I need to use this control so that I can have a combonation chart with bars, stacked bars, lines, and area graphs for different series of data.
Thanks!
I've gotten to the following point with my code:
Dim objChart As Chart
Set objChart = Me.MyChart.Object.Applicat
objChart.DataTable = "Qry Milestones by Program 04"
And on the set objChart line I keep getting an error message that states:
Run-time error '2771':
The bound or unbound object frame you tried to edit doesn't contain an OLE object
Please help - The query results contain data categorized and totaled by month, and I need to use this control so that I can have a combonation chart with bars, stacked bars, lines, and area graphs for different series of data.
Thanks!
ASKER
The .mdb file is shared via a network drive by 6-12 users. I am working with a separate copy of it right now for development purposes. As for licensing, how would I figure out if my client has it? I didn't actually design the database itself - I "inherited" it, but the control is available on the list of "other tools"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks - I figured out how to do it using Graph 2000
If this is on an enduser machine, you'll have to make sure that you correctly deploy the control to all users.