Make Database Visible 1

[madhouse]

I was wondering if someone could help with this problem I have.

I'm opening a Word Document through an Access module to carry out a MailMerge - I've put the code for the MailMerge into the Word Document as opposed to putting it into the Access Module for reasons I won't go into.

The problem I have is that after the Word Document is opened I want to have a MsgBox pop up from the Access Database to remind users to close the Word Document. But because the Word Document is the active document you can't see the MsgBox that pops up in the Access Database. Is there a way to set the database to visible or to be the active window?

 

[Frink]

Hallo,

I think you should be able to use AppActivate. It's there in Access '97. It activates an application with a given title, so it's not completely foolproof, but should work most of the time.

Not tried it activating Access itself before though.

Another alternative would be to open Word in the background or minimised.

- Frink

 

[madhouse]

Thanks, the AppActivate worked fine.