Dynamic LOGO for Report

[Dipo]

Hello, is there a way of making logo on report dynamic such that user only need to upload/modify logo at data entry level?

 

[CJ_London]

Yes - but not enough info to provide a targeted response.

1. Store your logos in a suitable folder
2. In an appropriate table have a field to store the path and file name for the logo populated by user choice
3. for the report use an image control and set the controlsource to the name of the field

 

[Dipo]

Yes - but not enough info to provide a targeted response.

1. Store your logos in a suitable folder
2. In an appropriate table have a field to store the path and file name for the logo populated by user choice
3. for the report use an image control and set the controlsource to the name of the field

What kind of field type is most suitable? OLE or Attachment?

 

[theDBguy]

What kind of field type is most suitable? OLE or Attachment?

Hi. Based on CJ's response, I would say a Text field.

 

[Dipo]

OK tnx

 

[theDBguy]

OK tnx

Please don't hesitate to ask follow up questions, if something is not clear.

CJ said: "... have a field to store the path and file name for the logo..."

I am saying that field has to be a Short Text data type field.

 

[Dipo]

Please don't hesitate to ask follow up questions, if something is not clear.

CJ said: "... have a field to store the path and file name for the logo..."

I am saying that field has to be a Short Text data type field.

This will require that subsequent logo upload must be defined as per name and file type. Is it possible to make it less rigid such that you just need to pick and drop new logo and auto update on the report?

 

[CJ_London]

This will require that subsequent logo upload must be defined as per name and file type

which you do in the table per post #2

make it less rigid such that you just need to pick and drop new logo and auto update on the report?

not too sure what this means but if a user can change logo for one report to the next, use a combo box on the table mentioned above

 

[Pat Hartman]

If the report's logo doesn't change, you would use an image control that references the image. I don't import them but if you have only a few, that might be easier.

Your original request sounded like the logo was data driven. ie. you run the report for Company1 and it shows Company1's logo. You run it for Company2 and it shows Company2's logo. Please clarify because this is what you were given directions to do.

Here is code from one of my apps. It also makes some fields visible or not visible depending on the type of transmittal.

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)

    If Forms!frmCreateTransmittal!cboStageID.Column(2) = "Approval" Then
        Me.txtExpectedReturnDT.Visible = True
        Me.lblExpectedReturnDT.Visible = True
    Else
        Me.txtExpectedReturnDT.Visible = False
        Me.lblExpectedReturnDT.Visible = False
    End If

    If Me.LogoPath & "" = "" Then
    Else
        Me.imgLogo.Picture = Me.LogoPath
    End If
End Sub

 

[Dipo]

Thanks, you perfectly understood my task.

 

[Pat Hartman]

You're welcome