469,590 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,590 developers. It's quick & easy.

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

5
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
Jun 28 '07 #1
2 1140
JConsulting
603 Expert 512MB
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
Jul 4 '07 #2
Lysander
344 Expert 100+
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

Expand|Select|Wrap|Line Numbers
  1. cardpic.picture = "G:\Desktop\magic\pictures\" & PictureName & ".jpg"
  2.  
Jul 5 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by remcoploeg | last post: by
reply views Thread by shapper | last post: by
1 post views Thread by robert.dondo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.