This problem has many issues :s
I have a table (tableEmployees), and it has three fields EmpID, name and picture, which is a hyperlink with the location of a picture.
I have a report with a query that shows all employees, I have a "name" header, which contains the "details" part within it. for each employee i simply wish to show their picture. It will then be exported to word.
My issues are:
I can't simply save pictures in the database as OLE Objects or text. (they must be links)
The pictures are in mostly .JPG format
If there is no picture filled in the field I would like it to simply not show anything in that space.
SO how do I go about this?
P.S.
I've gotten it to display the link to each photo in the report just fine.
Thanks for any suggestions