Opening PDF attachments in VB from my Access Data Base

[Linda Schmidt]

I have an access database that has an attachment field. New to programming and have been at this all day. What I would like is for the entire field of attachments to read 'Open' and then click on that word open and it will open the PDF that is attached.

Example

LastName | FirstName | OPEN | Date | Notes | etc

I would just like to click the word OPEN and have the PDF associated with that contact open. If anyone can point me in the right direction, or even help me out with the few lines of code it would be much appreciated.

Thanks

[NeoPa]

Your question is not very clear. We expect (in future) much more effort to make the question make sense.

If I guess correctly though, you may be looking for a Hyperlink type field (Text but with a Hyperlink value). See Error 7980: HyperlinkAddres s or HyperlinkSubAdd ress read-only for Hyperlink for how to manage this.