How can I populate a picture field with .jpg.

  • Thread starter Thread starter lindairene
  • Start date Start date
L

lindairene

In Access 2003, how can I poplulate and OLE object field with picture (.JPG
files) from our intranet without copying & pasting them one by one? Is it
possible?
 
ACCESS 2003 does not store picture objects very efficiently. Your database
will quickly bloat in size because ACCESS decompresses the image before it
stores it in the table's field.

It's better to store the path to the image file in a field in the table,
then use the Current event of a form to assign that path to the Picture
control on the form.
 
Ken,

Thank you for your reply. However, I'm sorta confused. Are you talking
about programming something to retreive this info? I'm just back into IT
after a 7 year hiatus, so I'm a little lost here. Can you point me to an
example?

Thanks again.
 
Assuming that you have a field named ImagePathFile in your table, and that
you are storing the entire path and file name of the image file in that
field (as a string -- for example C:\MyFolder\PictureName.jpg ), you
can use the form's Current event to set the Picture property of the image
control on your form:

Private Sub Form_Current()
Me.ImageControlName.Picture = Me.ImagePathFile.Value
End Sub
 
Back
Top