Solved

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

Posted on 2002-07-23
5
339 Views
Last Modified: 2008-03-17
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
0
Comment
Question by:tcoc
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:zuijdhoek
ID: 7172114
I don't understand what you mean. What do you mean by using the FollowHyperlink-method?

Mark
0
 

Author Comment

by:tcoc
ID: 7172125
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
 
LVL 50

Expert Comment

by:Ryan Chong
ID: 7173715
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
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 200 total points
ID: 7173767
0
 

Author Comment

by:tcoc
ID: 7177300
Thanks for the help,

tcoc
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question