<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=850360015-11032003>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=850360015-11032003>Do you
know if there is a way to default the hyperlink to use "relative path to
hyperlink"? </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=850360015-11032003>It
always wants to use http:\\ for the hyperlink instead of the path. I set the
Base to the directory and folder. I set a field to Hyperlink, I was hoping that
all the customer would have to do is type the name of the document into the
field (Test Attach.doc) and it would open the hyperlink to the document. Is this
correct? What am I missing?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=850360015-11032003>************</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=850360015-11032003>The
archives only show the past 3 months, how do you get to the previous
messages?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=850360015-11032003>Virginia</SPAN></FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Wortz, Charles
[mailto:CWortz@tea.state.tx.us]<BR><B>Sent:</B> Tuesday, March 11, 2003 8:23
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Adding Attachments<BR><BR></DIV></FONT>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff size=2>Since you are
storing the files externally to Access and only storing a link (path name) to
the files in Access, it makes no difference to Access what types of files they
are. Linking to external files is a frequent subject on this list so you
should be able to find a lot of hints in the archives. Some non-obvious
search terms that may help are "Image files" and "bloat."</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas
Education Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701
N. Congress Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin,
TX 78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV align=left class=OutlookMessageHeader dir=ltr lang=en-us><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Tuesday 2003 Mar 11
08:13<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Adding Attachments<BR><BR></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=360580714-11032003>I
really do not know what I am after :-) I am open for any ideas because I sure
can't think of any...</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=360580714-11032003>Make
a folder to store the attachments and they would place them in the directory?
Would it matter if they were .pdf or .doc or any type of
file?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=360580714-11032003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Wortz, Charles
[mailto:CWortz@tea.state.tx.us]<BR><B>Sent:</B> Tuesday, March 11, 2003 7:59
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Adding Attachments<BR><BR></DIV></FONT>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff size=2>You can have
a hyperlink field in a table in which the link to the external document is
placed. Is this what you are after?</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR></P>
<DIV></DIV>
<DIV align=left class=OutlookMessageHeader dir=ltr lang=en-us><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
Hollis,Virginia [mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Tuesday
2003 Mar 11 07:51<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Adding
Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=830524313-11032003>Is there a way
to add a document as an attachment to a database? </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003>The database is used to request services. The
data is entered by a customer and sometimes the customer needs to add
additional documentation to support their request. The attachment might be a
sketch or Word file.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=830524313-11032003>Does anyone have
any idea how this might be done?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>