Attaching an external document

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.
 
D

Daniel Pineault

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.
 
J

Joe

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
 
Top