[AccessD] Adding Attachments

Ouch!
 
Thanks for letting me know before I did the same thing!
 
Dan

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of William Hindman
Sent: Tuesday, March 11, 2003 6:01 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Adding Attachments


Dan
 
...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 :(((((
 
William Hindman
"We have gone forth from our shores repeatedly over the last 100 years .
. . and put
wonderful young men and women at risk, many of whom have lost their
lives, and we
have asked for nothing except enough ground to bury them in." Colin
Powell

----- Original Message ----- 
From: Dan  <mailto:dwaters at usinternet.com> Waters 
To: accessd at databaseadvisors.com 
Sent: Tuesday, March 11, 2003 1:47 PM
Subject: RE: [AccessD] Adding Attachments

Yes!
 
Look through File System Objects (FSO).  A starter on FSO is at
http://support.microsoft.com/default.aspx?scid=kb;en-us;186118.  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.
 
Also, go to http://www.candace-tripp.com/access_downloads.htm 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.
 
Have Fun!
Dan Waters
 
 
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Hollis,Virginia
Sent: Tuesday, March 11, 2003 7:51 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Adding Attachments



Is there a way to add a document as an attachment to a database? 
 
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.
 
Does anyone have any idea how this might be done?
 
Virginia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030312/ddc777e9/attachment-0001.html>