Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Create a Hyperlink to a File using Access 2003 Data Access Page

Status
Not open for further replies.

Eutychus

Programmer
Nov 14, 2007
61
US
I want to be able to open a Data Access Page using a browser, select a record, and then open a file (in this case a PDF file) using a hyperlink. I'm using Access 2003 and I have a table with a field defined as a hyperlink field. When I click the hyperlink field, it opens the file in the hyperlink address in that field. When I try to do the same in the Data Access Page, nothing happens. However, I was able to put a URL for Google in the address, and it went to Google. Each record in my table has a person's name with a link already built to a file associated with that person. I want the user to use a browser and open a Data Access Page, find a person in the table, click the link to the PDF file for that person,and see the PDF file open. It works great in an Access form, but I'm new to Data Access Pages and can't seem to get it to work as a DAP. Actually, It would not have to be a hyperlink that opens the file--I just want to open the PDF file from a record pointing to it in the table using the Data Access Page. Anyone have example code for this or able to walk me through how to do this? Thanks much!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top