By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,399 Members | 1,319 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,399 IT Pros & Developers. It's quick & easy.

mappoint looses forms focus

P: n/a
Gil
hello,
im automating mappoint through access to get mileage between two
address fields. when ever i call the function it makes mappoint the
focus, and i have to reclick the access screen to regain access forms
focus. how can i get access focus via vba and without having to click
the form?

i tried using docmd.selectobject acform, "myform" and me.setfocus . it
looks like it works by highlighting a text box however the mappoint is
still under focus and doesnt set the focus back to the form. if i hit
alt+f4 it will ask me if i want to close mappoint. thats how you can
tell for sure mappoint is still under focus.
any ideas?
if the mappoint app was hidden im sure it would solve this problem but
i do not want the mappoint app hidden. i want it open , but just
minimized, so the user can have the option to restore mappoint and play
around with it and than minimize it again.

any ideas?
thanks

Dec 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I am not sure what version of Access you are using, or the specifics of your
code, however, you may want to look at the AppActivate VBA function. In
Access 2003 for example, each form is given its own window. So you could
activate the actual form directly. For example:

AppActivate "MyForm", False

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Gil" <gi*******@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
hello,
im automating mappoint through access to get mileage between two
address fields. when ever i call the function it makes mappoint the
focus, and i have to reclick the access screen to regain access forms
focus. how can i get access focus via vba and without having to click
the form?

i tried using docmd.selectobject acform, "myform" and me.setfocus . it
looks like it works by highlighting a text box however the mappoint is
still under focus and doesnt set the focus back to the form. if i hit
alt+f4 it will ask me if i want to close mappoint. thats how you can
tell for sure mappoint is still under focus.
any ideas?
if the mappoint app was hidden im sure it would solve this problem but
i do not want the mappoint app hidden. i want it open , but just
minimized, so the user can have the option to restore mappoint and play
around with it and than minimize it again.

any ideas?
thanks
Dec 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.