Setting Focus on a different window? 1

[menstroy]

I have an acccess form that calls up lotus notes and then starts to write an email. However when the code is done it does not set the focus to the lotus notes window, I would like to the lotus notes window to come to the front screen.

 

[rdodge]

Use the AppActivate Statement

Example:

AppActivate "Access"

Please note, the title doesn't have to be the full name of the window, but for what portion of it is given, it must match to the beginning text of the window caption.

Example, My Lotus Notes shows the caption of:

Ronald Dodge - Inbox - Lotus Notes Desktop

Therefore, the AppActivate can't have:

AppActivate "Lotus Notes"

But it can have:

AppActivate "Ronald Dodge - "

and Lotus notes will become the active window provided there is no other window that starts off with that same title, cause then the AppActivate will just choose which ever one is first.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000