Form Picture Lookup

[thrasher]

I have a database for my mp3 collection and would like to have a picture for each artist and album. The problem is I have hundreds of artists/albums and it would crazy to link all of the ole objects.

My question is how do I have "OLEBOUND10" display the picture associated with "TEXT1" as text1 says ="C:\Documents and Settings\Thrasher\Desktop\Database\Songs\" & [artist] & " - " & [title] & ".mp3"

Also, is there a way to play a song upon entry of a form/database?

Thanks a lot!

 

[bat17]

Rather than using an OLE object use an Image conctroll and set it's path from code.
So if you have a field in the table that contains the file path you put it on the form (can be hidden) and use the forms Current event to show the picture.

Private Sub Form_Current()
On Error Resume Next
Me.imgVisual.Picture = Me.ImgPath
End Sub

This may show a loader as the picture changes but works quite well.

HTH


Peter

 

[thrasher]

Thanks for the answer. I appreciate the time. I was searching the web for a little help and I stumbled upon this great thread also if anyone wishes to see it.

http://www.tek-tips.com/gviewthread.cfm/pid/702/qid/289543