Attaching a file to a form Using Windows Explorer

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

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.

Hi,

Attachment field....Hmmmm....that would make sense...I think thats what i would like to do...only its A2003!!

<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

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?

As a start to what I want, its absolutely great.

;-)