opening external programmes from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Use the Shell function

Shell("PathToProgram", vbNormalFocus)

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


Alice Dawson said:
I have linked text files into my database using hyperlinks. WHen I click
Click to expand...
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?
 
Back
Top