MapPoint and Access - How to automate?

[deko]

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!

[Tom van Stiphout]

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!

[Klaus Oberdalhoff [MVP]]

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.public.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!

[deko]

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.public.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!

[deko]

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.spam.cox.net> wrote in message
news:l9********************************@4ax.com...

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!