Change To Different Active Window 1

[rgbanse]

Is there VBA code that will change form current active window to another active window.
thx
RGB

 

[KyleS]

Are you look to change the active window within Access, or within Windows - ie, change forms or set focus on a different program like Excel? Kyle :

 

[rgbanse]

Kyle,
I would like to change from within Access to another external Program.
thx
RGB

 

[KyleS]

RGB,
I know how to do this with most Microsoft products, Look up "GetObject" in help, when you use:

Dim obj as Excel.Application
Set obj = GetObject(,"Excel.Application&quot
set obj = nothing

this will either bring up Excel or if Excel is already running, bring it to the front (activate)

I haven't tried it with other applications. I know you can always "Shell" something as well, but then you'll need to know the root path of the parent app (eg "C:\Program FIles\Adobe\Acrobat\Reader\AcrRdr32.exe&quot

Kyle :

 

[rgbanse]

Kyle,
thx for the help - I'm headed in the right direction now.
RGB