By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,156 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,156 IT Pros & Developers. It's quick & easy.

How to LookUp an image on Report??

P: 35
This is my table named "Company"

ID...........Company Name.........Logo
1............Mr. Book.............Image

I want to show my "logo" on my whole reports. For this purpose I have used DLookUp function which is given below but it works only once. After re-opening the database has shown me an error "Run-time error '2220'. What should I do to show logo on my reports.

Expand|Select|Wrap|Line Numbers
  1. Me.ImageLogo.Picture = DLookup("[Logo]", "Company")

Attached Images
File Type: png Untitled.png (4.4 KB, 221 views)
Sep 5 '18 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,397
This error usually means that the image file cannot be located at the path given.
You should take a look at:
home > topics > microsoft access / vba > insights > display images in your db without using attachment fields
Both TwinnyFo's method and the method in my subsequent post therein can be altered to work for reports as well as for forms.
Sep 5 '18 #2

NeoPa
Expert Mod 15k+
P: 31,494
You may also find Why Values in Unbound Form Controls do not Persist helpful.

If you want to show multiple logos you'll need to bind the control to the field.
Sep 6 '18 #3

Post your reply

Sign in to post your reply or Sign up for a free account.