Select Picture from ComboBox

[Guest]

Hi!

I've created a table with NAMES and PICTURES (OLE object) related to these
names.
I want use an imagebox to display these pictures one by one, depending on a
combobox which has NAMES.

Is there any way to do it?
Thanks,
Marcelo

 

[Roger Carlson]

The usual reply is to NOT store the pictures in the database at all. This
will bloat your database very quickly. A better solution is to store the
pictures in a folder on your hard drive (or network) and store just the path
to the file in your database. Then you can programmatically load the
picture into an unbound image control at runtime.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "Picture.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Hi Roger, thanks for your answer.

This is a good solution, but this access file will be a tool released for
using of several people, so I can't designate a fixed path to these images.
If there's any way to update automatically the path, it would work, but I
don't intend to ask the user where the files were saved. I don't want either
the user knows these files exists.
By the way, these files are small, about 120 of 10kb, and in the future I
wont' have more than 200.

Thanks,
Marcelo

 

[Roger Carlson]

As it stands, the sample will look for the pictures in whatever directory
the applications exists. You could also specify a subdirectory if you want,
but this would still be relative to wherever the application resides.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L