Picture in .JPG shows only icon in Access97 4

[jofet]

Is it possible to view the a real picture in Access that is saved as .jpg (JPG file)?<br><br>I tried to insert an object in a OLE Type Field but it showed only the JPEG Icon not the real picture...(&quot;View as Icon&quot; is not checked by the way).<br><br>I hope you can help me with this one...<br>I just want to get away of converting all the pictures into Bitmaps.<br><br>Thanks!! <br><br><br>

 

[DougP]

Here' what I did once<br>I created a form<br>Then put an &quot;Image&quot; control on it<br>then I used this code to load a .JPG into the image control.<br><br>------------------------<br>Private Sub Form_Current()<br>&nbsp;&nbsp;&nbsp;&nbsp;If Me![ID] &lt;&gt; 0 Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me!Image14.Picture = &quot;p:\ViewPhotos\Photos\&quot; & Me![ID] & &quot;.jpg&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Label20.Caption = &quot;File: &quot; & &quot; p:\ViewPhotos\Photos\&quot; & Me![ID] & &quot;.jpg&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;End If<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>End Sub<br>--------------------------------<br>I put this code in the form's on current event<br><br>OK<br><br><br>

 

[Dumboy]

Jofet ... Hey! DougP..... how ya doing pardner.....?<br><br>I created a small db for pictures just to see what happened and mine works fine<br><br>I got a table with one OLE field<br>a Form to see what's inside<br>and a report <br><br>in my form it gives me the option of converting the image... so....<br><br>I'm also wondering why do you need Access to do the conversions... are you going to be converting batches of files...?<br><br>If is just converting files into bitmaps once on a while you can just open the jpg do a copy and then paste it into your bitmap editing program.<br><br>If you have any problems you can use Powerpoint as a mediator between the two programs.<br><br>If you want send me an e-mail to <A HREF="mailto:dogtraining@yahoo.com">dogtraining@yahoo.com</A> to send you the small DB I created as an attachment so you can compare with what you have.<br><br>I know more about pictures than about Access, but DougP is the man.....yeahhh!...<br><br>Like I said.... hope this is of some help.....<br><br>OUCH......! <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!