Insert Logo Into Access 2003 Database Report (1 Viewer)

access2010

Registered User.
Local time
Today, 02:20
Joined
Dec 26, 2009
Messages
1,019
We are trying to insert a Black and White logo into our Access 2003 reports and keep receiving this message.

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship.

I tried > Insert > Object;
A = Create New
B = Create from File.

The graphic is inserted to our report, but the error messages continue.

Your suggestions would be appreciated.

Crystal
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:20
Joined
May 7, 2009
Messages
19,170
you insert an Image control.
 

oleronesoftwares

Passionate Learner
Local time
Today, 02:20
Joined
Sep 22, 2014
Messages
1,159
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship
This is surprising, such error message should pop up on a form or table, when trying to insert data, not on a report
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 05:20
Joined
Feb 19, 2002
Messages
42,981
I use an image control. The path for the logo is in the record. This is because the record varies depending on the company associated with the report. The code is in the format event for the report header:
Code:
    If Me.LogoPath & "" = "" Then
    Else
        Me.imgLogo.Picture = Me.LogoPath
    End If
 

access2010

Registered User.
Local time
Today, 02:20
Joined
Dec 26, 2009
Messages
1,019
Hello, Pat and thank you for your suggestion.

I have tried to get your suggestion to co-operate and work, but have not had any success.

I would like to be able to insert a Black and White logo with the name Pat.Jpg, into the space currently occupied by the Letter I / Leaf.

Would you please place your code into the attached database for us.

Thank you.
Nicole
 

Attachments

  • Insert Logo Into Report=362.mdb
    308 KB · Views: 280

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:20
Joined
May 7, 2009
Messages
19,170
i opened your report in a2003 and did not get any error.
it displays the the logo (canadian?).
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 05:20
Joined
Feb 19, 2002
Messages
42,981
There is no code in the database AND you have no table. What did you try?

I did mention that the path to the logo file is actually stored in the company record. How else would I find it?

You need a table.
You need a field in the table to hold the path to the logo
You need a logo file to display.
 

Users who are viewing this thread

Top Bottom