How to add pictures so that they shown in reports?

[annaazzam]

I have a database with a table, and each record has an image as an OLE object
these pictures show when i make a form....... but not when i make a report
how can i make the pictures show in the report?? please help! thanks in advance

[June7]

I've never had success with the OLEObject field type nor the OLEObject controls. I put image in attachment field or the image path in a text field then use Image control on form and report for dynamic display of images.

[MillerRL143]

I was able to do the same thing only I actually placed a bitmapped image into my "picture" field. Worked just fine.

[weymes]

I've never had success with the OLEObject field type nor the OLEObject controls. I put image in attachment field or the image path in a text field then use Image control on form and report for dynamic display of images.

I am new to access and have tried this method but i get the same image repeating ... See below for example

Category Table

CatID...... CatDes............... CatPic(text)
CatA ...... Description of A... \\Server\...\cata.jpg
CatB ...... Description of B... \\Server\...\catb.jpg
CatC ...... Description of C... \\Server\...\catc.jpg


Inventory Table

PartNub...... PartDes.................. CatID... Size1..... Size2
A1-02-02.... Description of A-1.... CatA.... 1/8........ 1/8
A1-02-04.... Description of A-1.... CatA.... 1/8........ 1/4
A2-04-04.... Description of A-2.... CatA.... 1/4........ 1/4
A2-04-06.... Description of A-2.... CatA.... 1/4........ 3/8
B1-02-02.... Description of B-1.... CatB.... 1/8........ 1/8
B1-02-04.... Description of B-1.... CatB.... 1/8........ 1/4
B2-04-04.... Description of B-2.... CatB.... 1/4........ 1/4
B2-04-06.... Description of B-2.... CatB.... 1/4........ 3/8
C1-02-02.... Description of C-1.... CatC.... 1/8........ 1/8
C1-02-04.... Description of C-1.... CatC.... 1/8........ 1/4
C2-04-04.... Description of C-2.... CatC.... 1/4........ 1/4
C2-04-06.... Description of C-2.... CatC.... 1/4........ 3/8

Report Is Set Out As Follows

Page Header
Generic Details (Title ECT)

CatID Group Heder
CatID.... CatDes.... CatPic(hiden)
Controlled Image box (called CatImg)

Detail
PartNub.... PartDes.... Size1.... Size2

No Footers


VB Report Script
CatImg.Picture = CatPic

What Am I doing Wrong?

There are some Categories that do not have Images but a there is a path created and some do not have a path

Thanks in advance, any help is appreciated

[June7]

No need for VBA code. Assuming form or report has the CatPic field in its RecordSource, bind Image control to the field by setting ControlSource property.

[weymes]

No need for VBA code. Assuming form or report has the CatPic field in its RecordSource, bind Image control to the field by setting ControlSource property.

June7 Thanks for the quick reply.

I am not sure what you mean by "bind Image control to the field by setting ControlSource property"

Sorry I am a complete NOOB to all programing... this just fell in my lap at work and this looked like a better option than excel

Thanks again

[June7]

No programming required.

Bind form or report to the table. Create an Image control on form or report by dragging control from the ribbon design tab. Set the ControlSource property of the Image control just as you would any data control.

[weymes]

No programming required.

Bind form or report to the table. Create an Image control on form or report by dragging control from the ribbon design tab. Set the ControlSource property of the Image control just as you would any data control.

FANTASTIC!!! Thank you so much for the help