Displaying Pictures on Forms

  • Thread starter Thread starter Rillo
  • Start date Start date
R

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.
 
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
 
Thanks for the advice.



Arvin Meyer said:
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
Click to expand...
 
Back
Top