Opening a file from Access in its default association

[tito]

1) I am sorry if my english is not that good, and 2) if this is a
repeated question, I can't find it in this forum.

I have an Access database where then field named "Filename" contains
the file name , including the path and the extension (e.g.
M:\Myfiles\CAD\12345678.dwg)

I have created a form, and in this form I would like to open the file
in the field "Filenanme" with a command button, wich will open the file
in the application that is its default association (like double-click i
explorer).

Any idea how to do that?
Thanks in advance
/Tito

 

[Allen Browne]

FollowHyperlink will open it with the program registered for that file type.

If you want something more powerful, ShellExecute
http://www.mvps.org/access/api/api0018.htm

 

[tito]

Thanks Allen, but how do I pass the file name in the field "Filename"
as an argument? I am a newbee, sorry if this is a stupid question.

Thansk in advance
/tito

 

[Allen Browne]

Try:
FollowHyperlink "M:\Myfiles\CAD\12345678.dwg"

If the file name is in a field called MyHyperlink:
FollowHyperlink [MyHyperlink]

 

[tito]

Thanks Allen, that solved my problem.

/tito