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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
PipMicAuthor Commented:
Hi,

Attachment field....Hmmmm....that would make sense...I think thats what i would like to do...only its A2003!!
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PipMicAuthor Commented:
As a start to what I want, its absolutely great.
0
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.