Recent content by RichBLACKIII

I can't seem to figure out how to reference a chart through its filepath to embed in my Access form in an Unbound Object Frame. I need to reference several charts from different worksheets and embed them also, so I need to figure out how reference them via their filepath name. Here is an example...

I happend to stumble upon the answer.........You must be in Form View in your database and actually Call the Unbound Object from your database. I found the location of the frame in the references section. Thanks. Public Sub EmbedExisting_Click() Dim ctl As Control Set ctl =...

Yes, that proably would have been the next problem. But the problem I described still remains. I think I need the correct syntax to actually enter something into my Unbound object frame which is named in the "OleUnbound27" part of the code which that Unbound frame is already on my form.

Thanks for your help. I was able to get your code to work on my form. However I am having a problem embedding the Visio Drawing into the unbound object form....Here is the code I am using Public Sub EmbedExisting_Click() Dim ctl As Control Set ctl = OLEUnbound27 With vis .Visible = True...

VBA Access Code to open Visio Drawings and Excel charts in Unbound Object Frames I need some help with a bit of Access VBA Code. I have a form with various buttons I want to open different Visio Drawings I created previously into a Unbound Object Frame. I need the code to clear the contents...