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
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
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?
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.
Code:
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