By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Update A Chart In An Unbound Object Frame

P: n/a
Tom
I have an unbound object frame on a subreport containing a chart linked to a
chart in an Excel worksheet. I can open the subreport in design view, select the
unbound frame, go to Edit - OLE/DDE Links, click on Links in the dialog that
appears and click on the Update Now button and the chart updates.

Can the above be done programatically at runtime?

Can the above be done programatically before the subreport opens?

Thanks!

Tom


Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
TC
Just a guess, but, see if there is a Runcommand constant for this. (I don't
have Access here to check.)

HTH,
TC
"Tom" <th*******@earthlink.net> wrote in message
news:Mp******************@newsread2.news.atl.earth link.net...
I have an unbound object frame on a subreport containing a chart linked to a chart in an Excel worksheet. I can open the subreport in design view, select the unbound frame, go to Edit - OLE/DDE Links, click on Links in the dialog that appears and click on the Update Now button and the chart updates.

Can the above be done programatically at runtime?

Can the above be done programatically before the subreport opens?

Thanks!

Tom

Nov 12 '05 #2

P: n/a
Hi Tom,

Check out the Action property and acOLEUpdate constant of the
ObjectFrame control; also, perhaps, the ObjectVerbs and Verb properties.

AFAIK you can't do anything before the subreport opens (because it's not
there to do it to<g>), but I think you'll find that the Format event of
the relevant section of the subreport runs at a suitable time.
On Thu, 18 Sep 2003 14:36:28 GMT, "Tom" <th*******@earthlink.net> wrote:
I have an unbound object frame on a subreport containing a chart linked to a
chart in an Excel worksheet. I can open the subreport in design view, select the
unbound frame, go to Edit - OLE/DDE Links, click on Links in the dialog that
appears and click on the Update Now button and the chart updates.

Can the above be done programatically at runtime?

Can the above be done programatically before the subreport opens?

Thanks!

Tom


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.