Update A Chart In An Unbound Object Frame

T

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
 
T

TC

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

HTH,
TC
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top