<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff size=2>What I
did was use the Common Dialog control (you can also use File Dialog but it won't
work in a runtime app) to allow the user to pick the current location of the
file. Then I move a copy of it into a designated folder path and store the
full pathname (path and file name) in a database string
field.</FONT></SPAN></DIV>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=123012215-11032003>
<DIV align=left><FONT face=Arial size=2>Doris Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Database Administrator</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Hargrove Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial color=#0000ff
size=2><U>www.hargroveinc.com</U></FONT></DIV></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>Hollis,Virginia<BR><B>Sent:</B> Tuesday, March 11, 2003
10:12 AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Adding Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=850360015-11032003>
<DIV><FONT face=Arial color=#0000ff 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 face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff 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 face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003>************</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff 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 face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003>Virginia</SPAN></FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><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 class=OutlookMessageHeader lang=en-us dir=ltr align=left><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 face=Arial color=#0000ff 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 face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff 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 face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><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 class=OutlookMessageHeader lang=en-us dir=ltr align=left><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></BLOCKQUOTE></BODY></HTML>