Logo in multiple reports

[Tom]

Hi

Any advice on the following would be appreciated:

The company has numerous reports in which they want there logo to appear.
The logo is a bmp image.

Is it necessary to embed that image into each report or can the image be
linked to the reports which would make maintenance a lot simpler if the logo
should be changed.

Using Access 2002

TIA

Tom

 

[Allen Browne]

1. Add this function to a standard module, changing only the file name:

Public Function LoadLogo(img As Image)
Const strcFile = "C:\MyPic.jpg"
If Dir(strFile) <> vbNullString Then
img.Picture = strcFile
End If
End Function

2. Place an Image control on your report. Name it (say) imgLogo.
You may need to supply a bmp file intially, but you can set the Picture
property to
(none)

3. Set the On Open property of the report to:
=LoadLogo([imgLogo])

 

[Rick Brandt]

Hi

Any advice on the following would be appreciated:

The company has numerous reports in which they want there logo to
appear. The logo is a bmp image.

Is it necessary to embed that image into each report or can the image
be linked to the reports which would make maintenance a lot simpler
if the logo should be changed.

Using Access 2002

TIA

Tom

Put the logo in a small report containing only that and then embed that as a
subreport into all other reports. In addition to making your file a lot
smaller (only one copy of the image) you only have to change the image in
one place.

 

[Tom]

Thanks Allen & Rick for your advice will try both suggestions

Tom