How do I refer to the OLE Class name for an MSPaint image file in A97?

[MLH]

Here's some example code taken from A97 HELP...

Sub Command1_Click
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.
End Sub

I'd like to view images created in MS Paint. Some are JPEG's and
others are BMP's. I have a table furnishing data to a form. As I flip
through the records on the form, I'd like to see the JPG and BMP
images referenced in my table field named [ChkImageFile]. The string
there is a full pathspec to the image. IE, "c:\MyDir\MyImage.jpg"

(1) What Class name should I use? MS Paint HELP doesn't specify.
(2) Will Class name change based on image type (jpg / bmp)?
(3) Can I leave SourceItem alone? Or must I specify?

[Rich P]

If you place an image control on your form you can reference image files
like this:

Image1.Picture = "C:\someDir\testPic.jpg"

Or in the current event of the form you can cycle through image files as
you move from one record to the next if your records contain a field
that references the locations of images.

Note: always better to reference the location of images on the
harddrive than to store images in the database as ole objects. Ole
objects will bloat your db very quickly.

Image1.Picture = "C:\someDir\testPic.jpg"

Private Sub Form_Current()
Image1.Picture = rsClone!ImageLocation
rsClone.MoveNext
End Sub

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[MLH]

Thx for the suggestion. But OLEUnbound119.Picture = Me!ChkImageFile
did not work for me. I got runtime error 438 "Object doesn't support
this property or method". I'm not aware of any picture property for
inserted OLE object in Access 97.

Am I doing something wrong?

[Rich P]

Sorry. I am using Acc2003 which has an Image control. I am pretty sure
Acc97 also has an image control. Check to make sure you are using an
Image control. Then the picture method should work. there are 3
controls that look like image controls in the Design toolbox. One is an
unbound Ole control, one is a bound Ole control, and the first one is an
image control. make sure you selected an image control.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[MLH]

Yes, you are exactly right. I was equating an image control
an OLE control. Not the same. Not even close. Now that I
followed your recommendation, using the IMAGE control, things
are working as you stated. Thank-you for having the patience
to reply.

Mike H
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx