Close & Return to Access 2000 does not Return

[JimAllen]

Using OLE.ACTIVATE to open a Word document in a module opens the document in Word. After clicking close and return to access, document closes, however, focus is not on Access window. Instead, Access button in task bar blinks.

How can I get focus back to Access?

I think this has something to do with the form open when activating Word. The form has a subform.

 

[Darrylles]

Hi,

Haven't used this, but I think that you should be looking along the lines of Maximised and Minimised, ie, the application IS current (it's blinking on the taskbar to inform you of this), but it needs to be maximised in code.

Hope this points you.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk