mangatj
02-20-2006, 09:28 AM
Dear Forum
I am trying to customise an Access database written by my colleague who has since left the company.
On one of the forms, there is a button which allows you to view a microsoft word document stored in a file. The current underlying VB shell function used is to navigate to this document:
Shell strPath & strDocument, vbNormalFocus
The problem I have is that I would like to attach a .pdf document instead of the microsoft word document, and the most obvious thing to do is to change the current strPathToWord, to the strPathToAdobe, and then change the actual path to navigate to AcroRD32.exe, instead of Winword.exe, However this doesn't work. Can anyone help please, i.e. is there a different shell function for adobe applications?
Regards
Jay
I am trying to customise an Access database written by my colleague who has since left the company.
On one of the forms, there is a button which allows you to view a microsoft word document stored in a file. The current underlying VB shell function used is to navigate to this document:
Shell strPath & strDocument, vbNormalFocus
The problem I have is that I would like to attach a .pdf document instead of the microsoft word document, and the most obvious thing to do is to change the current strPathToWord, to the strPathToAdobe, and then change the actual path to navigate to AcroRD32.exe, instead of Winword.exe, However this doesn't work. Can anyone help please, i.e. is there a different shell function for adobe applications?
Regards
Jay