having a logo on a report...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stephendeloach - 27 Jun 2007 15:58 GMT

Im trying to have a company logo at the top of my report. The problem is that
I only want it when the reports "CompanyFrm" field is TSWS. My CompanyFrm
field is a dropdown box in the form that places the address of the company
from at the top of the report. Is there a way that when the dropdown box is
TSWS it places the logo at the top of the report instead of the address?

Reply to this Message

Ofer Cohen - 27 Jun 2007 16:14 GMT

To the OnPrint event of the report add the code

Me.[LogoName].Visible = (Me.[ComboName] = "TSWS")
Me.[Address].Visible = Not (Me.[ComboName] = "TSWS")

Signature

Good Luck
BS"D

> Im trying to have a company logo at the top of my report. The problem is that
> I only want it when the reports "CompanyFrm" field is TSWS. My CompanyFrm
> field is a dropdown box in the form that places the address of the company
> from at the top of the report. Is there a way that when the dropdown box is
> TSWS it places the logo at the top of the report instead of the address?

Reply to this Message

stephendeloach - 27 Jun 2007 16:38 GMT

OK. Where [LogoName] is, do i type C:\logo.bmp or just logo.bmp? and what do
I put in for [Address]? I have multiple addresses. Im guessing [ComboName]
is [CompanyFrom]? Sorry, Im not the best at this! Thanks

>To the OnPrint event of the report add the code
>
[quoted text clipped - 6 lines]
>> from at the top of the report. Is there a way that when the dropdown box is
>> TSWS it places the logo at the top of the report instead of the address?

Reply to this Message

Damon Heron - 28 Jun 2007 00:44 GMT

What Ofer is saying that on the report you would add an image control. The
Logo image would be imbedded in Access, not linked. When the companyfrm
name is TSWS then the image control would be visible, else the textbox on
the report for the address would be visible.

Damon

> OK. Where [LogoName] is, do i type C:\logo.bmp or just logo.bmp? and what
> do
[quoted text clipped - 16 lines]
>>> is
>>> TSWS it places the logo at the top of the report instead of the address?

Reply to this Message

rtviper - 27 Jun 2007 22:08 GMT

In the Field AfterUpDate Event (Try Below)

With Me
If .CompanyFrm="TSWS" Then
.AddressField.Visible=False
.CompanyLogo.Visible=True
Else
.AddressField.Visible=True
.CompanyLogo.Visible=False
End If
End With

Reply to this Message

stephendeloach - 28 Jun 2007 16:30 GMT

I put the code in under the AfterUpdate Event and I get a compile error:
Method or data member not found. and AddressField is highlighted... I have
a feeling CompanyLogo will be highlighted next because I havent stored my
logo anywhere??? I finally read up on this and I have embedded my logo in a
table, im sure i should have done this before? Sorry! Thanks!

>In the Field AfterUpDate Event (Try Below)
>
[quoted text clipped - 13 lines]
>> from at the top of the report. Is there a way that when the dropdown box is
>> TSWS it places the logo at the top of the report instead of the address?

Reply to this Message

rtviper - 29 Jun 2007 18:32 GMT

You do not need to embed your logo in a table only in the form.

> I put the code in under the AfterUpdate Event and I get a compile error:
> Method or data member not found. and AddressField is highlighted... I have
[quoted text clipped - 19 lines]
> >> from at the top of the report. Is there a way that when the dropdown box is
> >> TSWS it places the logo at the top of the report instead of the address?

Reply to this Message