473,766 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MapPoint and Access - How to automate?

I have an address form in Access 2003 that contains the usual address
information such as AddressLine1, AddressLine2, City, State, etc... I would
like to put a button on this form that feeds the address info into MapPoint,
along with a fixed return address, and gets driving directions - or at least
get a map of the destination.

I have the MapPoint software, but have not used it. Will MapPoint provide
driving directions, or just a map? Anyone have some canned VBA code they
would care to share?

Thanks!
Nov 12 '05 #1
4 8387
On Thu, 08 Jan 2004 01:40:15 GMT, "deko" <dj****@hotmail .com> wrote:

You'll need to read up on Automation. Using it, you can utilize
MapPoint's object model and do everything an interactive user can do.
You'll find the Find method, which you can feed a more-or-less
complete address, and it will find one or more hits.
Having MapPoint calculate a route between two points also is just a
dozen or so lines of code. You'll probably find some sample code
included with a full installation of MapPoint, or on microsoft.com.

I once wrote an add-in for Act! contact manager that did just that. A
bit more code than I'm willing to share here, but really not all that
difficult.

-Tom.

I have an address form in Access 2003 that contains the usual address
information such as AddressLine1, AddressLine2, City, State, etc... I would
like to put a button on this form that feeds the address info into MapPoint,
along with a fixed return address, and gets driving directions - or at least
get a map of the destination.

I have the MapPoint software, but have not used it. Will MapPoint provide
driving directions, or just a map? Anyone have some canned VBA code they
would care to share?

Thanks!


Nov 12 '05 #2
Hi,

the various samples, provided at www.mp2kmag.com will help you here, but you
need a small bit of VBA knowledge, to do that. Also
http://msdn.microsoft.com/mappoint
contains interesting samples

Mappoint contains also a routing part, not only streets.

I think, the right forum for your question is microsoft.publi c.mappoint

--
mfg

Klaus Oberdalhoff [MVP]

deko wrote:
I have an address form in Access 2003 that contains the usual address
information such as AddressLine1, AddressLine2, City, State, etc...
I would like to put a button on this form that feeds the address info
into MapPoint, along with a fixed return address, and gets driving
directions - or at least get a map of the destination.

I have the MapPoint software, but have not used it. Will MapPoint
provide driving directions, or just a map? Anyone have some canned
VBA code they would care to share?

Thanks!


Nov 12 '05 #3
thanks for the tip. I will check it out.

"Klaus Oberdalhoff [MVP]" <ko**@gmx.de> wrote in message
news:bt******** *****@news.t-online.com...
Hi,

the various samples, provided at www.mp2kmag.com will help you here, but you need a small bit of VBA knowledge, to do that. Also
http://msdn.microsoft.com/mappoint
contains interesting samples

Mappoint contains also a routing part, not only streets.

I think, the right forum for your question is microsoft.publi c.mappoint

--
mfg

Klaus Oberdalhoff [MVP]

deko wrote:
I have an address form in Access 2003 that contains the usual address
information such as AddressLine1, AddressLine2, City, State, etc...
I would like to put a button on this form that feeds the address info
into MapPoint, along with a fixed return address, and gets driving
directions - or at least get a map of the destination.

I have the MapPoint software, but have not used it. Will MapPoint
provide driving directions, or just a map? Anyone have some canned
VBA code they would care to share?

Thanks!

Nov 12 '05 #4
I'm fairly confident of my understanding of Automation, but I have not
installed MapPoint yet - so that might be a good place to start...

Thanks for the reply!
"Tom van Stiphout" <to*****@no.spa m.cox.net> wrote in message
news:l9******** *************** *********@4ax.c om...
On Thu, 08 Jan 2004 01:40:15 GMT, "deko" <dj****@hotmail .com> wrote:

You'll need to read up on Automation. Using it, you can utilize
MapPoint's object model and do everything an interactive user can do.
You'll find the Find method, which you can feed a more-or-less
complete address, and it will find one or more hits.
Having MapPoint calculate a route between two points also is just a
dozen or so lines of code. You'll probably find some sample code
included with a full installation of MapPoint, or on microsoft.com.

I once wrote an add-in for Act! contact manager that did just that. A
bit more code than I'm willing to share here, but really not all that
difficult.

-Tom.

I have an address form in Access 2003 that contains the usual address
information such as AddressLine1, AddressLine2, City, State, etc... I wouldlike to put a button on this form that feeds the address info into MapPoint,along with a fixed return address, and gets driving directions - or at leastget a map of the destination.

I have the MapPoint software, but have not used it. Will MapPoint providedriving directions, or just a map? Anyone have some canned VBA code they
would care to share?

Thanks!

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1226
by: Bob Mortensen | last post by:
I am working with large numbers of data sets and I need to automate the process of creating drive time zone excell spredsheet or Access outputs. Here is my challenge....I have two push pin sets, one a set of company locations say 100 loctions and another set of pushpins for physician locations perhaps up to 25,000 locations in the entire state of California. In addition, for each of these physician locations there may be up to 20 or more...
1
1400
by: Bob Mortensen | last post by:
I am working with large numbers of data sets and I need to automate the process of creating drive time zone excell spredsheet or Access outputs. Here is my challenge....I have two push pin sets, one a set of company locations say 100 loctions and another set of pushpins for physician locations perhaps up to 25,000 locations in the entire state of California. In addition, for each of these physician locations there may be up to 20 or more...
2
2525
by: trapeze.jsg | last post by:
Hi. Is there anybody who have tried to use python to access Microsofts MapPoint soap services? I am trying hard but I have run into a big thick wall called md5 digest authentication. The MapPoint service uses rfc2617 to authenticate the user. I have a working account for this which works using C# dotnet and Borland Delphi 6.0. When I try to authenticate using python it fail. Here is what I do to provoke the rfc2617 challenge:
3
2351
by: tom | last post by:
Hi All, We have an Access XP application in which we utilize automation to control MS MapPoint 2004. It works pretty well, for the most part. Now, we would really like to use the MapPoint Control in our application to give our users active maps to interact with, but the control's help page explicitly states that it is NOT for use in Access: (With MapPoint 2004, the MapPoint Control is supported only in
2
2143
by: Gil | last post by:
I am automating mappoint in access and was wondering what is a better way to have the mappoint map running all the time: 1.call it as a seperate application OR 2. as an activex control within a form in access. Both will give me the same data results, but I am more concerned about performance. Any ideas? Thanks,
1
2151
by: Gil | last post by:
hello, im automating mappoint through access to get mileage between two address fields. when ever i call the function it makes mappoint the focus, and i have to reclick the access screen to regain access forms focus. how can i get access focus via vba and without having to click the form? i tried using docmd.selectobject acform, "myform" and me.setfocus . it looks like it works by highlighting a text box however the mappoint is still...
0
1057
by: Eric Frost | last post by:
New article on using Python scripting to automate map-making with example code, see screenshots. Using Python to Control MapPoint, Part 2 «Second of a two-part article by Richard Marsden on scripting MapPoint using Python.» http://www.mp2kmag.com/a134--python.winwaed.automation.mappoint.html Eric Frost http://www.mp2kmag.com - The Magazine for MapPoint
0
1135
by: ssaraslm | last post by:
In web application, can i use microsoft mappoint 2006 in asp.net 2005/c# ? mappoint 2006, asp.net 2005/c# ...i added mappoint control 13.0 It added only windows toolbar.. not web toolbar but i'm delevepoing only web application. so i can't access that control in asp.net 2005.. so how can i access with asp.net pls give some ideas...
0
1798
by: Arcturus | last post by:
I am new to Access Monster 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. ...
0
9404
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10168
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10008
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9837
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8833
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7381
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5279
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2806
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.