Solved

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

Posted on 2002-07-23
5
363 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 52

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 52

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

623 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