Vicki Pugh
Nov 17th, 1999, 08:12 PM
I wonder if anybody can help me (please!).
Maybe I shoulg give you some background to my problem...
I am using MS Access to develop a DB for a local company. When the user gets to the address field on the form, I want an Addressing package to get the focus and then, after sending the required address to Access, to give the focus back to Access.
I have 2 ideas for solutions to this problem, but am unsure about some aspects of each.
1) The addressing package has an option to minimize after send. This is great, but then I can't maximize it again. I know that the Shell function allows you to select the style of window that you want - is there a similar option available with the AppActivate statememt?
2) I can use the AppActivate statement to give the focus to the addressing package. The only problem is, the package is designed to 'come out on top' so to speak. I have tried to use VB to give the focus back to the addressing package (ie by using AppActivate to give the focus to the addressing package, and then using AppActivate again to give the focus back to Access). This does work briefly (the focus does go to Access, but because the addressing package always has the last word after sending the address, it goes back again).
I was thinking that if I could put a delay into the AppActivate statement to enable the addressing program to finish executing its commands, then the focus should (by my way of thinking) go back to Access. Is there any way of doing this?
In brief, what I want to do is either:
-add a delay in a VB module to be performed between 2 AppActivate statements.
-maximize a minimised application window.
Please help!
Thank you for taking your time to read this.
Kind Regards,
-Vicki Pugh
Maybe I shoulg give you some background to my problem...
I am using MS Access to develop a DB for a local company. When the user gets to the address field on the form, I want an Addressing package to get the focus and then, after sending the required address to Access, to give the focus back to Access.
I have 2 ideas for solutions to this problem, but am unsure about some aspects of each.
1) The addressing package has an option to minimize after send. This is great, but then I can't maximize it again. I know that the Shell function allows you to select the style of window that you want - is there a similar option available with the AppActivate statememt?
2) I can use the AppActivate statement to give the focus to the addressing package. The only problem is, the package is designed to 'come out on top' so to speak. I have tried to use VB to give the focus back to the addressing package (ie by using AppActivate to give the focus to the addressing package, and then using AppActivate again to give the focus back to Access). This does work briefly (the focus does go to Access, but because the addressing package always has the last word after sending the address, it goes back again).
I was thinking that if I could put a delay into the AppActivate statement to enable the addressing program to finish executing its commands, then the focus should (by my way of thinking) go back to Access. Is there any way of doing this?
In brief, what I want to do is either:
-add a delay in a VB module to be performed between 2 AppActivate statements.
-maximize a minimised application window.
Please help!
Thank you for taking your time to read this.
Kind Regards,
-Vicki Pugh