Help!! how to attach pdf to access record

[Scanner]

Please tell me how you can attach a pdf to an Access record. We have a large
database of clients in our Access database. We also have paper files for
them that must be scanned and attached somehow with their database
record/info in Access. How is this done? We are a non profit charity and we
must keep detailed records of our clients info in order to get grants. Thank
you for your help! Nancy

 

[Mike Revis]

Nancy,
see access help for "shell"
I'm pretty sure there are other methods that will work but the following
works in my application.
You should have all of the documents in one folder on the server and
reference to them. You don't want the documents to actually be in your
application.
You just want to reference their location so Access can find them.
You will have to change the file path to your actual file path.
In the following you will have to change [MsdsNumber] to the name of the
field where you have the file name stored.

Private Sub cmdMSDS_Click()
'Open the Tech Sheet file.

Dim stAppName As String
Dim FilePath As String
Const cstrPath As String = "\\Paul\MSDS\"

FilePath = cstrPath & [MsdsNumber] & ".pdf"

stAppName = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " &
FilePath

Call Shell(stAppName, 1)

End Sub

 

[Nick]

You can just use a Hyperlink field in a table, put this in text box on a form
and some code that uses Application.FollowHyperlink.