opening external programmes from Access

[Guest]

I have linked text files into my database using hyperlinks. WHen I click on the hyperlink in a form, the file is opened using whatever programme is set as the default for that filetype on that PC. However there are two applications that might be used to view and edit the files. I would like to create a command button to open the file using a particular programme - is this possible, and if so, how can I set it up?

Thanks for any advice

Alice

 

[Lynn Trapp]

Use the Shell function

Shell("PathToProgram", vbNormalFocus)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I have linked text files into my database using hyperlinks. WHen I click

on the hyperlink in a form, the file is opened using whatever programme is
set as the default for that filetype on that PC. However there are two
applications that might be used to view and edit the files. I would like to
create a command button to open the file using a particular programme - is
this possible, and if so, how can I set it up?

 

[Guest]

Thanks for taking the time to answer my question.

Alice