Displaying a form in another Application

[Robert Taylor]

I am designing an application in another program and using
createobject to connect to an access database. What I want
to do is make it so that when you run this program a form
pops up for you to enter data, which goes into an access
database.

Everything works the way I want as far as opening the
database, but I have to click on the taskbar on the bottom
to switch the focus from the original application to the
database form and back again.

Does anyone know a good way through OLE automation to make
the program shift the focus to the newly opened database
form and back again so that to the end-user the
application appears to be creating the form?

Thank you.
Robert

 

[TC]

What language is the other program written in? Does it have an AppActivate
method (or similar)?

HTH,
TC

 

[Robert Taylor]

It is written in a version of basic similiar to an older
version of visual basic. It does have AppActivate, but
while it gives the database the focus it does not bring it
to be the top window, so all I end up with is a flashing
button on the taskbar.

Robert

 

[TC]

Robert, do an advanced google groups search for the thread entitled:

Begin Access to front of all applications

There is pertinent information in that thread. Do type "Begin" (although
they obviously meant "Bring").

HTH,
TC