Help storing links to .pdf files in MS Access
Posted on 2006-07-23
Hi. I'm pretty sure this is a basic thing, but I just can't decide how to do it.
I'm planning an Access database and one of the tables will be very simple -- a Quote Number, an Expiration Date, and possibly a link to a .pdf document. Each quote will have a relevant .pdf, and all of the .pdf documents will be stored in a folder named "PDF_QUOTES" one level below the the database file. Each pdf file will be named with the quote number, so the record might be (12345, 9/01/06, \PDF_QUOTES\12345.pdf)
I will then have a form on which I'd like to have the user be able to click a button that would cause Adobe Reader to open and display the matching .pdf file. There will be no need to display the .pdf file 'inside' the form.
What's the easiest way to do this? I'd really like the user to be able to type in the quote number and expiration date, and have Access just "know" that there will be a .pdf document in the appropriate place...
FYI, I don't have a good grasp of VBA when it comes to Access, so if there's going to be any coding involved, I'll need some help!