Force focus to MS Word

[Guest]

I have an application where I am merging to word documents and the merge is
working as desired. However, when attempting to save the new merged document,
a check is made to determine if a document by that name already exists. If
one exists, the user is notified with a dialog box from Access.

My questions is, What code can I use to force the new Word document to be
displayed and have the focus after the message box? Right now Access remains
as the window with the focus and MS Word is behind it.

Any assistance is appreciated.

 

[Arvin Meyer [MVP]]

Generally, you'd refer to the Word object in the automation and make it
visible like:

objWord.Visible = True

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Alvin,

Thanks for the reply. However, it is not visibility that I am having a
problem with. It is a windows thing. The document is merging and being
displayed but the window in which MS Word and the document is being displayed
is behind the Access application window.

I need to force the window that contains Word and its document to show in
front of the Access application.

Any help is appreciated.
--
HTH

Mr B

Generally, you'd refer to the Word object in the automation and make it
visible like:

objWord.Visible = True

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access