Attaching an external document

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello all,
Here's what I would like to happen...
Browse for file dialog comes up, user selects a file (or multiple files),
the files will probably be on their computer, so after they select it (them)
I want to move the files to a particular folder the server (everyone has the
same mapped drive I:... for the db data).
This will be happening from 2 different forms.
I am figuring on adding a table with 3 fields, the name of the form it came
from (which will be either a customer feedback or corrective action) , the
record it should be attached to and then the filename for the attachment,
past that, I'm lost.
I also need the ability to open these files. I am assuming there is a way to
open them in whatever default windows program each user has on their comp.
It sounds simple to me, but I know I don't possess the programming knowledge
to do it.
BTW, it's Access 2002 on WindowsXP boxes.
Thanks in advance, looking forward to the replies.
 
What you want is to use the file dialog. Take a look at

http://www.mvps.org/access/api/api0001.htm

Then you can copy/move the selected file to your predetermined directory.

Below are a few basic examples of working with external files.
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='ImageManager.mdb'

To open the files add a button and use the Application.FollowHperlink method.
 
Daniel,
That worked like a charm, got it up and running over the weekend and will
implement this afternoon.
Thanks for guiding me to the right info.
Now if I could just get this website to let me rate it, we'd all be happy.
Joe
 
Back
Top