Images in reports that change with each record

[Disorganized Rusty Officemeister]

I am building a database of the inventory in a store. My database is working
splendidly but then the manager's said to add a thumbnail of all the items to
their corresponding record. I thought that by simply adding an ole object
field would do the trick but apparently when I look at the report and print
it; the images don't appear, only their pathname. I need the pictures to be
visible and that I can print the report with the images showing. Please help!

 

[Disorganized Rusty Officemeister]

hey people I really need help with this one.

 

[krissco]

hey people I really need help with this one.

No problem.

I assume that:
You have an Image control on your report (myImage)
The path for the image file is in a textbox on your report (imagePath)


You will want to put this code in the OnFormat event of your detail
section:

Private Sub . . . .

Me.myImage.Picture = Me.imagePath

End Sub


You can add code to check for blank paths, etc. . .
One thing you may want to watch out for is what type of images are
being used. I don't know if your version of Access will load all image
types. If you end up w/ problems (with what you know is a good path)
then check out www.lebans.com - he has a function called fLoadImage()
or something like that. . . anyways it will allow you to load many
image types.

-Kris

 

[Disorganized Rusty Officemeister]

About the application version; it Microsoft Access 2003 version 11.5614.5606.
In my table I added a field called Image which is a OLE object field. Then I
did the normal Insert Object with the right click button on the mouse.
Regarding the File type the images are JPEGs. They're on My Pictures folder.
Should I add that to the code? I changed the bound object Frame to myImage as
you suggested.