Image fields

  • Thread starter Thread starter M Altmann
  • Start date Start date
M

M Altmann

Ok, I'm no fool, BUT I'm having a problem with an OLE field not showing up
properly in the form. All I have is a couple of basic JPG's in my records
and they wont show inthe forms. What I get are the file names.
What am I missing??
My attorneys need this ASAP!
Thanx,
-Monica
(e-mail address removed)
 
Monica;

How about some more information.

What have you tried so far, and what version of Access are you using.

Andy
 
There are sample databases illustrating three approaches to handling images
in Access that you can download from http://accdevel.tripod.com. OLE Objects
and Bound OLE Fields are one of the approaches.

Larry Linson
Microsoft Access MVP
 
I am no expert, but maybe we can help each other as we have opposite
problems.

To answer your query:

In the table to which the form is linked, add a field which is an OLE object
and add a bound object frame. In the form, you can either right click on the
object frame, select 'insert object', 'create from file' and browse to the
file you want included and click ok. This will embed the picture into your
database. If you do not want it embedded, then click on the link tick box in
the dialogue above. In this way when you come to view the form again, the
picture will be displayed.

Not sure if that will help or not. If not, try using something along the
lines of the following (from the help files) and use appropriate data.

OLE1.Class = "Excel.Sheet" ' Set class name.
OLE1.OLETypeAllowed = acOLELinked ' Specify type of object.
OLE1.SourceDoc = "C:\Excel\Oletext.xls" ' Specify source file.
OLE1.SourceItem = "R1C1:R5C5" ' Specify data to create link to.
OLE1.Action = acOLECreateLink ' Create linked object.
OLE1.SizeMode = acOLESizeZoom ' Adjust control size.


My question now is - how did you manage to display the file names in your
form because that is what I want but cannot do so. I want to get this so
that the filename can be placed into another field on the database.

Hope this helps you and thanks for any help you can provide.

Martin
 
Back
Top