ACCESS 2007 - FOLLOW HYPERLINK PROPERTY - MAKING WORD 2007 THE ACTIVE DOCUMENT
Posted on 2009-04-13
I coded hyperlinks to display on an Access 2007 report. The report lists sequential file identifiers assigned to Word documents. Each file identifier listed in the report is hyperlinked.
By clicking on a hyperlink, the user is taken to the desired Word document.
I wrote the following code to achieve this effect:
Private Sub fldNAME_Click()
Dim strInput As String
strInput = "Y:\SERVERPATH\" & fldNAME & ".doc"
Application.FollowHyperlink strInput, _
The links work, and the Word documents open. Well and good.
The problem is this - once the Word document opens, it immediately minimizes. That is not good. I need the Word document to remain the open, visible, and active document until the user decides that she is finished looking at it.
I have tried several different approaches; nothing seems to work.
Thanks for your help.