<!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>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=614000203-13032003><FONT face=Arial color=#0000ff
size=2>Ouch!</FONT></SPAN></DIV>
<DIV><SPAN class=614000203-13032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=614000203-13032003><FONT face=Arial color=#0000ff size=2>Thanks
for letting me know before I did the same thing!</FONT></SPAN></DIV>
<DIV><SPAN class=614000203-13032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=614000203-13032003><FONT face=Arial color=#0000ff
size=2>Dan</FONT></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>William Hindman<BR><B>Sent:</B> Tuesday, March 11, 2003
6:01 PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] Adding Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dan</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...the FSO is a really nice new tool ...I was so
enthused I converted an entire app over to using it before discovering it
doesn't work in a runtime environment :(((((</FONT></DIV>
<DIV> </DIV>
<DIV>William Hindman<BR>"We have gone forth from our shores repeatedly over
the last 100 years . . . and put<BR>wonderful young men and women at risk,
many of whom have lost their lives, and we<BR>have asked for nothing except
enough ground to bury them in." Colin Powell</DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dwaters@usinternet.com href="mailto:dwaters@usinternet.com">Dan
Waters</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, March 11, 2003 1:47
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Adding
Attachments</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2>Yes!</FONT></SPAN></DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2>Look through File System Objects (FSO). A starter on FSO is at
<A
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;186118">http://support.microsoft.com/default.aspx?scid=kb;en-us;186118</A>.
This is code that provides a lot of ability with file
manipulation. Files can be copied to a permanent location on a
server, and can then be re-opened using a hyperlink to that file. Your
code will need to re-name the file so that it is identified with the
particular database record, and FSO can do that as well. I created a
table to store these hyperlinks, since a singe record can have more than one
attachment.</FONT></SPAN></DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2>Also, go to <A
href="http://www.candace-tripp.com/access_downloads.htm">http://www.candace-tripp.com/access_downloads.htm</A> and
download the Windows Common Dialog demo prepared by Candace Tripp. (I
still appreciate Candace's work on these every time I save another
attachment.) The Common Dialog will get the full path to a saved file,
which can then be used by FSO to move or copy files.</FONT></SPAN></DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2>Have Fun!</FONT></SPAN></DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2>Dan Waters</FONT></SPAN></DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999422018-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV><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 7:51
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Adding Attachments<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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>