|
| 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 | Search this Thread | Display Modes |
|
#1
January 19th 06, 09:13 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Tough One - Update Pivot Chart in Access Report using VBA?
I have posted this on other forums and can't seem to find an answer,
I have a report that is based on a Oracle view. The report contains a chart/Pivot table. I would like to have the chart reflect the new data in the Oracle view. The refresh option in the object doesnt do it. Typically the steps I manually go through to update the chart are this: Open report Click on chart object Click Worksheet Object -- Edit Two toolbars appear - Chart & Pivot Table I click on pivot table bar Click the exclamation mark Update Then an ODBC box appears asking for my username/password Then I close the report saving changes when asked. There has to be a way to do this from VBA. The Chart itself says it's an Unbound Object Frame. (Someone else made it) The Data Tab shows it's an OLE Class - Microsoft Office Excel 2003 display type - content update -automatic OLE TYpe - Embedded OLE Te allowed - Either Class - Excell.Sheet.8 ----- Name - OLEUnbound338 ======================================= Anyone have any ideas? Jerry 
|
| Ads |
|
#2
January 19th 06, 10:01 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Tough One - Update Pivot Chart in Access Report using VBA?
Wrong forum Jerry - try one of the Access (or Excel?) development newsgroups.
-- Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "jer99" wrote: I have posted this on other forums and can't seem to find an answer, I have a report that is based on a Oracle view. The report contains a chart/Pivot table. I would like to have the chart reflect the new data in the Oracle view. The refresh option in the object doesnt do it. Typically the steps I manually go through to update the chart are this: Open report Click on chart object Click Worksheet Object -- Edit Two toolbars appear - Chart & Pivot Table I click on pivot table bar Click the exclamation mark Update Then an ODBC box appears asking for my username/password Then I close the report saving changes when asked. There has to be a way to do this from VBA. The Chart itself says it's an Unbound Object Frame. (Someone else made it) The Data Tab shows it's an OLE Class - Microsoft Office Excel 2003 display type - content update -automatic OLE TYpe - Embedded OLE Te allowed - Either Class - Excell.Sheet.8 ----- Name - OLEUnbound338 ======================================= Anyone have any ideas? Jerry
|
|
#3
January 19th 06, 11:29 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Tough One - Update Pivot Chart in Access Report using VBA?
Sorry - please delete if you can
"Eric Legault [MVP - Outlook]" wrote: Wrong forum Jerry - try one of the Access (or Excel?) development newsgroups. -- Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "jer99" wrote: I have posted this on other forums and can't seem to find an answer, I have a report that is based on a Oracle view. The report contains a chart/Pivot table. I would like to have the chart reflect the new data in the Oracle view. The refresh option in the object doesnt do it. Typically the steps I manually go through to update the chart are this: Open report Click on chart object Click Worksheet Object -- Edit Two toolbars appear - Chart & Pivot Table I click on pivot table bar Click the exclamation mark Update Then an ODBC box appears asking for my username/password Then I close the report saving changes when asked. There has to be a way to do this from VBA. The Chart itself says it's an Unbound Object Frame. (Someone else made it) The Data Tab shows it's an OLE Class - Microsoft Office Excel 2003 display type - content update -automatic OLE TYpe - Embedded OLE Te allowed - Either Class - Excell.Sheet.8 ----- Name - OLEUnbound338 ======================================= Anyone have any ideas? Jerry
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Error report on returned mail. | Buiskop19 | Outlook Express | 13 | February 24th 06 02:26 PM |
| Outlook needs ability to report Junk_mail on Hotmail account | JoKing | Outlook - Using Forms | 0 | February 15th 06 01:57 AM |
| Delete Custom Outlook Control thru Access VBA | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 06:29 PM |
| Cannot Access E-Mail After Security Update | J-Man | Outlook - General Queries | 7 | January 16th 06 11:45 PM |
| Running query from Access Form commmand using VBA code | Berny | Outlook and VBA | 4 | January 16th 06 03:12 PM |
Linear Mode
