If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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 |
#22
|
|||
|
|||
Need to export a pivot chart view of a query
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 |
#23
|
|||
|
|||
Need to export a pivot chart view of a query
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 |
#24
|
|||
|
|||
Need to export a pivot chart view of a query
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 |
#25
|
|||
|
|||
Need to export a pivot chart view of a query
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Saving Pivot Table view of Query | Katie | Running & Setting Up Queries | 3 | October 4th, 2004 03:56 PM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
export 1 query multiple times to 1 excel file | WALRUSIM | Running & Setting Up Queries | 1 | June 19th, 2004 04:13 AM |
export 1 query 5 times to 1 excel file | Mike_Walrus | Running & Setting Up Queries | 0 | June 19th, 2004 02:00 AM |