PhotoField

[Guest]

Dear
I've got a field to put photo in like Northwind database on the form of Employee

I would like to produce report with Photo on the form but I can not. The photo only display on the form

Any idea to help me
Thanks for your time

Vuthy

 

[Ben]

a.. Open your employee table in design view
b.. Add a field called empPhoto of type OLE Object
c.. Open the employee table in table view
d.. Paste an image into the new field from clip board. (use copy and paste to put images into clipboard, ie. edit->copy/paste from paintbrush)
e.. Open the employee form in design view (ensure the forms record source points at your employee table)
f.. Insert a Bound Object Frame (xyz)
g.. Set the Control Source of the new bound object fram (Properties->Data) to empPhoto
h.. Close form and save

 

[Ben]

To get it on the report

Check that the recordsource of the report includes your photo field
(ie . select * from tblEmployees)

Insert a bound object frame and set its control source to the photo field.


Sorry, I think I misunderstood your question earlier

Good Luck

BEN