Open an external file with a button in an Access 2007 form

I am creating a database for my module (I am in the army) and I need a button that will launch the file when clicked. The file is an .xfdl file used for military uniforms in PureEdge. Is this possible and how will I go about it. I've searched for it for as long as I know, but it looks like my Google-Fu won't let me.

Thanks for any help.


source to share

1 answer

If the file type is program related, that is, the file will be launched when clicked, then FollowHyperlink may fit, otherwise you may need to use Shell. For example:

Call Shell("""C:\Program Files\Microsoft Office\Office14\msaccess.exe"" ""c:\docs\db.mdb""", vbNormalFocus)




All Articles