Attaching WP, Excel, Adobe files to an Access database Form using a control key

[mcraven]

Is it possible to attach a WP, Excel, or Adobe file to a form, possibly by using a control key? How?

 

[Ziggy1]

attach it in what way? what are you trying to do?

 

[mcraven]

Ataching WP, Excel, Adobe files to a form

Ziggy,

What I need the user to be able to do is click on a button, have it take them to an application (WP,for example) (and this I can do), but then I want them to be able to select a document from whatever directory, and attach it to the form. The person I'm writing this database for wants the user to be able to attach documentation right to the form, rather than supply paper copies. Is this even possible?

 

[Ziggy1]

maybe "attach" is the wrong word, would it be more like display the document based on the selected record? Or if you mean attach (explictly) then I would interpret that to embed the document . But again that would probably mean with the selected record.

example I have had a database where Images were linked to the record, so when a record was selected, the Image would appear.

The other method is to Embed, embedding however does create a large database file size.

 

[mcraven]

Attaching WP, ect...

Ziggy,

Let's say you are the user. You open the form and enter your record info. You get to the field that says "attach documentation". You press a button labeled "adobe". Adobe comes up and you find the document you created yesterday that shows detailed info regarding the record you just entered into the database. you double click on the document and somehow, miracuously, it attaches to the form in Access. The next time you go to that record in Access, you see the adobe icon on that record with the file name label under it and you can click on it to see the document. Can this even be done?

 

[Ziggy1]

look here, this is a similar scenario to yours. I down loaded the sample DB there and it looks like it suits your needs

http://www.access-programmers.co.uk/forums/showthread.php?t=33877&highlight=linking+files


Download thisfile (zip) Attach.mdb

for your purposes I would change the View calc File button code

Private Sub Command45_Click()
Application.FollowHyperlink Text43
End Sub

and the attach button to show all files, not just Excel


It would be a good idea to create a folder to store all your files that are linked to the database. Also place the DB and the folder on the C drive and not User\Mydocs..

 

[Ziggy1]

sorry not text43, that was one I added when i was playing around with it, rather...

Application.FollowHyperlink QuoteWorkout

which is the hidden control on the form (lower right), that displays the path