[AccessD] Adding Attachments

MessageDan

...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 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/20030311/14a54a0a/attachment-0001.html>