File Attachment Help !

  • Thread starter Thread starter kay
  • Start date Start date
K

kay

I have created table to keep a track of attached file info.
Fields are : CustID, FileName,FileLocation

In my main form I have created “Attached File†button – (to attach file –
should attach more than one) and “View Attachment†- (to view all attached
file) button.
I have created two list box – one to view the list of attached file (Current
attachment).
And other to view the list which is already there (previously attached)

I need to allow users to upload attachments (docs,
jpgs, tifs, etc.) to a network drive. And View the attachment when click on
“View Attached File†button. I'd like the form to use an existing folder to
save the file.(for eg: c:\CustRecord\)

I have no idea how to allow the user to browse their computer and then
upload or attach the document. I also want to store the link to this file
in a table/form so that it can be browsed by other users.

Thanks for the help.
 
thanks this helps.
but this works only if you want to attach one file.
But in my case there will be more than one attachment for unique ID.
and also that these two textbox (filename and file path) are unbound txt
box, how do i link to tblattach which has filename and filepath are hyperlink
fields.

please guide.
thanks
 
Back
Top