Need Help with Word Merge issue

[Guest]

Sorry for posting this again, but I still need some help.

I have an Access application that merges various word documents. Normally
this works as expected and the new document is displayed in a Window and that
window has the focus.

However, part of the process checks for a duplicate file name. If the
duplicate is found then a message is presented by Access. After the message
is presented and the user has completed their interaction with the
application, the Word document is merged and displayed. However, the focus
remains in the Access application.

What code can I use to force the focus to the new merged Word document Window?

Thanks for any assistance.

 

[Guest]

Hi

Not sure if it's what you are looking for but Albert Kallal has a brilliant
mailmerge process that may point you in the right direction. I have tried it
out and it works really well and (for me - most importantly) is very simple
to load and use.

http://www.attcanada.net/~kallal.msn/wordmerge/index.html

Hope this helps

 

[Arvin Meyer [MVP]]

Try looking in your code for the Visible statement, something like:

objWord.Visible = True

make sure that statement appears after the code that checks for duplicates
routine.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Albert D.Kallal]

http://www.attcanada.net/~kallal.msn/wordmerge/index.html

Thanks Wayne...att no longer provide web services in Canada...so, that link
has moved....

http://www.members.shaw.ca/AlbertKallal/wordmerge/index.html