X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Getting Round Pivotchartclass In Ms Access 2013, Access 2013    
post Sep 7 2017, 09:43 PM

Posts: 92
Joined: 18-May 04

I have an application that was originally developed in Ms Access 2007 in which charts were running perfectly ok. However, when the application is opened in an Ms Access 2013 environment, the charts cannot run anymore but instead throw the error message: Run-time error '-2147467259 (80004005)
And the offending code is second line of the following:

Set PivotChart = New PivotChartClass
PivotChart.ChartSpace = Me.DynamicSubform.Form.ChartSpace

I searched on the internet for a possible cause and discovered that "PivotChartClass" has been discontinued by Microsoft. My question is "Is there a way of getting round this as a lot of code has been invested to produce the charts."

Go to the top of the page
Doug Steele
post Sep 20 2017, 04:59 PM

UtterAccess VIP
Posts: 21,915
Joined: 8-January 07
From: St. Catharines, ON (Canada)

The only option I'm aware of is what Microsoft claimed as their justification for scrapping the feature: Excel does it better.

You might have to bite the bullet and redo all of the charts through automation of Excel.

Sorry: I'm sure that's not what you wanted to hear! Good luck with your project (and feel free to post more questions if you have questions about automating Excel)

Doug Steele, Microsoft Access MVP (2000-2018)
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Co-author: Effective SQL: 61 Specific Ways to Write Better SQL, published by Addison-Wesley Professional
Technical Editor: Access 2010 Bible, Access 2013 Bible, Access 2016 Bible, all published by Wiley
Technical Editor: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition, published by Addison-Wesley Professional
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    19th September 2018 - 05:54 AM