Problem with "ExportPicture" method of Chart object

[Rob Millman]

I'm having a problem using the ExportPicture Method of the chart object. I
get and Error 430. What is very strange is that there is a Microsoft
Knowledge base article KB # 824276 which is related to this problem and in
the KB article there is extensive steps for an example. However, the example
DOESN"T WORK as described in the KB article !! When I follow their example, I
get the Error 430 that I'm trying to solve. How do I get someone at
Microsoft to address this issue.

Thanks

R Millman

 

[TC]

Rob, when you're asking for help with a programming error, you really
need to give us the exact (full) text of the error message, and show us
the line of code that the error occurs on - and preferably some lines
before & after it.

TC (MVP Access)
http://tc2.atspace.com

 

[Rob Millman]

Well, under normal circumstances I would include more than enough detail.
However, in this case, the problem is directly reproducible following the
explicit step by step instructions in the KB article #824276!! Didn't think
I needed to cut and paste it into the thread.

 

[privatenews]

Hello,

I followed the steps documented in KB 824276 and I was able to reproduce
the issue. Then I was able to fix the problem by adding " Me.graph1.Action
= acOLEClose" in the code.

Will you please create a new form in northwind as described to see if you
could reproudce and fix the problem in that database?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

 

[Rob Millman]

Peter,

I appologize, but its been several weeks since I first ran into this issue
and it took me a little while to "fix" my anti-spam alias so that I recieved
community support. I have reconstructed my original work.

I took the northwind database, reproduced the problem/issue as described.
You are correct that the first suggested solution of setting the
..action=acOLEClose does indeed "fix" the problem as identified in the KB.
However, if you attempt to implement the second solution, which is to use a
PivotChart, you should receive an error 430.

I am using a PivotChart, trying to export to a file, and running into this
error 430. This KB article actually runs into the same error, if you follow
the second solution.

My real goal is solving this 430 error on ExportPicture on a PivotChart.

Rob Millman

 

[TC]

Hi Rob

The point of asking you to provide that infomation, was this.

When people answer many questions, they have to make the process as
efficient as it possibly can be - or it takes up the whole day! For
that reason, most of us simply don't have time to find a referenced
article, fire up Access, copy it all in, perhaps create & populate some
table structures, read the istructions, and so on. We just can't do
that; it is not a reasonable thing to expect.

Also, many errors are immediately apparent, just by seeing the full
error message, the line of code, and some lines before & after. Given
that fact, many of us are reluctant to load & run any code, even if we
had the time. To put it differently, there's no point lifting a 10 ton
weight, if you can get away with lifting a 5 pound one!

So that is why I asked you to provide more details in your post.

Cheers,
TC (MVP Access)
http://tc2.atspace.com

 

[TC]

I should add, I'm only speaking for myself, above.

Other regular posters might or mightn't agree.

TC

 

[privatenews]

Hello,

This is due to a change in OWC. Code was added to query the host to
determine the current IE security zone. If it cannot be determined, an
error is returned.

As a workaround, we can create a second unhosted/invisible instance of each
control and use the XMLData from the hosted control to populate the
unhosted. In this
scenario, we also had to set the DataSource property of the unhosted Chart
to the unhosted Pivot.


Private Sub Command2_Click()

Dim frm As Access.Form

Set frm = Me.frmPivotChart.Form


Dim oTemp As OWC10.ChartSpace
Set oTemp = CreateObject("OWC10.ChartSpace")


oTemp.XMLData = frm.ChartSpace.XMLData
oTemp.DataSource = frm.PivotTable

oTemp.ExportPicture "C:\PivotChart1.jpg", "JPEG", Width:=1024,
Height:=700

Set oTemp = Nothing


End Sub

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

Thread-Topic: Problem with "ExportPicture" method of Chart object
thread-index: AcZavkFue0vwQwXjR5eCgJN2dsZ2yA==
X-WBNR-Posting-Host: 24.12.153.173
From: =?Utf-8?B?Um9iIE1pbGxtYW4=?= <[email protected]>
References: <[email protected]>

<[email protected]>

 

[Rob Millman]

Peter,

THANK YOU...THANK YOU...

a couple of follow up questions -- How are you aware that this is a result
of a specific change, and details of the change and work around? Is there an
information source I am not aware of? I had searched virtually everywhere.
i'm just wondering what other information is out there .

thanks again,

Robert Millman

 

[privatenews]

Hello Robert,

I found a similar issue in our database. Please rest assured that the
feedback to update KB 824276 is routed to the proper channel. Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Rob Millman]

A follow up question/issue: If I take your code as is, everything works
(thanks). If I change all references from OWC10 to OWC11, including the
project references. I get a "permission denied" error on the DataSource
assignment statement. Any info on what's going on here between OWC10 and 11?

 

[privatenews]

Hello,

I think the code is only for OWC 10 currently. Some interfaces/structure in
OWC 11 is not same as OWC10.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.