INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Showing image in reports from Attachment field in another table

Showing image in reports from Attachment field in another table

(OP)
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

RE: Showing image in reports from Attachment field in another table

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

Duane
Hook'D on Access
MS Access MVP

RE: Showing image in reports from Attachment field in another table

(OP)
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

RE: Showing image in reports from Attachment field in another table

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/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close