Prev: Access 2007 - Different Ribbons for Different Users?
Next: How do you embed a google map in access?
From: Raymond on 4 Jul 2008 05:00
Hi all,
I have two divisions of a company..and i have 1 sales report. This report is
opened by both the divisions whatever the choice may be. Now my report has a
logo(image) at its header which is different for both divisions. How do I
code it so that according to the division chosen by the user, the report
opens with the respective image..

Please help since I don't want to create two reports for both these
divisions because that would be simply ridiculous....
From: fredg on 4 Jul 2008 09:37
On Fri, 4 Jul 2008 02:00:02 -0700, Raymond wrote:

> Hi all,
> I have two divisions of a company..and i have 1 sales report. This report is
> opened by both the divisions whatever the choice may be. Now my report has a
> logo(image) at its header which is different for both divisions. How do I
> code it so that according to the division chosen by the user, the report
> opens with the respective image..
>
> Please help since I don't want to create two reports for both these
> divisions because that would be simply ridiculous....

Use an Image control to display the logos.
You can....
1) Use 2 Image controls.
Include both images, one on top of the other, in the report.
Then code the Report Header's Format event, something like:
If Me.[Department] = "Sales" Then
Me.ImageName1.Visible = True
Me.ImageName2.Visible = False
Else
Me.ImageName2.Visible = True
Me.ImageName1.Visible = False
End If

Or....
Just use one Image control.
Code the Report Header Format event:
If Me.[Department] = "Sales" Then
Me.ImageName.Picture = "c:\PictureFolder\SalesLogo.jpg"
Else
Me.ImageName.Picture = "c:\PictureFolder\ManufacturingLogo.jpg"
End If

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 | 
Pages: 1
Prev: Access 2007 - Different Ribbons for Different Users?
Next: How do you embed a google map in access?