SOLVED

Image field with hyperlink

Occasional Contributor

Newbie Question.

Simple Table

"Supplier"

"SupplierLogo"

"SupplierURL"

 

On a form when the logo field is selected to follow the URL.

How please?  I seem to be going round in circles

Many thanks

Jon

11 Replies
Use Application.FollowHyperlink "SupplierURL" where SupplierURL gives the full URL path
e.g. Application.FollowHyperlink "http://www.mendipdatasystems.co.uk"
Thank you. Something like:
Private Sub Logo_Click()
Application.FollowHyperlink "URL"
End Sub?
Something like above?
Yes
Thanks, now supposing I want to use a hyperlink field from my query, what would be the syntax please?
Well I've no idea what your query is or whether its used in a form so I can't give a definitive answer.
Perhaps use a DLookup expression to find the query value then use that value in your code
Sorry I’m not explaining myself very well
When the image is clicked it launched the url in the hyperlink field for that supplier.
So click on the Google logo, off it goes to Google, MS logo off it goes to MS etc

@Jon_Morgan1958 

Yes. That's what I thought you meant!

 

To save time, I've created a simple example database with 4 logos to show one method of doing this.

For convenience I've added the 4 logos to the image library.

However, normally you should just use the path to an external image file so as to avoid 'bloating' the database

Thank you so much! I'm going to have a go at that now.
Fixed, sorted, thank you. All for the want of "Me."
best response confirmed by Jon_Morgan1958 (Occasional Contributor)
Solution
You're welcome. Perhaps you could mark my last response as the solution / best answer