Lists

[Dan Flynn]

Not sure if access does this or not. But I was wondering if I can make a list or database of links. I need the following link repeated, for example 10,000 times. The only difference in each link is the end number. I need that to be in order. Meaning 1 Thur 10,000 for example.

http://www.mydomain.com/bbs/profile.asp?UserID=1
http://www.mydomain.com/bbs/profile.asp?UserID=2
http://www.mydomain.com/bbs/profile.asp?UserID=3
http://www.mydomain.com/bbs/profile.asp?UserID=4
http://www.mydomain.com/bbs/profile.asp?UserID=5

and so on, to 10,000 or whatever. If this is not possible, what program can do this. Excel????

Thanks

 

[Malcy]

Dan
I may be being dim, but why do you want to do this?
Am sure there is an easier way to achieve objective but without knowing objective it is hard to speculate.
Best wishes for New Year

Malcy

 

[Dan Flynn]

I want to create a link list for the members of my forum. Not sure why that would have much to with if this was possible!

But I do appreciate your quick reponse. I'm guessing you're not sure. If for some reason your should think of a way. Please let me know.

Have a great new year and a safe evening!

 

[rockman]

Not sure if this will help, but if you can generate a string that contains the HTML code I think this will work:

Private Function MakeLinks(sHeading as String, sFooting as String, iMaxMembers as Integer) as String
Dim i as Integer
     MakeLinks = sHeading & vbCrLf
     For i = 1 to iMaxMembers
          MakeLinks = MakeLinks & "http://www.mydomain.com/bbs/profile.asp?UserID=" & i & vbCrLf
     Next i
     MakeLinks = MakeLinks & sFooting
End Function

I'm not sure if you might get into problems with max number of characters that a string can contain based on your iMaxMembers (10,000 Yikes! )

HTH,
Jeff