Home Locator Sample Application

John Washenberger writes, "In the spirit of the MDB 'Circus' Contest, the application I have submitted could be considered a 'three-ring extravaganza'."

Read the full article: http://www.mp2kmag.com/articles.asp?ArticleID=74

A person reviewing the article sent me an email indicating that a parameter was missing in the FindAddressResults call in subroutine MapSelectedProperties found behind frmMain. The call did not include a place holder for the third parameter. The line should be changed from:


Set objLoc = objMap.FindAddressResults(rstHome!strStreet, rstHome!strCity, rstHome!strState, rstHome!strPostalCode)(1)

to:

Set objLoc = objMap.FindAddressResults(rstHome!strStreet, rstHome!strCity, , rstHome!strState, rstHome!strPostalCode)(1)

Thanks,

John

How do I get to look at your code?

I can run the sample but how do I get it to let me look at the code?

:?

Hold down the shift key when opening the database..

This article has enlightented us on usage of the MapPoint Object and controlling the object directly instead of using the OCX Control. We have been having difficulty in what we think is timing issues between the Mappont and our Access code being that the "Object becomes unavailable" even after checking the ReadyState of the control. So we want to investigate automating Mappoint directly and it appears this code sample does not have to check the readystate to run sucessfully.

The question that comes up is when using the Object this way, would the events available through the Mappoint Control OCX be lost? (e.x. SelectionChange event).

We want to be able to use the selected object (i.e. free-form shape or push-pin) that the user selected and process our Access data when the user clicks on a button on the parent form. We now use the SelectionChange event to keep track of the object selected. We can not see how they might be available yet.

Is there another way to determine the selected object? Do we have to go back to school on Access, Windows API and Object programming?