Solved

MS Access Hyperlink Field in Asp.net

Posted on 2007-11-28
5
855 Views
Last Modified: 2012-08-13
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
Comment
Question by:daveokst
  • 3
  • 2
5 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
look for  HyperlinkPart  from the Access Help
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
look for  HyperlinkPart  from the Access VBA Help
0
 

Author Comment

by:daveokst
Comment Utility
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
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
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
 

Author Comment

by:daveokst
Comment Utility
Thank you for the reference... the VB isn't an option here.  We could implement the sql though.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now