image attachment Dlookup in report (1 Viewer)

alvingenius

IT Specialist
Local time
Today, 19:10
Joined
Jul 10, 2016
Messages
169
Hello
I have a table with an attachment field having a jpg image
and I wanna retrieve it in a report like retrieving a text or number using lookup

I can't use this table as the record source, it has to be same as using dlookup statment

in the same report, i use this
SQL:
DLookUp("ALC_Number";"tbl_ALC_Session";"ALC_ID = " & [ALC_ID])
as a recordsource in Textbox To get me a Number

and the image in the same table with field name: ALC_Theme

I tried to put attachment /Bound Object frame with this as a control source with no luck

SQL:
DLookUp("ALC_Theme";"tbl_ALC_Session";"ALC_ID = " & [ALC_ID])


Edit 1:
i could do this with a join query in the same report , but i have about 30 reports to do this edit in.. and i thought there's an easy way to copy paste the image box in every report header without editing every report record source and add join query of tbl_ALC_Session

Thanks.
 

Ranman256

Well-known member
Local time
Today, 13:10
Joined
Apr 9, 2015
Messages
4,339
use a query to pull the images.
then the report needs no code.
 

alvingenius

IT Specialist
Local time
Today, 19:10
Joined
Jul 10, 2016
Messages
169
use a query to pull the images.
then the report needs no code.
I just said that. I'm looking for the fastest way to just put a control on every report instead of editing evert report query
 

Ranman256

Well-known member
Local time
Today, 13:10
Joined
Apr 9, 2015
Messages
4,339
the OLE field can hold photos,
load the data into a 'report' table, then the report query pulls from that and shows the photo in the report.
 

Users who are viewing this thread

Top Bottom