Hyperlinking in Access

[pacitti]

I am in need of help with VBA in Access 2000.

I am creating a forum with Albums info from Amazon. I need to put a link on the forum so that as you are browsing the forum and you like or find the CD you want to buy, you can click on the link on that page and it would take you to the corresponding Amazon page. Each record has a ID called a ASIN number so al I need to do is create a link that will change the ASIN part in the link as I browse the forum.

I was suggested using a record set like this but I can seem to get it to work.

strLink = "

http://www.amazon.com/exec/obidos/tg/detail/-/";

+ rs.Fields("asin&quot + "/qid=1036750045/sr=8-1/ref=sr_8_1/102-7744387-4978558?v=glance&s=music&n=507846"

If you are not sure what I am asking then look at my html explanation that has pics in it to help you understand what I need done.

http://www.tehforum.net/forum/?msg=1317.1

(Login as gust)

I need this done by Thursday of next week so I would be REALLY grateful if someone could help me. Thank you

 

[vb5prgrmr]

This question would be best asked in a web development forum. What I can offer you is some simple syntax to generate a list of all entries.

SQL = "Select * From Your_Table"
'open connection to database
'open recordset
Do While RecSet.Eof = False
strLink = First_Part + RecSet.Fields("asin&quot + Last_Part
'Print out html link here
Loop
'Close Recordset
'Close Database Connection

Good Luck