Outlook Opens behind form

[sdel_nevo]

Hi All



I have a small problem that i can't seem to figure out.

i have a form that opens Maximized that has a button on , that when clicked opens outlook with the required e-mail address inserted.

the problem i have is that outlook opens behind the maximized form, to see outlook my users have to press alt & tab,

how can i get outlook to open up always on top of the access?

any pointers would be great

Many thanks

Steve

[Dal Jeanis]

1) Check whether the form is set to be "Modal".

2) Here's a page on how to use VBA to bring an external application window to the foreground.
http://www.everythingaccess.com/tuto...the-foreground

3) You might be able to acheive the same thing in a simpler way by having the Access application minimize itself instead, if that would meet your needs.

[sdel_nevo]

Hi Dal

thanks for the link, not sure where i would put this code? is it in a module or on the buttons on-click action?

outlook opens a window called "Untitled-message(HTML)"

in just really starting with VBA and this is abit daunting to get my head around

i have checked the form, its set as
Pop up = yes
modal = no

Border style = thin

form has on open event that sets it maximized "DoCmd.Maximize"

Steve

[Dal Jeanis]

Yeah, that code is not pretty. It's VBA, but it doesn't look like Access VBA to me. It would go in a separate module, and when you got it working you'd call the public function FnSetForegroundWindow(strWindowTitle As String) to find and bring to the foreground the window you were looking for.

UGLY ALTERNATIVE 1:

This line of code will drop access out from in front of Outlook, but there has to be a more elegant solution than making the person re-maximize Access after every email.

DoCmd.RunCommand acCmdAppMinimize

UGLY ALTERNATIVE 2:

Worst case scenario, you can use SendKeys to send Access the alt-tab command. (Ducks head to avoid incoming objects).
http://msdn.microsoft.com/en-us/libr.../ff192656.aspx for the macro action or
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx for the VBA method.

Sendkeys is considered very squirrelly.

OTHER POSSIBLE ALTERNATIVES:

Here's some other possible ways: http://www.utteraccess.com/forum/Ope...-t1922737.html

QUESTIONS:

What is the actual code that you're using to open Outlook in the first place? Is there a line that looks like

(something).Display

in it somewhere?

By the way, you should be able to set the message title to something else.

[sdel_nevo]

hi Dal

well i have this working now, i changed the form from being opened "maximized" to a popup thats the same size as the screen, this way the toolbar is visible and outlook now opens as it should.

this gives me the same result, I should have done this to start with lol, as i would have saved afew hours trying to resolve this issue

anyway thanks for the reply

many thanks

Steve

[Dal Jeanis]

Any port in a storm. Good job finding a solution that will work for your user!

Please mark the thread "solved". Top of page, under "thread tools".