Picture Browsing

[Public]

Hi,
I have a form where I want to upload a picture from a file. I have the data
type of that field (that stores the file) as OLE Object.

How can I open picture dialog box and assign the selected picture to this
field?

 

[Roger Carlson]

Personally, I don't load the pictures into the database at all. I leave
them on the file system and store the path to the picture in the database.
Then I can programmatically load the picture into a form or report at
run-time.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "Picture.mdb" which illustrates how to do this. There is also
a sample called "PictureLoad.mdb" which shows how to browse to a picture to
load the path into the database.

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