Access hyperlinks in Frontpage

G

Guest

I'm creating a database in Access that I want to link to a webpage using
Frontpage. The database contains scholarship information, so I want to
display the scholarship name on the webpage, but have it link to the PDF file
that has a description of the scholarship.

I've figured out how to get a hyperlink into an Access database field, but I
am having problems with the results that are coming up on the webpage. I'm
following the instructions that say to put the TITLE that you want the viewer
to see, then a "#" sign, and then the FILENAME. What is coming up, though,
on the webpage is the entire string.

For example, I type into the database: John Smith
Scholarship#smithscholarship.pdf.

I want "John Smith Scholarship" to show on the webpage as a hyperlink and
then link to the smithscholarship.pdf that is in the same folder. What shows
on the webpage is "John Smith Scholarship#smithscholarship.pdf" as a
hyperlink. How do I get rid of the file name?

The second problem I'm having is linking to the PDF that is in the same
folder as the database and webpage. I've tried using "John Smith
Scholarship#smithscholarship.pdf" and "John Smith
Scholarship#\smithscholarship.pdf" and "John Smith
Scholarship#/smithscholarship.pdf." The only thing that works and links to
the file is if I use the entire web address: ""John Smith
Scholarship#http://myschool.com/smithscholarship.pdf" But there again, it
shows the entire string on the webpage instead of just what I'm telling it to
show for text, which is "John Smith Scholarship."

I hope that all makes sense. Please tell me why it's not working. I've
followed all the instructions in Access and Frontpage Help, I thought...
 
J

Jon Spivey

Hi,

Access hyperlink fields don't work on the web. The easiest way is to have 2
fields in your database one for the url and one for the display text and
then construct the link in your SQL
SELECT '<a href="' + UrlField + '">' + TextField + '</a>' AS YourLink
FROM Table

This will pull the link out of Access, if you're using the results wizard
make sure you check Field Contains HTML
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top