Open a program useing a button

[adz2013]

Is there a way to call a file when you open MSWord through access?

 

[simongallop]

This way opens word becauseyou are calling a specific word document

Dim HypLink As String

HypLink = "C:\MyDocuments\TestFile.doc"
Application.FollowHyperlink HypLink, , True

HTH

 

[adz2013]

Thanks Harry

 

[Shep]

Here's another way:

Dim objWord As Object
Set objWord = CreateObject("Word.Basic")
With objWord
    .AppShow
    .AppMaximize
    .FileOpen "c:\windows\desktop\test.doc"
End With
Set objWord = Nothing