alvingenius
IT Specialist
- Local time
- Today, 13:59
- 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
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
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.
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])
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.