I am new to MP2K forums.
I developed an Access form which employees add their daily route. The form contains a sub-form in data-sheet (tabular) view where users add address and other information each day. (All data is stored in a database (.mdb file) on our server.) The form also contains a calendar control where one can call up routes from previous days. The sub-form is based on a query which ties to the calendar control. I want to place a button on the form which automatically launches a separate instance of MapPoint and does the following:
1. MapPoint imports addresses from the abovementioned sub-form. I would like to use the query that the form uses but am willing to take roundabout methods like exporting the day’s addresses to a temporary file.
2. Automatically places the list of addresses in MapPoint’s route planner after searching within a prescribed territory based on Zip Codes. This is to avoid searching all of North America before mapping each waypoint. (The start and end waypoints will always be the same since that is our fleet location.)
3. Finally, MapPoint automatically optimizes the route and get directions.
While I don’t expect someone to provide the VB code for all this, I would like to know if this is possible or if I’m just wasting my time. I am somewhat versed in Access but am a novice at VB. A search of the forums has, so far, provided little help for this specific application. Can anyone steer me toward some good resources? I realize this may take some time to finally get it to work.
Thanks in advance.