[AccessD] Access/Word Interaction

William Hindman wdhindman at bellsouth.net
Fri Aug 1 10:51:41 CDT 2003


BerichtMichael

...not done this but I'd think that from within your Access VBA where you create the word object you could use "with events" code something like:

With oTmpDoc
        
        .Activate
        .MsgBox "Process Finished"      
       ' insert your response code here
       
End With

...as I said, this is off the top of my head and worth exactly what it cost you :)

William Hindman
"You know the world is going crazy when the best rapper is a white guy, the best golfer is a black guy, The Swiss hold the America's Cup, France is accusing the US of arrogance, and Germany doesn't want to go to war."
  ----- Original Message ----- 
  From: Michael Brösdorf 
  To: Access Developers discussion and problem solving 
  Sent: Friday, August 01, 2003 9:32 AM
  Subject: [AccessD] Access/Word Interaction


  Dear group,

  I have an Access application that creates a MS Word document and inserts some text into it and makes it visible (so that users can start working with it right away). 
  When that process is finished I want to inform the user with a MsgBox. 
  The problem is, that this activates MS Access (my application), but I want the Word-Dokument to stay active. 

  Is there something like WordObj.application.Msgbox?


  TIA,

  Michael


------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030801/f50c9d05/attachment-0001.html>


More information about the AccessD mailing list