Select Picture from ComboBox

M

Marcelo

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
 
R

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
 
M

Marcelo

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
 
Top