• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 959
  • Last Modified:

MS Access Hyperlink Field in Asp.net

I am working with MS Access 2007 and am querying a record set to be bound to a hyperlink web control in Asp.Net.  The format of the Access hyperlink field comes back looking like:

www.mysite.net#http://www.mysite.net#

Is there a good way to just get the format to work with the hyperlink we control? Or do I have to do some fancy parsing?  The part about parsing that worries me is that I think I read somewhere that the MS Access Hyperlink field can contain like 4 parts to it.

Thanks!
0
daveokst
Asked:
daveokst
  • 3
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
look for  HyperlinkPart  from the Access Help
0
 
Rey Obrero (Capricorn1)Commented:
look for  HyperlinkPart  from the Access VBA Help
0
 
daveokstAuthor Commented:
Actually I am not sure how to call HyperLinkPart within Access.  We currently use LLBLGen to generate a data layer to work with generating SQL to pull data from a client's MS Access database.

If there is some SQL syntax that will accomplish the job, please post.  I need to have just the url parsed out so I can set it to the Navigate Url property of the hyperlink control.
0
 
Rey Obrero (Capricorn1)Commented:
here is the example from the VBA Help

Example
The following example uses all four of the part argument constants to display information returned by the HyperlinkPart method for each record in a table containing a Hyperlink field. To try this example, paste the DisplayHyperlinkParts procedure into the Declarations section of a module. You can call the DisplayHyperlinkParts procedure from the Debug window, passing to it the name of a table containing hyperlinks and the name of the field containing Hyperlink data. For example:

:DisplayHyperlinkParts "MyHyperlinkTableName", "MyHyperlinkFieldName"

Public Sub DisplayHyperlinkParts(ByVal strTable As String, _
                                 ByVal strField As String)
   
    Dim rst As New ADODB.Recordset
    Dim strMsg As String

       
    rst.Open strTable, CurrentProject.Connection, _
             adOpenForwardOnly, adLockReadOnly

    ' For each record in table.
    Do Until rst.EOF
        strMsg = "DisplayValue = " _
            & HyperlinkPart(rst(strField), acDisplayedValue) _
            & vbCrLf & "DisplayText = " _
            & HyperlinkPart(rst(strField), acDisplayText) _
            & vbCrLf & "Address = " _
            & HyperlinkPart(rst(strField), acAddress) _
            & vbCrLf & "SubAddress = " _
            & HyperlinkPart(rst(strField), acSubAddress) _
            & vbCrLf & "ScreenTip = " _
            & HyperlinkPart(rst(strField), acScreenTip) _
            & vbCrLf & "Full Address = " _
            & HyperlinkPart(rst(strField), acFullAddress)
           
        ' Show parts returned by HyperlinkPart function.
        MsgBox strMsg
        rst.MoveNext
    Loop
   
End Sub
            
When you use the HyperlinkPart method in a query, the part argument is required. For example, the following SQL statement uses the HyperlinkPart method to return information about data stored as a Hyperlink data type in the URL field of the Links table:

SELECT Links.URL, HyperlinkPart([URL],0)
    AS Display, HyperlinkPart([URL],1)
    AS Name, HyperlinkPart([URL],2)
    AS Addr, HyperlinkPart([URL],3)
    AS SubAddr, HyperlinkPart([URL],4)
    AS ScreenTip
    FROM Links

0
 
daveokstAuthor Commented:
Thank you for the reference... the VB isn't an option here.  We could implement the sql though.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now