Displaying Pictures on Forms

[Rillo]

I want to include a picture in each record in a table.
I also want to display the picture on a form, based on a query.

I have
a. defined an OLE object field in my table
b. inserted objects in my table using the insert object command and the
create from file option (the files are jpeg files)
c. designed a form that displays details of a record (based on a query),
including the picture.

When I display the form all the details are displayed except the picture.
Only the file name of the relevant picture is displayed, not the picture
itself.

I am using Access 2002 SP-1.

Please advise.

 

[Arvin Meyer [MVP]]

You need a registered OLE server for the filetype of the picture. usually
this is MS-Paint, but if you've associated the images with another program,
it may not work.

You may also want to store your pictures as a path to them in a plain text
field and use the picture property of an Image Control to display them. If
you have more than a few pictures, this is the most efficient method. Have a
look at the example at:

http://www.datastrat.com/Download/Picture2K.zip

 

[Rillo]

Thanks for the advice.

You need a registered OLE server for the filetype of the picture. usually
this is MS-Paint, but if you've associated the images with another program,
it may not work.

You may also want to store your pictures as a path to them in a plain text
field and use the picture property of an Image Control to display them. If
you have more than a few pictures, this is the most efficient method. Have a
look at the example at:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com