How to open pdf documents from a Microsoft Access Form

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Jul 2007
Posts: 23
Reputation: elanch is an unknown quantity at this point 
Solved Threads: 0
elanch elanch is offline Offline
Newbie Poster

How to open pdf documents from a Microsoft Access Form

 
0
  #1
Aug 4th, 2007
hi friends!
From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document.

please give me tips regarding this.If possible explain with codes.
Thanku in advance.

Elanch
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 12
Reputation: stevenp123 is an unknown quantity at this point 
Solved Threads: 1
stevenp123 stevenp123 is offline Offline
Newbie Poster

Re: How to open pdf documents from a Microsoft Access Form

 
-1
  #2
May 24th, 2008
Hi, to do this, insert a hyperlink by pressing ctrl + k, and then select the file you want to open, but make sure u dont change the location of the pdf file after uve created the hyperlink.

hope this helps
Reply With Quote Quick reply to this message  
Join Date: Jul 2009
Posts: 1
Reputation: wplay12 is an unknown quantity at this point 
Solved Threads: 0
wplay12 wplay12 is offline Offline
Newbie Poster

Re: How to open pdf documents from a Microsoft Access Form

 
0
  #3
Jul 21st, 2009
This opens your file with the default registered program in Windows.

Put this in a bas module (in 1 line):

Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Public Const SW_SHOW = 1

'***********************************
'Put this in a command button in your form

ShellExecute Me.hwnd, "open", "C:\Carpeta\Manual.pdf", "", "", SW_SHOW


Originally Posted by elanch View Post
hi friends!
From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document.

please give me tips regarding this.If possible explain with codes.
Thanku in advance.

Elanch
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC