Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

vbMinimizedNoFocus

Status
Not open for further replies.

NSNewey

Programmer
Jun 29, 2005
125
GB
I have a form which uses shell to open another application and then OLE to get some info from it. This is all working great.

The problem is that no matter what window stle argument I pass (vbMinimizedNoFocus etc) the application takes the focus. I have tries vbHide which works but keeps the application open and because it is hidden, I can't then close it later.

Is there a way to show a hidden application after it has opened?

If not, how can I return the focus to Access after the app has opened. I have tried me.setFocus but it still does not return the focus to access.
 
and then OLE to get some info from it
Why not using OLE too to open it, i.e. CreateObject instead of Shell and GetObject ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top