MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Using MP ActiveX Control in Access/Foxpro etc

This is a discussion on Using MP ActiveX Control in Access/Foxpro etc within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I got the trial version of MP 2002 a couple of days ago and have played with it a little ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-21-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Using MP ActiveX Control in Access/Foxpro etc

I got the trial version of MP 2002 a couple of days ago and have played with it a little bit, so I may be asking something pretty basic.

I searched the help file for a couple of hours for some way to access the latitude and longitude of a location object with no results. I hacked together a solution using distance functions that could have been made to work better, but I chose to search the Microsoft web site for a solution with no results. I came across mp2mag and found several postings to the effect that MP was specifically designed to prevent the user from obtaining this info, but found several work-arounds on mp2mag that work pretty well. (I like the one by Gilles Kohl, but it returns lat lon with precision to only seven or eight significant digits. I may have a refinement that will increase this precision.)

I also found that the MP2002 ActiveX control will not work in MS Access. If you try, it will give you an error message that there is no object in the control. It would make life simpler for me if MP Control could work in Access, but it appears that the control was specifically designed not to work in anything other than VB 6.

I have figured out a rather obvious work-around that lets the control work in MS Access. I suspect that this workaround will allow it to work in FoxPro, Word, Excel, and other container applications that can use other ActiveX controls (I have only tried this in MS Access so far.) I think it can even be made to be data aware so that as you move from record to record in your Access database, the control highlights associated locations or objects.

In searching for an answer to my question I came across some discussion about how the product license will not allow you to use this product to track more than a certain number of vehicles in near real time. I thought this restriction was a little goofy, but then the reasoning for excluding a lat/lon function was goofy as well.

The work-around for using MP Control in Access is so obvious that I cannot believe that Microsoft did not think of it. They had to have designed the control specifically to not work in other container applications.

My question is this:

Given how easy it is to use the MPActiveX Control in other applications despite the design limitation and given the other goofy and screwball licensing issues such as lat/lon function and fleet limitations, is there any sort of languate in the product license that would prohibit or inhibit the use of this control in a container application other than VB6 or VBnet.

Please e-mail any answer, comments, or questions to KTrimble@aol.com. Please put MAPPOINT ACTIVEX CONTAINER in capital letters in the subject field so that I don't accidentally delete it as spam.

Thank you very much
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
access or foxpro, activex, control


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Access some hidden features in MapPoint2002 ActiveX control baal_2000 MapPoint 2006/2009 Discussion 43 08-29-2006 11:46 AM
MS Access Mappoint ActiveX Anonymous MapPoint 2006/2009 Discussion 2 05-21-2005 06:31 PM
Re: Keyboard control in mappoint activex control djcapslock MapPoint 2006/2009 Discussion 1 03-10-2005 11:16 AM
MS Access and Mappoint ActiveX Control Anonymous MapPoint 2006/2009 Discussion 3 06-26-2004 02:29 PM
ActiveX Control Anonymous MapPoint 2006/2009 Discussion 3 09-04-2002 06:44 PM


All times are GMT -5. The time now is 12:08 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54