My Access Tips

My Access Tips for Custom Microsoft Access

Application Development

by Matthew V Carmichael

Need Help?

My Tips

Developing / Deploying

Links

Resources

Quick Tip Details

Question:
How do I open a file in another application from MS Access?

Answer:
A simple way to accomplish this is to use the FollowHyperlink method.

Code:

'Open a File
Application.FollowHyperlink ("C:\MyFile.doc")

'Open a Folder
Application.FollowHyperlink ("C:\Program Files")

'Open a file where the file’s name and path is stored in a textbox on a form
Application.FollowHyperlink (me.YourTextBox)