How do i make it the active document?

[GooberFish]

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, _
NewWindow:=True, AddHistory:=True
End Sub

The links work, and the Word documents open.

The problem is this - once the Word document opens, it immediately minimizes.

I need for the Word document to remain the active document until the user decides that she is finished looking at it.

I have tried several different approaches; nothing seems to work.

Do you have any suggestions or thoughts about this? Thanks.

 

[ajetrumpet]

I helped Mike Here:

http://www.access-programmers.co.uk/forums/showthread.php?t=156796&highlight=word

You may find your answer somewhere in that thread.