Keeping focus on merged document

[Jen]

Hello. I've ran a merge from Access 97 to Word 97, and
would like to keep the focus on the word document that was
created. I'm saving the document through code, and when I
used wdWindowStateMaximize, it left the focus on the word
document, but I had to toolbars or menus, and I need at
least the print button so that users can print. So I
changed it to wdWindowStateNormal, and now have all the
toolbars and menus, but the focus will not stay on the
document. I want Access to run the mail merge and the
user doesn't go back to Access until they do something
with the Word document they created.

Thanks,
Jen

 

[Cindy Meister -WordMVP-]

Hi Jen,

Set an object variable to this document before you do
anything else, then you can always "grab it", again. Roughly:

Set docResult = ActiveDocument

I've ran a merge from Access 97 to Word 97, and
would like to keep the focus on the word document that was
created. I'm saving the document through code, and when I
used wdWindowStateMaximize, it left the focus on the word
document, but I had to toolbars or menus, and I need at
least the print button so that users can print. So I
changed it to wdWindowStateNormal, and now have all the
toolbars and menus, but the focus will not stay on the
document.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail