Inserting Files in Access for Database Results Wizard & Database Interface

[Steve]

I want to insert different PDF files in fields in
Database Interface Wizard. How do I do this? Basically,
when someone searches using the DRW, I want them to be
able to click on a link in the appropriate field in the
database to see the document in PDF.

Thanks,
Steve

 

[Kathleen Anderson [MVP - FP]]

Import the PDF files into your web - I would recommend putting them all in the same folder.
Add a text field to your table and store the full path to the PDF in that field (by full path I mean www.yourliveweb.com/pdfs/file1.pdf )
Import that database into your web.
Create the database results page, then, in Normal View, right-click on the field, select Hyperlink | Parameters
Click in the Path box (where you see http:// ), the Insert Field value button is now available to use.
Click on it and all the fieldnames in your database will drop down from that button.
Choose the field with the URL in it and this code will appear in the box:
http://<%=FP_FieldLink(fp_rs,"URL")%>Click OK twice, save the page, and Publish to your live site.


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

What You Should Know About the Blaster Worm and Its Variants
http://www.microsoft.com/security/incident/blast.asp

 

[MD WebsUnlimited.com]

I would recommend that you *not" use the "full path" but use relative
addressing instead. Relative addressing allows you to use any domain and
upper level folder qualification that you choose while maintaining file
qualifiction at the folder level. It short it allows you to move the
structure without a lot of maintenance.

root relative addressing omits the domain /myfolder/myfile.htm
abs addressing http://www.mydomain/myfolder/myfile.htm
relative addressing myfolder/myfile.htm

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
----------------------------------------------------------------------------
--------------------
If you think I'm doing a good job, let MS know at (e-mail address removed)

Import the PDF files into your web - I would recommend putting them all in
the same folder.
Add a text field to your table and store the full path to the PDF in that
field (by full path I mean www.yourliveweb.com/pdfs/file1.pdf )
Import that database into your web.
Create the database results page, then, in Normal View, right-click on the
field, select Hyperlink | Parameters
Click in the Path box (where you see http:// ), the Insert Field value
button is now available to use.
Click on it and all the fieldnames in your database will drop down from that
button.
Choose the field with the URL in it and this code will appear in the box:
http://<%=FP_FieldLink(fp_rs,"URL")%>Click OK twice, save the page, and
Publish to your live site.


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

What You Should Know About the Blaster Worm and Its Variants
http://www.microsoft.com/security/incident/blast.asp