Activating/Maximizing Access Db Window 1

[newguy86]

Here is my situation. I am using Access 2003 for a project that I am working on, and what happens is that I created a macro based in Access to run out to another program, input the data in its respective locations and then come back to Access to complete the work. The issue that I am having is that I have record validation code built in to this macro so that if the record that is loading has already been loaded a message box appears and asks you to check the record for accuracy. Then the window for this outside program is maximized so you can see the information. The problem comes when the macro finishes with this outside program the next message box appears and I am unable to tab to my selection. What I am forced to do is select the database from my taskbar so that I can give the message box a response. What I want to do is activate the window right before the message box appears so that I can smoothly give the macro a response and everything keeps running. Now I have tried everything that I can find to do this and nothing seems to be working. Below is what I think the code should be but this just does nothing.

<Code>
Application.Forms![TA Apps].SetFocus
strMsgBox = MsgBox("Do you want to load TA App into Access?", vbYesNoCancel)
</Code>


Travis

http://www.enterprise.com

 

[PHV]

You may consider AppActivate

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[newguy86]

Thank you. That worked perfectly. Here is the code that I used.

<code>
AppActivate "Microsoft Access"
</code>

Travis

http://www.enterprise.com