Logos (2 Viewers)

[mike60smart]

Hi Everyone
I apologise as I have never worked with Logos previously.
I have a table named "tblFSESub" with 2 fields. Field 1 is "FSE" and Field 2 is "Logo"
In the field "Logo" I have entered the path to the Logos as shown.
I am then trying to generate a Report so that when a Specific FSE is displayed its corresponding Logo displays as well.
Can anyone show me where I am going wrong in the attached example when I open the "rptDeliveries" it shows the Path to the file but not the actual Logo.?
Any help appreciated.

 

[theDBguy]

Hi Mike,

Without the images, I can't test it, but this is how I would do it. Check out the attached and let us know what you see.

 

[mike60smart]

Hi Mike,

Without the images, I can't test it, but this is how I would do it. Check out the attached and let us know what you see.

Many thanks theDbGuy. I see that you added the extra field with the Filepath.
Works a treat.
many thanks again

 

[theDBguy]

Many thanks theDbGuy. I see that you added the extra field with the Filepath.
Works a treat.
many thanks again

Yes, that's how I would personally do it. I don't like to use Hyperlink fields.

 

[arnelgp]

I did not add another field.
I added another Image control and using VBA and set the ControlSource to:

=GetLogo()

see the GetLogo() function on the report's VBA code.

 

[mike60smart]

I did not add another field.
I added another Image control and using VBA and set the ControlSource to:

=GetLogo()

see the GetLogo() function on the report's VBA code.

Hi Anelgp
Very neat.
Added to my things to keep.
Many thanks

 

[NauticalGent]

I don't like to use Hyperlink fields.

Interested in your reason?

 

[theDBguy]

Interested in your reason?

This might answer your question.

Text or Hyperlink

This is a topic of discussion that I have participated in the forums a number of times in the past and will probably continue to engage in t...

thedbguy.blogspot.com

 

[NauticalGent]

This might answer your question.

Text or Hyperlink

This is a topic of discussion that I have participated in the forums a number of times in the past and will probably continue to engage in t...

thedbguy.blogspot.com

Good article, thanks!