Showing image in reports from Attachment field in another table

[Kennelbloke]

Hi folks

Couldn't find anything about this in the search so... Using Access 2013 and have a few reports setup.

I have a system setup table which a bunch of options which the user can change based on their needs. One of those fields is an attachment field for their logo.

What I having trouble trying to work out is how load that logo field (image) into the picture properties of a report. Unfortunately the property doesn't support dlookup no matter which Picture Type I use.

Anyone played with this and come up with a solution. (I got sick of trawling the net for one).

Cheers

 

[dhookom]

Have you considered using a subreport based on the system setup table?

Duane
Hook'D on Access
MS Access MVP

 

[Kennelbloke]

Yeah I thought of that Duane, but I want to use the image as a watermark on several reports and the logo on others. Seems strange that MS have not come up with or published a way to programically (if there is such a word) get the saved image.

Thanks for the response tho.

Cheers

 

[Blorf]

You may have solved this already, but if your picture/image is in a table as a blob or ole or what ever we want to call it, then stream it to a file, and tell your image object to point to that file.

The VBA to do this can be found here

https://support.microsoft.com/en-us/kb/103257

Hope this helps.

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That DonÆt.

http://www.thelegacyreturns.com/