Closing Map Point from Access

[Mark L via AccessMonster.com]

I have an Access database that links job addresses to MapPoint. I create an
incident of MapPoint within an Access procedure. When I finish with the
MapPoint app I close it; however, I still have MapPoint.exe running in the
Task Manager. How can I purge the MapPoint.exe when I close the program?

 

[Douglas J Steele]

How are you closing it (and, for that matter, how as you instantiating it)?

 

[Mark L via AccessMonster.com]

I create it with
Set oApp = CreateObject("Mappoint.Application")
I close the MapPoint program the normal way. If I set oApp = nothing at the
end of the procedure, Map Point closes before we can do anything. Where
should I set oApp = nothing or how should i halt the procedure until I close
Map Point?

 

[Douglas J Steele]

Sounds as though you're simply opening MapPoint, as opposed to automating
it. In other words, your Access application isn't actually interacting with
MapPoint: the user is. Is that correct?

You could try shelling to MapPoint, using the code that's at
http://www.mvps.org/access/api/api0004.htm at "The Access Web"

 

[Mark L via AccessMonster.com]

I do pass latitude and longitude information for equipment locations and
route planning. Can I work it into the Shell wait procedure and just stop
the access procedure unit the user closes map point?

Sounds as though you're simply opening MapPoint, as opposed to automating
it. In other words, your Access application isn't actually interacting with
MapPoint: the user is. Is that correct?

You could try shelling to MapPoint, using the code that's at
http://www.mvps.org/access/api/api0004.htm at "The Access Web"

I create it with
Set oApp = CreateObject("Mappoint.Application")

[quoted text clipped - 9 lines]

 

[Douglas J Steele]

Not sure (which is why I offered such a limited solution! <g>)

On the other hand, if you've opened MapPoint through the Shell command, you
should be able to refer to that instance using GetObject.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I do pass latitude and longitude information for equipment locations and
route planning. Can I work it into the Shell wait procedure and just stop
the access procedure unit the user closes map point?

Sounds as though you're simply opening MapPoint, as opposed to automating
it. In other words, your Access application isn't actually interacting with
MapPoint: the user is. Is that correct?

You could try shelling to MapPoint, using the code that's at
http://www.mvps.org/access/api/api0004.htm at "The Access Web"

I create it with
Set oApp = CreateObject("Mappoint.Application")

[quoted text clipped - 9 lines]

MapPoint app I close it; however, I still have MapPoint.exe running in the
Task Manager. How can I purge the MapPoint.exe when I close the

program?

 

[Mark L via AccessMonster.com]

Thank you for your help.

Not sure (which is why I offered such a limited solution! <g>)

On the other hand, if you've opened MapPoint through the Shell command, you
should be able to refer to that instance using GetObject.

I do pass latitude and longitude information for equipment locations and
route planning. Can I work it into the Shell wait procedure and just stop

[quoted text clipped - 12 lines]

 

[David C. Holley]

Anytime I'm controling another app from Access, I also execute a .QUIT
statement and set the object variable to nothing as in

appOutlook.Quit
Set appOutlook = Nothing

I've seen that setting the object variable to Nothing typically shuts
down the app, however I tend to execute the QUIT to *EXPLICITY* shut it
down.