Making word the active window

[Doug Leveille]

I create a word document from Access. I make the word
object visible and create and save the document. My
problem is that the word documentis maximized but resides
behind the Access window. The user must click on the
word document in the task bar to bring it to the front.
Is there an easy way to automatically have it appear in
front of the Access window?

 

[Cheryl Fischer]

Normally, Word will open as the active window using automation. Is it
possible that you have a form open which has its modal property set to Yes?

 

[Albert D. Kallal]

You can use:

wordApp.Activate
wordApp.WindowState = 0 'wdWindowStateRestore

I also have a template generator for word that allows you to word enable any
ms-access form you have with one line of code. It builds the templates, and
then lets you merge to them. It also fixes all of the word focus/maximize
problems.

You an give the sample a try if your wish:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html