Attaching a file to a form Using Windows Explorer

Hi all,

I am trying to attach a PDF file to an Input form but I would like to select the file from a particular directory. I would like to do this by somehow selecting the file using a Windows Explorer Type of "window" which would appear on the form.

My idea is a bit like when using some kind of backup application where one can actually view the Directories and select the file from there.

Thanks (I hope I have explained it well enough)
PipMicAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
<3.  I would also like to save on the form the location of the document. Rather than having a link, the user should be able locate the file (Via a Windows Explorer like window) click on the file and somehow save the location of the file using the input form.>

Then this can be done with something like this attached file:
Simply click the button to browse to and select the PDF file
(I threw in a control to view the PDF as a bonus, ...Happy Birthday...)
;-)

JeffCoachman


AccessBasicLinkOpenPDFDialogBox.mdb
0
 
Jeffrey CoachmanMIS LiasonCommented:
Please clearly define *exactly* what you mean by "attach a PDF file to an Input form"

If you are using Access 2007 or newer you can create an "Attachment" field to your table.
This will make it easy to attach a PDF filed in you DB.

But again, please state your ultimate goal here.

If you just want to display the pdf in the form ,you can use a webbrowser control and "Link" to the pdf.

JeffCoachman
0
 
PipMicAuthor Commented:
Hi,

I'm using Access2003.

Yes I didnt explain myself properly...

What i have is a form which i want to poulate. One of the fields is meant to pick up a pdf file which is stored in some directory in my computer.

In other words I want to populate a table with details about a document and as part of the process i want the user to be able to pick up the relevent file (in PDF)  from a particular folder and assign it to the deatils of the file within the form.

I suppose it could work as you suggest with a link, but I want the initial process of retrieving it and saving it via the form.

I hope I'm making sense!

So if ever someone searches the file via a search form there will be a link (of some sort) that if clicked on will open the PDF.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
PipMicAuthor Commented:
Hi,

Attachment field....Hmmmm....that would make sense...I think thats what i would like to do...only its A2003!!
0
 
Jeffrey CoachmanMIS LiasonCommented:
<In other words I want to populate a table with details about a document and as part of the process i want the user to be able to pick up the relevent file (in PDF)  from a particular folder and assign it to the deatils of the file within the form>

Now I'm even more confused...?
\_O-o_/


Explain exactly what the user will be doing, what they will be seeing,  nd exactly what needs to be stored in the record..

In other words what you are asking for may only require storing the Path to the PDF.
I really don't know what either of these statements mean:
"populate a table with details about a document "
(Can you explain *exactly* what this means?, with a specific example of what will be stored in the table)
Or:
"pick up the relevant file (in PDF)  from a particular folder and assign it to the deatils of the file within the form. "
(Again, can you explain *exactly* what this means?, with a specific example of what will be stored in the table)

In other words, show me an *exact* graphic of *exactly* what you want stored in the record...

JeffCoachman
0
 
PipMicAuthor Commented:
hi,

Ok this is what it is.

1.The user has received a document and has saved it in a particular folder of the PC.

2. The user then goes about feeding the details of the document (via a form) into a Documents table, i.e. DateOfDocument, ReceivedFrom, Subject of the document, etc, etc.

3.  I would also like to save on the form the location of the document. Rather than having a link, the user should be able locate the file (Via a Windows Explorer like window) click on the file and somehow save the location of the file using the input form.

(Its a bit like backup applications where one can select the files via a user interface that actually allows the user to select the file to be backed up!!)

The idea being that when a search for a file is done via a Search Form, not only will I be able to filter the records and find the required file based on the criteria but I would be able to click on "something" - a link of sorts- that will actually open the document in PDF.

Has this made any sense?
0
 
PipMicAuthor Commented:
As a start to what I want, its absolutely great.
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.