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>