how to open external files like pdf, jpg etc

[v5652]

i want get the solution to open .pdf files using Microsoft Access 2003.

i can open .doc or .xls files. but can't open pdf files or jpeg files using vba code.

if anyone know the solution to this,
please help.
thanks in advance.

 

[RoyVidar]

I like using the ShellExecute api to open any files that are registered on the computer. There's a ready to use wrapper function here

http://www.mvps.org/access/api/api0018.htm.

Else, some like the Application.Followhyperlink method too (look it up in the help file).

Roy-Vidar

 

[v5652]

thanks RoyVidar for your immediate reply.
i will check the link and try it and will be back soon.

 

[addy]

I have a database which users can view files from. I simply set the hyperlink address of a command button to the relevant file path and when they click the button it opens the file.

 

[zevw]

Try this

Public Function OpenDocument(strDocPath As String)

Dim Fl As Long
Fl = Shell("RUNDLL32.EXE URL.DLL,FileProtocolHandler " & strDocPath, vbNormalFocus)
    
End Function

I think got it off this site

 

[Remou]

I generally use FollowHyperlink.

[tt]FollowHyperlink "C:\Docs\AnyFile.Doc"
FollowHyperlink "C:\Docs\"
FollowHyperlink "

http://Docs.com/AnyFile.html"

[/tt]

FollowHyperlink will open a file using the default application for registered extensions. You can open Websites, email (using mailto, files, directories and so on.

http://lessthandot.com

 

[v5652]

thanks RoyVidar & thanks all of u.
i have tried the link given by RoyVidar and it works very well.
also i will try the followhyperlink.
thanks for your reply.