Accessing Attachments from a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database where each record tracks information about a
Request for Quote. I need the ability to allow the user to enter the name of
the attachment (including the location of the file, if necessary), and then
be able to open up that attachment from the same form. I want to store the
attachments, i.e. PDFs, Excel spreadsheets, on a shared drive so that anyone
looking at the RFQ can also look at the attachments.

I see in Access how to put an attachment into a form, but as far as I can
tell, the file name and location are already known and coded into the form as
a linked object. I want to be able to enter the attachment name, and then
link to it as necessary.

Please help!

Thanks,

Dianne
 
Dianne:

The following KB article describes how to programmatically change the path
to a linked object. You may be able to use this as a starting point.

http://support.microsoft.com/default.aspx?scid=kb;en-us;311147

Regarding entering the attachment name, one alternative would be to use the
FileDialog object to allow the user to browse for the attachment. You can
find more information about the FileDialog object here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;824272

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have an Access database where each record tracks information about a
Request for Quote. I need the ability to allow the user to enter the name of
the attachment (including the location of the file, if necessary), and then
be able to open up that attachment from the same form. I want to store the
attachments, i.e. PDFs, Excel spreadsheets, on a shared drive so that anyone
looking at the RFQ can also look at the attachments.

I see in Access how to put an attachment into a form, but as far as I can
tell, the file name and location are already known and coded into the form
as
a linked object. I want to be able to enter the attachment name, and then
link to it as necessary.

Please help!

Thanks,

Dianne
 
Back
Top