Changing OLE Links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mat-Brisbane - 01 Dec 2006 05:48 GMT

Hi MSDNers,

I am trying to change the link (i.e. source) of a linked OLE object in my
Access form in VBA, but have had little sucess after Googling for many hours.
I have tried changing the property, "SourceDoc", for an unbound OLE obect,
but this does not appear to be how OLE objects locate the data.

Can anyone help?

Thanks in advance,
Mat

Reply to this Message

John Nurick - 01 Dec 2006 07:11 GMT

Hi Mat,

When you say "a linked OLE object", do you mean you have a table that
has an OLE field in which you have stored linked objects? If so, I think
you need to use a form bound to the table, with a BoundObjectFrame
control bound to the field. You can then use VBA code to manipulate the
BoundObjectFrame and through it the object.

>Hi MSDNers,
>
[quoted text clipped - 7 lines]
>Thanks in advance,
>Mat

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

MatMc - 01 Dec 2006 08:07 GMT

Hi John,

No, this was NOT what I meant... I am looking to link an OLE object EXTERNAL
to the database, I.E. stored on disk. (eg. C:/A Document.doc)

Thanks,
Mat

> Hi Mat,
>
[quoted text clipped - 20 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message