Picture hyperlink

[varsang]

i have a database that has a hyperlink to mp3 files. I have a special column in my table for the hyperlinks for each record. I created a form and I want to insert a picture of a speaker so that when I click on it, it takes me to the specific hyperlink of each record. In the form view, I tried to change the "Text to display" to an image but it seems that it shows text only instead of the image itself.

How can insert a common image and have a unique hyperlink for each record?

 

[Moniker]

Make a listbox that contains the hyperlink itself (hidden) and the MP3 name. The hyperlink in this listbox will be the control source for a single speaker button, either a command button or an image control. Regardless of if it's the button or an image, it's OnClick event reads the hyperlink from the selected listbox item and goes to the appropriate MP3 file.

 

[varsang]

I tried that but it is not working. This time I have attached a pic so that you can better understand. I already have a combo box for the Song Title called Kirtan. This form is for finding the song info therefore for each song I have some fields. When I search for the song, I can view all its details but I wanted to incorporate a "music playing" link for each song. I want something like a control button so that when I click on it, it open the hyperlink of the mp3 song.

View the image attached to better understand.

 

[varsang]

Please some help me. I am close to what I want. This is the only problem I have with my database.

 

[Moniker]

When you click on "Listen", it doesn't do anything? Or, it's working, but you want an image instead? Clarify a little and I can pull that together. If you can post a stripped-down version of the DB, that would help immensely.

 

[varsang]

Yes the "Listen" link is working but instead of the text, I want an image. Remember that I have each unique link for each record. So therefore I want to have only one image and unique links. Take a look at the image at http://varsang.us/table.jpg

 

[varsang]

Someone please help me.

 

[Moniker]

Here's an example of what I originally described to you. Open the form "f_player" and select any of the fake songs. Then click the big button at the bottm and you'll get a message box seeing that the hyperlink is changing depending on the song selected. Note that it will also give you an error because it's actually looking for my fake sample songs.

Look at the simple structure of the table t_TrackList to see how I set it up, and look at the code behind the Listbox's OnClick event to see how I'm adjusting the hyperlink everytime the listbox selection changes.

This is by no means normalized (there's not even a primary key set up), but I wrote this at work in a spare 10 minutes I happened to have for a change.

Regardless, it should show you the structure that you need to be able to dynamically change the hyperlink for a single button depending on the selection of the listbox.

HTH

 

[varsang]

Thanks. I finally got. I was a little hard to apply to my form but I finally got it.

 

[Moniker]

Glad you figured it out. It was probably simpler than you imagined.