VB Programming w/ Access
[331 byte] By [ejuozaitis] at [2007-11-11 7:06:11] 
I am using an Access Database that has Hypertext field and I would like to know how to program in VB for this field. I have looked everywhere that I can but there seems to be nothing out there about Hyperlinking. This field is just a hyperlink to a file, not a web site. Can someone give me some direction here, please? Thanks.
# 1 Re: VB Programming w/ Access
It isn't clear exactly what you want to do. Do you want to launch a hyperlink through code? A control on a Form?pclement at 2007-11-11 23:47:50 >
# 2 Re: VB Programming w/ Access
http://www.google.com/search?q=access+hyperlink+fieldPhil Weber at 2007-11-11 23:48:58 >
# 3 Re: VB Programming w/ Access
What I am trying to do is using VB form code to add records to the database with one record having a hyperlink to a file on the computer (that when clicked will bring up the Excel or PDF file). The problem I am having is finding the correct code or function to send the hyperlink from the program to the database as a hyperlink and not text. If you need more information, just let me know. Thank you for reply.ejuozaitis at 2007-11-11 23:49:57 >
# 4 Re: VB Programming w/ Access
Phil,Thank you for the hyperlink, however the problem is in VB. I am trying to code a form to send a location of a file from the computer to a hyperlink field. The problem that I am facing is that I can not find the code or function of Ado to send a hyperlink to the field rather than just the text.
ejuozaitis at 2007-11-11 23:50:56 >
# 5 Re: VB Programming w/ Access
Did you read any of the links returned by the query in my previous message? The second search result explains how to set the value of an Access hyperlink field. To link to a file, use "file://" instead of " http://" at the beginning of the link location.Phil Weber at 2007-11-11 23:52:00 >
# 6 Re: VB Programming w/ Access
Did you read any of the links returned by the query in my previous message? The second search result explains how to set the value of an Access hyperlink field. To link to a file, use "file://" instead of "http://" at the beginning of the link location.Phil,
I did read the articles that you posted, but they are not helping me with the problem. What I am trying to is program Visual Basic to send a hyperlink to a databases with a hyperlink field. The problem is that I can find the ADO code or function to send the hyperlink reference to this field. This might have been my fault for the confusion. I thought that the Database form might have some insight to the problem, I think that I should have placed it into the VB Form. If so please let me know.
ejuozaitis at 2007-11-11 23:52:59 >
# 7 Re: VB Programming w/ Access
Dim rs As RecordsetSet rs = New Recordset
rs.Open "TableName", cn
rs.AddNew
rs!ColumnName = "Click here to open file#file://d:/path/temp.txt"
rs.Update
Phil Weber at 2007-11-11 23:53:57 >
# 8 Re: VB Programming w/ Access
Dear Phil,Thank you so much. I just tried it and it works great. So when it comes to hyperlinking I have to have the # and the type of hyperlink? Just want to make sure for future reference.
ejuozaitis at 2007-11-11 23:55:01 >
# 9 Re: VB Programming w/ Access
http://www.asp101.com/tips/index.asp?id=100 (The second result from the Google search I posted above. ;-)
Phil Weber at 2007-11-11 23:56:05 >
