MapForums

Is there a way to disable the Close button when opening MapPoint via VB/VBA so that the user cannot close MapPoint while my application is waiting for the user to approve the optimized order, etc.?

Basically, I do this in VBA:

1. Instantiate MP as an app
2. Create a new route
3. Populate the route with Waypoints
4. Allow the user to modify the order of Waypoints.
5. In my app, ask the user to approve/discard the new stop order.
6. If approved, update records in my DB to match the new stop order.
7. Close MP (via VBA).

The problem comes when the user closes MP manually anywhere between #3 and #7, and then I have to trap a variety of errors that can occur as a result (e.g. MP is no longer open when my app references the ListPosition property of a Waypoint).

What if you use VB and put the MapPoint control on a VB form?

That way they could not close MapPoint except by closing your whole application... (or ctrl-alt-del / kill). However, I think your application could disable the close button..

Eric

__________________

That was my first attempt. I suppose I should have been more accurate. This is actually VBA in Access, not VB itself, and here is a snippet from the MP2009 help file:

"In MapPoint 2009, the MapPoint Control is supported only in Visual Basic 6.0. Consequently, the MapPoint Control is not supported in Visual Basic for Applications"

Being stubborn, I tried anyway and found that I can add the reference but am unablel to insert it onto a form in Access, so I am stuck with the MP Object Library. This is my first attempt at integrating MP with Access, so I am guessing that the Map Control may have been available with earlier version of MapPoint.

Something that would work just as well would be to capture the processID of MapPoint when it is instantiated in VBA. Then I could check to see if that process is still active before running any code that assumes it is running and present the user with a better message than the system error messages about objects not found, etc.

There are some examples of using MapPoint in an Access form at --

MapPoint Articles - MP2K Magazine

Search for "access" on this page, articles with Access examples should have Access in the title.

It's been a while, but in particular, take a look at John Washenberger's article and my P.F. Chang's article.

hope this helps,
Eric

__________________