Use Access To Search the web

[djdean]

Please help

I have built a massive database to handle my record business which handles pictures, mp3's and exporting html. I now want to use the artist field to search on 4 different sites when i click on a button called WEB. This is way out of my league

Exampl

Artist : PERFECT PHASE would need to be as follow

http://www.discogs.com/search/?meta_type=Artist&text_content=perfect+phase&action=G

I really don't know where to start on this one.

 

[John Nurick]

Hi Dean,

You can use something like this, in the Click event procedure of a
button on a form that also contains a textbox called txtArtist which
contains the name of the artist you want to look up:

Const DISCOGS_URL = "http://www.discogs.com/search/?" _
& "meta_type=Artist&text_content="
Dim strURL as String

strURL = LCase(Me.txtArtist.Value)
strURL = Replace(strURL, " ", "+")
strURL = DISCOGS_URL & strURL & "&action=Go"
Application.FollowHyperlink strURL