Automated image import in Access

[gasca]

Hi,

Anyone's got any clue on how to import automatically some jpg pictures into an OLE Object data field using some VBA code in Access? Let's say I have every picture named in a uniform way (identifier of register,...)

Thanks.

 

[dhookom]

Storing jpgs in an Access table would be a big mistake. This would increase your mdb size to unbelieveable proportions. It is best to store the file name and then update the Picture property of an image control with some code. You can use the On Current event

Me.image.Picture = Me.picFileName


Duane
MS Access MVP
Find out how to get great answers faq219-2884.