Pictures in records displayed on form

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

Guest

Man, I know this can be done, but all that is displayed is the name of the
file name. I'm using an OLE Bound control and display is set to content.

I'm using Access 2000 (unfortunately) here at work.
 
You need to have a suitable ‘OLE Server’ application installed and correctly registered for the particular
file-type. This must be the case both at the time you insert the image, and when you subsequently come
to display it (e.g. if on a different system).

Depending on the file-type, one of the most common OLE Server applications is ‘MS Photo Editor’. To install
this app you’ll need to get your Office CD’s out and add it. Note that Photo Editor is not included with
Office 2003, and if you upgrade to 2003 Photo Editor will actually be removed (which breaks applications
that rely on it).

Note that OLE Embedding is responsible for a range of common problems, including configuration issues like
this, but more often a potentially HUGE size (and corresponding performance) overhead – for JPEG this can
be up to 200 *times* the original file-size, so unless you have very few images you can very quickly find
yourself heading towards the Access file-size limit.
 
Hi Geoff

To link your picture Step-byStep manually
1 Open the Table that will hold the data /picture (not the form)
2 navigate to the OLE field on the correct record and Right Click
3 Select Insert Object
4 Select Create From File and then Bitmap and then check the Link option
5 Browse to your picture and select it
6 Click OK
7 “Package†will appear in the field
8 View your image on the form

Or to run this with code use this link which was supplied by Ofer Cohen in
answer to a recent question
http://www.databasedev.co.uk/bound_image_form.html
 
Back
Top