Lou Dufresne
asked on
MS Access 2007 - Link to open a PDF
I have a form that has a graphic icon on the form. When the user click on the graphic icon I want to open a PDF file that I have stored in a subdirectory.
I would like someone to tell me the VBA code to use to open a PDF from the click event of an graphic icon on a form.
Thanks in advance for your assistance.
Ldufresne
I would like someone to tell me the VBA code to use to open a PDF from the click event of an graphic icon on a form.
Thanks in advance for your assistance.
Ldufresne
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Enabled property
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The example above should have read
Shell "C:\program files\Adobe\Reader 9.0\AcroRd32.exe c:\Documents and Settings\Username\My Documents\MyPDF.pdf", vbNormalFocus
Shell "C:\program files\Adobe\Reader 9.0\AcroRd32.exe c:\Documents and Settings\Username\My Documents\MyPDF.pdf", vbNormalFocus
ASKER
Both solutions worked fine. The solution that fit best for my needs was nicsaint's solution.
Thanks both of you for your expert assistance
Ldufresne
Thanks both of you for your expert assistance
Ldufresne