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

setfocus to access application

P: n/a
Gil
can you set focus to the current access application through vba?
lets say i tell access to open another application and that new
application gains the focus and causes access to loose the focus. can
access reset the focus back to its current access application after
loosing its focus?
docmd.select object or me.setfocus doesnt seem to work. what it does it
set the highlet on a textbox within the form but the form is still not
selected.
any ideas?
thanks!

Dec 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Gil wrote:
can you set focus to the current access application through vba?
lets say i tell access to open another application and that new
application gains the focus and causes access to loose the focus. can
access reset the focus back to its current access application after
loosing its focus?
docmd.select object or me.setfocus doesnt seem to work. what it does it
set the highlet on a textbox within the form but the form is still not
selected.
any ideas?
thanks!

I might check out http://www.mvps.org/access and scan through the API's.
I'm not sure why you'd want to open an app and keep the focus there
since one can hit the access button on the start bar and if Access is
minimized you might not see the other app. At the Access web site
listed there is a method to open files and you can tell it to open
maximized or minimized.
Dec 21 '05 #2

P: n/a
Gil
thanks i will check it out.
the reason i want to this is because i call mappoint to fetch the
milelage between two address and i want it to happen while still in
access, even though mappoint must be open

Dec 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.