Is there a way to let an OLE Picture field show a link to for example P:\Pictures\Tes

[ACF]

In my table I have Picture (OLE) and Link_String (Text)

On my Form I have the OLE field and the text field.



In the text field I would like to put in a reference to a file on my computer (example: P:\Pictures\Test.jpg) and the picture OLE field should then show the linked to picture.



Is there a way to code this?



Greetings,

ACF

[JConsulting]

In my table I have Picture (OLE) and Link_String (Text)

On my Form I have the OLE field and the text field.



In the text field I would like to put in a reference to a file on my computer (example: P:\Pictures\Test.jpg) and the picture OLE field should then show the linked to picture.



Is there a way to code this?



Greetings,

ACF

You don't need to code anything. Just make the textbox bound to the table's field where the picture path is.
J

[Lysander]

In my table I have Picture (OLE) and Link_String (Text)

On my Form I have the OLE field and the text field.



In the text field I would like to put in a reference to a file on my computer (example: P:\Pictures\Test.jpg) and the picture OLE field should then show the linked to picture.



Is there a way to code this?

If you are storing the picture itself in your database, you don't have to do anything, just bind the OLE control to the picture.

If you are storing the pictures name, not the picture itself, then in the on_current event of the form change the picture property of the control

For example the control is called cardpic and the fieldname in my recordset is PictureName

cardpic.picture = "G:\Desktop\magic\pictures\" & PictureName & ".jpg"