Linking pdfs to records on a report??

[d-mcc56]

Hey all,

On my computer there is 1000s of records with specific agreement numbers. In my database I have a report that displays agreements by their agreement number if they have any outstanding work that has not been completed under the terms. I was curious if it possible to link all the agreement pdfs on my computer to the records in the database? Whether I link it in the query, table, or report I don't know either. Ideally I want to be able to provide the database with a path to all the agreements, then match each agreement in the database to the files on my computer, then if possible also search for based on keywords and open a pdf if the agreement is clicked on in the report.

To me this sounds like I'm asking a lot, and who knows I might be I don't actually know.


But if you are able to help that would be greatly appreciated.

Thanks!

[June7]

Yes, is possible, can get complicated.

Can have a field in table that stores the file path. If the folder path is the same for all then can construct the path in query or code with an expression.

Are the PDFs named with the agreement number?

Can use FollowHyperlink to open the PDF document.

Or http://allenbrowne.com/func-GoHyperlink.html

[d-mcc56]

The folder path is the same for all of them in my company's share drive.
Once I get to the folder of agreements they all have different agreement folders that are numbered similar to E##.##
in the agreement folders they each have a pdf called "Agreement Signed"
The actual pdf name is the same for all agreements, it's the agreement files that are all different.
I don't know if that simplifies things?

[d-mcc56]

Oh also btw I am using Access 2010 now on Windows 7, no longer access 2003

[June7]

Could have a field with the folder name. If the folder name is the same as the agreement number, just use the agreement number field to construct the hyperlink path.



BTW, could change your user profile.

[d-mcc56]

I am very new to access and I do not know how to construct a hyperlink path

[June7]

That's why I gave you reference to Allen Browne code.

Or you can use the intrinsic FollowHyperlink http://msdn.microsoft.com/en-us/libr...ffice.11).aspx.

Build the hyperlink path string with concatenation of literal text and variable data - use UNC path, like:

"\\servername\path\" & Me![aggreementnumberfield] & "\Agreement Signed.pdf"