Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Need Help with Word Merge issue

Discussion in 'Information Technology' started by Mr B, Jul 28, 2006.

  1. Mr B

    Mr B
    Expand Collapse
    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.

    --
    HTH

    Mr B
     
  2. Loading...

    Similar Threads Forum Date
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    17 yr old Baljit needs your help Get Involved Aug 19, 2015
    Learn Punjabi Need help Language, Arts & Culture May 20, 2014
    United Sikhs From United Sikhs. Phillippines Needs Your Help Sikh Organisations Nov 22, 2013
    Need Help... (Keeping Hair) Questions and Answers Sep 2, 2013

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    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

    --
    Wayne
    Manchester, England.



    "Mr B" wrote:

    > 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.
    >
    > --
    > HTH
    >
    > Mr B
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    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

    "Mr B" <MrB@discussions.microsoft.com> wrote in message
    news:0A270D84-2938-446F-8B9F-A0026C2CD30E@microsoft.com...
    > 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.
    >
    > --
    > HTH
    >
    > Mr B
     
  5. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

Share This Page