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

Question

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.

+3

ms-access button

bizzy401 29 Mar 12 at 12:31

source to share

1 answer

Fionnuala · Answer 1 · 2012-03-29T12:42:50+0000

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)

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

More articles: