Using Switch Board Manager to Open Hyperlink to MSWord Doc (1 Viewer)

[Marbinski]

I'm using the switchboard manager for my database. I want one the buttons to be able to open a MS Word Document. Basically, I need help creating a macro that opens a word file on a specified network address.

Ex. The word file is located on the network X-Drive address:

X:\Networkfolder\Wordfile


Any help would be great....thanks a million.

 

[Agnostiker]

like this?

Private Sub Button_Name_Click()
    FollowHyperlink "X:\Networkfolder\Wordfile"
End Sub

Agnostiker

 

[Marbinski]

In the macro design view, how would I implement that solution?? What "actions" or "commands" are supposed to be run? Thanks again.

 

[Agnostiker]

Ups, sorry I failed

In a standard module (If you don't have create a new one) you write this function:

Function OpenWordDoc()
    FollowHyperlink "X:\Networkfolder\Wordfile"
End Function

With the switchboard manager you create a new entry kind "Execute function" (maybe it's named 'run function'. I don't know because my Access is a german one )
There you entry the function name (i.e. 'OpenWordDoc')
Ready.

Another kind I don't know, sorry!

I'm anxious if it will help...

Agnostiker

 

[Marbinski]

Very nice...it worked out great.

I created the module, and inside the switchboard manager I put:

Command: Run Code
Function Name: OpenWordDoc

**Note: For anyone trying this, remember to add the .doc file extension in the Network address**

Thanks so much!!

 

[Agnostiker]

...so I'm appeased once again...

Greetings from Berlin

Agnostiker