Need to export a pivot chart view of a query

Hello

why not go about this another way. in excel on the data menu choose pivot
table or chart wizard. then use an external data source and point it to the
access database you are using. then point it to the query and create your
pivot table and chart in excel.

then not only do you have a pivot table and corresponding chart, but it is
"live" data, meaning that if you change something in the database, it changes
in your pivot table and chart with a simple refresh.

"makyland" wrote:

I know this post is a bit old... buy maybe I could be of help.

As far as I've found out the "exportpicture" method starts failing after the
upgrade of OWC10.dll. You can check your dll version in path:
C:\Program Files\Common Files\Microsoft Shared\Web Components\10

I've seen it starting to fail from version: 10.0.6765.0

If you're able to get a copy of a previous version of the dll (I can let you
know that version 10.0.5605.0 still works!) you can replace "the newest one"
by the one where the method actually works. (If you don't want to lose the
newest one just rename it and keep it safe...)

However, this is a bit "dirty" if you're trying to distribute the oldest dll
as part of your solution as installation package might not attempt to replace
a newer dll by an older one... and you might end up asking your users to
manually change the dlls... (which is not very ellegant though...). But if
you're using this functionality for yourself it will do!

I'm wondering if this issue has been solved with Access 2007, there is any
hotfix for this for Access 2003 or there is any way to make the method work
with the newer version of the dll.

Has anyone read any direct feedback from Microsoft?

Thanks in advance for any comments on this!






"pcorey" wrote:

That's what I use as well - Access2003. I can't get anything to work! It's
incredibly frustrating. The best solution I've found is to save as a PDF and
then cut out the image from there to paste into Word/Powerpoint.

"sailcm" wrote:

My company recently upgraded to access2003. Now the code that I posted
earlier doesn't work. It's driving me crazy...

"pcorey" wrote:

I've read through the thread and I must be close but I'm still getting errors.

Using the On Double Click property written below I get the error "The
expression you entered refers to an object that is closed or doesn't exist."

Help! Why is it that this is so difficult to do and to find instructions
for? It's a great new feature but useless if it can't be exported.

"sailcm" wrote:

Thanks LeAnne,
I got this to work. I read the rest of the postings where everyone had
trouble and thought I would share...

On the chart's On Double Click property, I put in the following code:

Private Sub Form_dblClick(Cancel As Integer)
Me.ChartSpace.ExportPicture "H:\My Documents\My Pictures\Name.gif", , 930, 720
MsgBox "done"
End Sub

When the chart is open, I can double click anywhere on the chart and the
.gif is created.
By the way, the .gif is clearer & less grainy than the "Ctrl+Print Screen
Paste" method when on powerpoint; and with a little trial and error found
that the 930x720 fits onto the ppt slide without resizing.



"LeAnne" wrote:

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne

This can be an option when you're working "for yourself" and you can either
work with Excel or Access, but if you're designing an application only Access
based and you're not allowed to mess up opening any other Excel views you
might eventually need a procedure to save your pictures as images.

You do also have "live data" in your Access pivot chart and you might not
even need to click "refresh" button as the requery method of the query
recordsource does update data in your Access pivot chart. Also, Access pivot
charts allow more features when compared to Excel's (at least until 2003):
you have multichart, multiple series for scattered plots with approx.
equation and others...

I happened to find a way to programmatically make the last, newest OWC dll
work with this ExportPicture function, in case anyone is interested in.

Regards,



"DawnTreader" wrote:

Hello

why not go about this another way. in excel on the data menu choose pivot
table or chart wizard. then use an external data source and point it to the
access database you are using. then point it to the query and create your
pivot table and chart in excel.

then not only do you have a pivot table and corresponding chart, but it is
"live" data, meaning that if you change something in the database, it changes
in your pivot table and chart with a simple refresh.

"makyland" wrote:

I know this post is a bit old... buy maybe I could be of help.

As far as I've found out the "exportpicture" method starts failing after the
upgrade of OWC10.dll. You can check your dll version in path:
C:\Program Files\Common Files\Microsoft Shared\Web Components\10

I've seen it starting to fail from version: 10.0.6765.0

If you're able to get a copy of a previous version of the dll (I can let you
know that version 10.0.5605.0 still works!) you can replace "the newest one"
by the one where the method actually works. (If you don't want to lose the
newest one just rename it and keep it safe...)

However, this is a bit "dirty" if you're trying to distribute the oldest dll
as part of your solution as installation package might not attempt to replace
a newer dll by an older one... and you might end up asking your users to
manually change the dlls... (which is not very ellegant though...). But if
you're using this functionality for yourself it will do!

I'm wondering if this issue has been solved with Access 2007, there is any
hotfix for this for Access 2003 or there is any way to make the method work
with the newer version of the dll.

Has anyone read any direct feedback from Microsoft?

Thanks in advance for any comments on this!






"pcorey" wrote:

That's what I use as well - Access2003. I can't get anything to work! It's
incredibly frustrating. The best solution I've found is to save as a PDF and
then cut out the image from there to paste into Word/Powerpoint.

"sailcm" wrote:

My company recently upgraded to access2003. Now the code that I posted
earlier doesn't work. It's driving me crazy...

"pcorey" wrote:

I've read through the thread and I must be close but I'm still getting errors.

Using the On Double Click property written below I get the error "The
expression you entered refers to an object that is closed or doesn't exist."

Help! Why is it that this is so difficult to do and to find instructions
for? It's a great new feature but useless if it can't be exported.

"sailcm" wrote:

Thanks LeAnne,
I got this to work. I read the rest of the postings where everyone had
trouble and thought I would share...

On the chart's On Double Click property, I put in the following code:

Private Sub Form_dblClick(Cancel As Integer)
Me.ChartSpace.ExportPicture "H:\My Documents\My Pictures\Name.gif", , 930, 720
MsgBox "done"
End Sub

When the chart is open, I can double click anywhere on the chart and the
.gif is created.
By the way, the .gif is clearer & less grainy than the "Ctrl+Print Screen
Paste" method when on powerpoint; and with a little trial and error found
that the 930x720 fits onto the ppt slide without resizing.



"LeAnne" wrote:

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne

Hi, I will need to do this shortly so I am interested in your resolution
please. I am creating a very detailed report in word direct from Access via a
mail merge, and I would like to have the facility to add a chart
automatically too.

Thanks in advance for any help.
Sue


"makyland" wrote:

This can be an option when you're working "for yourself" and you can either
work with Excel or Access, but if you're designing an application only Access
based and you're not allowed to mess up opening any other Excel views you
might eventually need a procedure to save your pictures as images.

You do also have "live data" in your Access pivot chart and you might not
even need to click "refresh" button as the requery method of the query
recordsource does update data in your Access pivot chart. Also, Access pivot
charts allow more features when compared to Excel's (at least until 2003):
you have multichart, multiple series for scattered plots with approx.
equation and others...

I happened to find a way to programmatically make the last, newest OWC dll
work with this ExportPicture function, in case anyone is interested in.

Regards,



"DawnTreader" wrote:

Hello

why not go about this another way. in excel on the data menu choose pivot
table or chart wizard. then use an external data source and point it to the
access database you are using. then point it to the query and create your
pivot table and chart in excel.

then not only do you have a pivot table and corresponding chart, but it is
"live" data, meaning that if you change something in the database, it changes
in your pivot table and chart with a simple refresh.

"makyland" wrote:

I know this post is a bit old... buy maybe I could be of help.

As far as I've found out the "exportpicture" method starts failing after the
upgrade of OWC10.dll. You can check your dll version in path:
C:\Program Files\Common Files\Microsoft Shared\Web Components\10

I've seen it starting to fail from version: 10.0.6765.0

If you're able to get a copy of a previous version of the dll (I can let you
know that version 10.0.5605.0 still works!) you can replace "the newest one"
by the one where the method actually works. (If you don't want to lose the
newest one just rename it and keep it safe...)

However, this is a bit "dirty" if you're trying to distribute the oldest dll
as part of your solution as installation package might not attempt to replace
a newer dll by an older one... and you might end up asking your users to
manually change the dlls... (which is not very ellegant though...). But if
you're using this functionality for yourself it will do!

I'm wondering if this issue has been solved with Access 2007, there is any
hotfix for this for Access 2003 or there is any way to make the method work
with the newer version of the dll.

Has anyone read any direct feedback from Microsoft?

Thanks in advance for any comments on this!






"pcorey" wrote:

That's what I use as well - Access2003. I can't get anything to work! It's
incredibly frustrating. The best solution I've found is to save as a PDF and
then cut out the image from there to paste into Word/Powerpoint.

"sailcm" wrote:

My company recently upgraded to access2003. Now the code that I posted
earlier doesn't work. It's driving me crazy...

"pcorey" wrote:

I've read through the thread and I must be close but I'm still getting errors.

Using the On Double Click property written below I get the error "The
expression you entered refers to an object that is closed or doesn't exist."

Help! Why is it that this is so difficult to do and to find instructions
for? It's a great new feature but useless if it can't be exported.

"sailcm" wrote:

Thanks LeAnne,
I got this to work. I read the rest of the postings where everyone had
trouble and thought I would share...

On the chart's On Double Click property, I put in the following code:

Private Sub Form_dblClick(Cancel As Integer)
Me.ChartSpace.ExportPicture "H:\My Documents\My Pictures\Name.gif", , 930, 720
MsgBox "done"
End Sub

When the chart is open, I can double click anywhere on the chart and the
.gif is created.
By the way, the .gif is clearer & less grainy than the "Ctrl+Print Screen
Paste" method when on powerpoint; and with a little trial and error found
that the 930x720 fits onto the ppt slide without resizing.



"LeAnne" wrote:

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne

Did you finally manage to get a way to exprot access pivot cahrts to a word
document ? Would you mind sharing the method ?

"hughess7" wrote:

Hi, I will need to do this shortly so I am interested in your resolution
please. I am creating a very detailed report in word direct from Access via a
mail merge, and I would like to have the facility to add a chart
automatically too.

Thanks in advance for any help.
Sue


"makyland" wrote:

This can be an option when you're working "for yourself" and you can either
work with Excel or Access, but if you're designing an application only Access
based and you're not allowed to mess up opening any other Excel views you
might eventually need a procedure to save your pictures as images.

You do also have "live data" in your Access pivot chart and you might not
even need to click "refresh" button as the requery method of the query
recordsource does update data in your Access pivot chart. Also, Access pivot
charts allow more features when compared to Excel's (at least until 2003):
you have multichart, multiple series for scattered plots with approx.
equation and others...

I happened to find a way to programmatically make the last, newest OWC dll
work with this ExportPicture function, in case anyone is interested in.

Regards,



"DawnTreader" wrote:

Hello

why not go about this another way. in excel on the data menu choose pivot
table or chart wizard. then use an external data source and point it to the
access database you are using. then point it to the query and create your
pivot table and chart in excel.

then not only do you have a pivot table and corresponding chart, but it is
"live" data, meaning that if you change something in the database, it changes
in your pivot table and chart with a simple refresh.

"makyland" wrote:

I know this post is a bit old... buy maybe I could be of help.

As far as I've found out the "exportpicture" method starts failing after the
upgrade of OWC10.dll. You can check your dll version in path:
C:\Program Files\Common Files\Microsoft Shared\Web Components\10

I've seen it starting to fail from version: 10.0.6765.0

If you're able to get a copy of a previous version of the dll (I can let you
know that version 10.0.5605.0 still works!) you can replace "the newest one"
by the one where the method actually works. (If you don't want to lose the
newest one just rename it and keep it safe...)

However, this is a bit "dirty" if you're trying to distribute the oldest dll
as part of your solution as installation package might not attempt to replace
a newer dll by an older one... and you might end up asking your users to
manually change the dlls... (which is not very ellegant though...). But if
you're using this functionality for yourself it will do!

I'm wondering if this issue has been solved with Access 2007, there is any
hotfix for this for Access 2003 or there is any way to make the method work
with the newer version of the dll.

Has anyone read any direct feedback from Microsoft?

Thanks in advance for any comments on this!






"pcorey" wrote:

That's what I use as well - Access2003. I can't get anything to work! It's
incredibly frustrating. The best solution I've found is to save as a PDF and
then cut out the image from there to paste into Word/Powerpoint.

"sailcm" wrote:

My company recently upgraded to access2003. Now the code that I posted
earlier doesn't work. It's driving me crazy...

"pcorey" wrote:

I've read through the thread and I must be close but I'm still getting errors.

Using the On Double Click property written below I get the error "The
expression you entered refers to an object that is closed or doesn't exist."

Help! Why is it that this is so difficult to do and to find instructions
for? It's a great new feature but useless if it can't be exported.

"sailcm" wrote:

Thanks LeAnne,
I got this to work. I read the rest of the postings where everyone had
trouble and thought I would share...

On the chart's On Double Click property, I put in the following code:

Private Sub Form_dblClick(Cancel As Integer)
Me.ChartSpace.ExportPicture "H:\My Documents\My Pictures\Name.gif", , 930, 720
MsgBox "done"
End Sub

When the chart is open, I can double click anywhere on the chart and the
.gif is created.
By the way, the .gif is clearer & less grainy than the "Ctrl+Print Screen
Paste" method when on powerpoint; and with a little trial and error found
that the 930x720 fits onto the ppt slide without resizing.



"LeAnne" wrote:

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne

I want to export Access 2003 query based pivot charts to a word document-
mind can you explain your method or even better share the program ?

"makyland" wrote:

This can be an option when you're working "for yourself" and you can either
work with Excel or Access, but if you're designing an application only Access
based and you're not allowed to mess up opening any other Excel views you
might eventually need a procedure to save your pictures as images.

You do also have "live data" in your Access pivot chart and you might not
even need to click "refresh" button as the requery method of the query
recordsource does update data in your Access pivot chart. Also, Access pivot
charts allow more features when compared to Excel's (at least until 2003):
you have multichart, multiple series for scattered plots with approx.
equation and others...

I happened to find a way to programmatically make the last, newest OWC dll
work with this ExportPicture function, in case anyone is interested in.

Regards,



"DawnTreader" wrote:

Hello

why not go about this another way. in excel on the data menu choose pivot
table or chart wizard. then use an external data source and point it to the
access database you are using. then point it to the query and create your
pivot table and chart in excel.

then not only do you have a pivot table and corresponding chart, but it is
"live" data, meaning that if you change something in the database, it changes
in your pivot table and chart with a simple refresh.

"makyland" wrote:

I know this post is a bit old... buy maybe I could be of help.

As far as I've found out the "exportpicture" method starts failing after the
upgrade of OWC10.dll. You can check your dll version in path:
C:\Program Files\Common Files\Microsoft Shared\Web Components\10

I've seen it starting to fail from version: 10.0.6765.0

If you're able to get a copy of a previous version of the dll (I can let you
know that version 10.0.5605.0 still works!) you can replace "the newest one"
by the one where the method actually works. (If you don't want to lose the
newest one just rename it and keep it safe...)

However, this is a bit "dirty" if you're trying to distribute the oldest dll
as part of your solution as installation package might not attempt to replace
a newer dll by an older one... and you might end up asking your users to
manually change the dlls... (which is not very ellegant though...). But if
you're using this functionality for yourself it will do!

I'm wondering if this issue has been solved with Access 2007, there is any
hotfix for this for Access 2003 or there is any way to make the method work
with the newer version of the dll.

Has anyone read any direct feedback from Microsoft?

Thanks in advance for any comments on this!






"pcorey" wrote:

That's what I use as well - Access2003. I can't get anything to work! It's
incredibly frustrating. The best solution I've found is to save as a PDF and
then cut out the image from there to paste into Word/Powerpoint.

"sailcm" wrote:

My company recently upgraded to access2003. Now the code that I posted
earlier doesn't work. It's driving me crazy...

"pcorey" wrote:

I've read through the thread and I must be close but I'm still getting errors.

Using the On Double Click property written below I get the error "The
expression you entered refers to an object that is closed or doesn't exist."

Help! Why is it that this is so difficult to do and to find instructions
for? It's a great new feature but useless if it can't be exported.

"sailcm" wrote:

Thanks LeAnne,
I got this to work. I read the rest of the postings where everyone had
trouble and thought I would share...

On the chart's On Double Click property, I put in the following code:

Private Sub Form_dblClick(Cancel As Integer)
Me.ChartSpace.ExportPicture "H:\My Documents\My Pictures\Name.gif", , 930, 720
MsgBox "done"
End Sub

When the chart is open, I can double click anywhere on the chart and the
.gif is created.
By the way, the .gif is clearer & less grainy than the "Ctrl+Print Screen
Paste" method when on powerpoint; and with a little trial and error found
that the 930x720 fits onto the ppt slide without resizing.



"LeAnne" wrote:

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne