question about pictures

[bob12345]

In my .mdb I would like to add a .jpg picture of each inventory item to the database for use in one of my Forms. I know how to add a bounded OLE picture to the Form, but since i need to add a couple hundred .jpg files...... the resulting database is huge and slow. I have no need to edit or modify the pictures once they are input. Is there any way to accomplish this without such massive use of system resources and without creating a gargantuan database file? Thank you for your help.

 

[dynamictiger]

Store the pictures in a folder outside your database.

Store the picture path only, like C:\MyFolder\MyPicture.jpg, as a text field in your database.

In the form, add an image control, when you have finished remove the path to the image and make it linked.

In the current event of the form add code like

Me.imgStockPicture.Picture=Me.PicturePath

This forces the image field to populate with the image in the specified path.

HTH

 

[bob12345]

Thanks for the tip.

I also ran across this little gem, which I think will prove helpful: http://www.lebans.com/loadsavejpeg.htm

 

[Oldsoftboss]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32503

Check this thread, Has a sample DB with code to allow the pic to be selected from the standard windows search box.
HTH
Dave