How do I keep Access from Minimizing when linking to MS Word

How do I keep Access from Minimizing when linking to MS Word, or keep it Maximized or Active or whatever?

I am using the FollowHyperlink method to open MS Word and bring up a document on the C Drive.  Unfortunately, when I close word, I MS Access is minimized.

Does anyone have a simple solution to this?  I have seen some answers on this, but I'm too dumb to follow them.

Maybe some code someone has already used that I can just copy over?

Thanks,

tcoc
tcocAsked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
0
 
zuijdhoekCommented:
I don't understand what you mean. What do you mean by using the FollowHyperlink-method?

Mark
0
 
tcocAuthor Commented:
Private Sub Comments_Click()
Dim PathName As String
PathName = "C:\tcoc\" & Me.[Comments]

Me.Application.FollowHyperlink PathName

End Sub

If the value of field [Comments] is an MS Word document, then MS Word will open and display that document.

Upon closing Word, Access is now minimized.


Per Access Help:
"By using the FollowHyperlink method, you can follow a hyperlink that doesn't exist in a control. This hyperlink may be supplied by you or by the user. For example, you can prompt a user to enter a hyperlink address in a dialog box, then use the FollowHyperlink method to follow that hyperlink."



tcoc
0
 
Ryan ChongCommented:
My suggestion is use other method to open the doc file, so that the Access interface is not affected with FollowHyporLink function. Example, use ShellExecute API to open the doc.

regards
0
 
tcocAuthor Commented:
Thanks for the help,

tcoc
0
All Courses

From novice to tech pro — start learning today.