Display msgbox in another MS application

[journeyman]

Hi all,



This may be a curly one, and I don't expect many people to understand what this problem is, let alone provide a solution, however, if you know what I'm talking about, perhaps you might know an answer.

I am opening a word document from access - easy
I am detecting events in that word document that can be trapped by access - not so easy.

The purpose for this is to collect information from a Word form - and feed back new information from the DB into the Word form - and works well.
I'm sorry to say that I cannot upload this DB dues to variant issues.

On occasion a change to a word document may create an error - e.g. modifying a date field with the wrong date information. This error is picked up on the Access side.
Neither the word application object or the Word document object seems to have an error event.

Becuase I can trap the error on the Access side, is there a way to project a error message box into the word application?
Or
Is there a way to trigger the Word msgbox - remember that word is a *.docx file.

Cheers

[Welshgasman]

Have you tried
WordObject.MsgBox ?

[Edgar]

I don't know if you could trigger a msgbox, but you can easily display a message in the statusbar.
WordObject.Statusbar = "error happened"

If you absolutely need to trigger the msgbox, then maybe add a sub to the docx file. Or perhaps you could save something in a general macro library and call it from Access somehow? note I've never done such a thing, it's just an idea.

If anyone wants to try to solve this, I attached a little playground file for that.

[Micron]

The only way I know of is that the code would have to be in the Word document so that you could call it from Access. That won't work with a docx file so I'd say no way to raise a message box in Word by using only Access code. Will be happy to be proved wrong though.

[journeyman]

Thanks all for answers

Welshgasman - I've been down the WdApp.msgbox rabbit hole which lead nowhere. It's not a property of the Application class, otherwise, it would be awesome.


Edgar and Micron. This is an interesting idea - have some code inserted into the doc that triggers, but because it's a docx, that code would have to come out while allowing the save of the doc content, but without attempting to save the event.

My class stores the word document. maybe there's a way to use that class to store the event? That's a bit out there, but could be a fun excercise. I'll chase it up.

Thanks for thoughts all.