Bound hyperlink in DAP Access 2003 1

[Saschaloo]

Thanks in advance for your help.
I am using access 2003 and I am trying to design a DAP that will link PDF documents over an intranet. In my table there is a hyperlink field, but I am not having any luck in getting the files to open. So far I have tried setting the control properties to:

Click the Data tab and set the ControlSource property to =document.all("MSODSC").HyperlinkPart([MY FIELD NAME],0)
Click the Hyperlink tab and set the ControlSource property to =document.all("MSODSC").HyperlinkPart([MY FIELD NAME],2)

and the HREF to:
file://Mar-000/Work/Job%20Reports/ (this is the root folder on the server)

but to no avail.

 

[fneily]

Can you show an example of the field [My Field Name]? It should look like this:
Microsoft on the Internet#

http://www.microsoft.com#

Note A hyperlink address can have up to four parts that are separated by the number sign (#):
displaytext#address#subaddress#screentip

Also, remember [My Field Name] must be on the DAP with your bound hyperlink.

 

[Saschaloo]

Thanks for the reply.
Here is an example of the hyperlink form my access table:

BDR\142-48-05-SP1 rev 2 as built.pdf#BDR\142-48-05-SP1 rev 2 as built.pdf#

 

[fneily]

In the following, it states that if you're going to supply the hyperlink from a table, designate it as TEXT. For the hyperlink properties, the hyperlink page and data page must display the same thing in the Control Source option.

http://msdn.microsoft.com/library/?url=/library/en-us/dnacchbk/html/acsybex_chap10.asp

see sections Bound Hyperlink and Binding Hyperlinks to Hyperlink Fields

Also, is the "as built.pdf" part of the file name? If it isn't, then I don't know what it is.

You're basically going to store in a TEXT field, the full path name of the file. You will place this field on your DAP. You will then set the control source of the bound hyperlink to the name of the field.

 

[Saschaloo]

Works great now, thank-you.