How to LookUp an image on Report?? - Microsoft Access / VBA

43 New Member

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

Me.ImageLogo.Picture = DLookup("[Logo]", "Company")

Attached Images

Untitled.png (4.4 KB, 946 views)

Sep 5 '18 #1

Subscribe Reply

1966

zmbd

5,501

Recognized Expert Moderator Expert

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

32,557

Recognized Expert Moderator MVP

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

Similar topics

3055

Adjusting brightness in images using JAI lookup tables

by: Amy | last post by:

Hi, I have written a program using JAI for a project I am doing which can be used to adjust the brightness of an image. It all works fine but I now need to write it all up and am not entirely...

Java

6592

Filter a report based on same filter on a form

by: Richard | last post by:

Hi, I have a form based on a table. When I filter the form I want to run a report based on the same table with the same filter as the form. No problem until I want to filter a combo box where...

Microsoft Access / VBA

1623

Footnote on image report

by: Jacky11 | last post by:

Hi everyone, I have spent several hours on this topic, and I still don't have the right solution. However, you guys can accomplish in 5 minutes much more then I can accomplish in 5 hours. :-)...

Microsoft Access / VBA

10606

Need an alternative to Lookup fields

by: google | last post by:

I have a database with four table. In one of the tables, I use about five lookup fields to get populate their dropdown list. I have read that lookup fields are really bad and may cause problems...

Microsoft Access / VBA

2695

Problem with control source for text box on report

by: VivN | last post by:

I want to use an expression as the control source for a text box in a report (Access 2000). Whilst I have sucessfully used these simple ones =TimeToSingle(TotalHours(,))...

Microsoft Access / VBA

6262

stl::map lookup speed

by: markww | last post by:

Hi, This is a continuation of a dead post. I need to make a pixel map where I can store pixel data for multiple images. Multiple windows in my app may render the same image, so I want to keep...

C / C++

2631

Will a lookup table improve performance?

by: Paul H | last post by:

Suppose I have a table called tblPeople and I want a field to illustrate whether each person prefers cats or dogs. I could do it one of three ways. 1. A plain text field Create a text field in...

Microsoft Access / VBA

4142

Display Lookup Fields from Multi-Select List Box on a Report

by: freetime | last post by:

Greetings, This is my first post so I will try to be brief and accurate. I have a report that uses 9 user selectable filters (Dates, Y/N's as Combo Boxes and 4 Multi-Select List Boxes. ...

Microsoft Access / VBA

1269

Change Image Report VB.Net

by: MATTXtwo | last post by:

I got some probs here.. I got this project upload image i have already upload that image... and i need to make the image path pass the value to crystal report and display it how to do that? how...

Visual Basic .NET

2505

Creating a report like a crosstab report

by: MLEBL | last post by:

I have information in my scheduling table that I need to report out in a crosstab format with the staff members as the rows and the dates as the columns. I've created a crosstab report query that...

Microsoft Access / VBA

7224

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7323

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7038

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5625

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5049

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4706

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3180

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1550

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

763

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP