Shell (sharing window focus on Access and non-Access application like telnet)

[Pete]

Is there any possiblity of writing an Access or Visual Basic
application that provides a method of sharing the window focus between
Access and the Shell application? i.e.
Shell("c:\windows\calculator.exe", vbNormalNoFocus) In other words
are there Win2000/XP api's that would allow you to control the
functionality of the calculator. I'm just using the calculator
application as an example I am actually trying to control a main frame
app with Access using the Host Explorer telnet client. The problem is
I can provide the functionality in Access but I can't mount the Access
database directly to the telnet window. Which means I have to switch
back and forth between the two windows. I would rather be able to
open up the telnet window within Access like a form. This way when I
minimize Access I also minimize the other telnet application too. I
am sure there is a way. The question is has it been done before and
is it worth the time to implement and write pages of code. Any help
is appreciated.

[Tony Toews]

my*****@netzero.net (Pete) wrote:

I would rather be able to
open up the telnet window within Access like a form.

At least one control vendor has a Telnet control. Which you could install on an
Access form. See http://www.granite.ab.ca/access/email/thirdparty.htm for a list of
such vendors.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Stephen Lebans]

You could try using the SetParent API to set the Telnet Window as a
Child of the Access Form or App window. I have no idea whether it will
work or any possible negative interactions but it would not hurt to
try!<grin>
:-)

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Pete" <my*****@netzero.net> wrote in message
news:a3**************************@posting.google.c om...

Is there any possiblity of writing an Access or Visual Basic
application that provides a method of sharing the window focus between
Access and the Shell application? i.e.
Shell("c:\windows\calculator.exe", vbNormalNoFocus) In other words
are there Win2000/XP api's that would allow you to control the
functionality of the calculator. I'm just using the calculator
application as an example I am actually trying to control a main frame
app with Access using the Host Explorer telnet client. The problem is
I can provide the functionality in Access but I can't mount the Access
database directly to the telnet window. Which means I have to switch
back and forth between the two windows. I would rather be able to
open up the telnet window within Access like a form. This way when I
minimize Access I also minimize the other telnet application too. I
am sure there is a way. The question is has it been done before and
is it worth the time to implement and write pages of code. Any help
is appreciated.

[Terry Kreft]

I've done it with VB forms, but most Telnet apps run in a console window so
I don't know ow this would work. I'm fairly certain the Setparent API would
work but it's how the windows messages are processd after that I'm not too
sure about.

Probably be ok.

--
Terry Kreft
MVP Microsoft Access
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:M5*********************@ursa-nb00s0.nbnet.nb.ca...

You could try using the SetParent API to set the Telnet Window as a
Child of the Access Form or App window. I have no idea whether it will
work or any possible negative interactions but it would not hurt to
try!<grin>
:-)

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Pete" <my*****@netzero.net> wrote in message
news:a3**************************@posting.google.c om...

Is there any possiblity of writing an Access or Visual Basic
application that provides a method of sharing the window focus between
Access and the Shell application? i.e.
Shell("c:\windows\calculator.exe", vbNormalNoFocus) In other words
are there Win2000/XP api's that would allow you to control the
functionality of the calculator. I'm just using the calculator
application as an example I am actually trying to control a main frame
app with Access using the Host Explorer telnet client. The problem is
I can provide the functionality in Access but I can't mount the Access
database directly to the telnet window. Which means I have to switch
back and forth between the two windows. I would rather be able to
open up the telnet window within Access like a form. This way when I
minimize Access I also minimize the other telnet application too. I
am sure there is a way. The question is has it been done before and
is it worth the time to implement and write pages of code. Any help
is appreciated.