Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RE: MODULE TROUBLE (Access2000)

    Hi guys.
    This post is regarding
    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=86052&page=0&vie w=collapsed&sb=5&o=0&fpart=>MODULE TROUBLE</A>

    Rory I've used
    objWord.Close
    It closes the document but theres only one teeeeniee weeeeine problem, before it closes the document, it prompts to save the mail merged document, Is there any way I could stop this? Maybe save changes automatically???

    Thanx 4 all the help Rory
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: RE: MODULE TROUBLE (Access2000)

    Hi,
    Take a look at Word's Application.DisplayAlerts property. If you use
    appWord.DisplayAlerts = wdAlertsNone
    before closing objWord and then reset it afterwards with
    appWord.DisplayAlerts = wdAlertsAll
    you should avoid the prompts.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: MODULE TROUBLE (Access2000)

    <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23> <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21> <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    THANK YOU SOOOOOOOO MUCH RORY!
    EVERYTHING WORKS MORE THAN FINE!
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/kiss.gif border=0 alt=kiss width=34 height=15> <img src=/S/rose.gif border=0 alt=rose width=15 height=15>
    Ur an <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •