Select Picture from ComboBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top