I am trying to build an email/database application, I can retrieve all data to the DB but I want to make an hyperlink to the folder where the application saves the attachments, something like this:

objCmd.Parameters.Add("@RevAttach", OleDbType.VarWChar, 100) _
         .Value = (LocHyp & (oMsg.Attachments(ii).FileName))

where LocHyp is the string for the location (\\Server\Folder\), I am using access, and when it adds the parameter the link dose not work, because it only uploads the text to display, any ideas?

Thank you

Post the location to a Hyperlink field in a table.

mmcdonal

Look it up at: http://wrox.books24x7.com

I did that, it does underline the full path, but did not work, it post the location as TEXT TO DISPLAY.