Selasa, 29 Juli 2014

Re: [MS_AccessPros] Powerpoint Graph linked to Access Query

 

Jeff and Duane,

Thanks for the replies. Most of the charts in our Powerpoint are Excel based so I'm taking the approach to llink Excel to Access, putting the chart there and then linking Powerpoint to Excel. I'm having problems creating the link to the data in Excel. I have an Access totals query that gives me the data totaled by week but I haven't been able to Link to that query yet. I can link to the table but I haven't been able to total the data by week. So that's where I'm at now. If you can tell me how to successfully link to the Access query I'd be grateful.
Doyce



---In MS_Access_Professionals@yahoogroups.com, <jpjones23@...> wrote :

Doyce,

 

To put it mildly, PowerPoint is a pain in the database.  It doesn't, like Word or Excel, have automatic support to execute VBA code upon opening.  Sure it will execute VBA code but the code needs be created and then saved as an add-in and then added to the presentation.  To top it off, if there's a desire to have the user initiate an event, the normal user buttons to be pressed need to be created dynamically upon opening the presentation and once created, the macro to be executed has to be assigned to the button.  All this wonderfulness needs be placed in the aforementioned add-in.

 

However, there's an existing free add-in that can be downloaded from the following site: http://skp.mvps.org/autoevents.htm  This add-in will provide support for auto events.  The code to update a chart will still need to be written.

 

Then there's the fact that every object on every slide is unique so if, for example, data in a textbox needs to be updated, every object on a slide will need to be tested, once the correct slide is found, to determine if it's a text box and then if it is, a test needs be made to be certain that it's the correct text box.

 

It's not clear how often the chart needs be updated or by whom or if the users are geographically dispersed.  It seems to me that some event in Access needs to be executed to update the data.  I'd look into having that event update data in Excel and then would link an Excel graph or chart to the PowerPoint presentation.  I know that it's easier to link a graph or chart in Excel to a slide in PowerPoint so that the presentation is automatically updated.

Thus endth my 02 cents,

Jeff

From: "Duane Hookom duanehookom@... [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "Access Professionals Yahoo Group" <ms_access_professionals@yahoogroups.com>
Sent: Tuesday, July 29, 2014 10:41:23 AM
Subject: RE: [MS_AccessPros] Powerpoint Graph linked to Access Query

 

I have been building and formatting charts based on data from SQL Server. I doubt there would be much difference from Access. The process I use takes a fair amount of VBA to connect to the data and populate the chart data. Having worked with VBA in Access, I hate the PPT object model. Either it is arbitrary or I am old and confused (probably the second).
 
Let me know if you would like to see some code.
 
Duane Hookom MVP
MS Access
 
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 29 Jul 2014 05:23:37 -0700
Subject: [MS_AccessPros] Powerpoint Graph linked to Access Query



 Hello friends,
I want to link a chart in Powerpoint to Access data and have it refreshed whenever the presentation is opened. My searches for the procedures to follow have not yielded anything I can make work.Can one of you please point me in the right direction or tell me how to do this?
Doyce





--
---

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
http://ExcelAndAccess.Com

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@...


__._,_.___

Posted by: winberry.doyce@roadsysinc.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Tidak ada komentar:

Posting Komentar