Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Can a MapPoint map be generated in Access query with multiple poin
7 views
Skip to first unread message
Gary
Aug 27, 2010, 11:18:04 AM8/27/10
to
just started a contract where I need to modify some MS Access 2007 programs.
One program takes a (real estate) company and generates a list (via a query)
of their properties in the form of addresses. An employee then takes this
list (from 1 to 100 properties) and creates a map in MapPoint, saves it as an
image, and then pastes it onto a PDF form that contains the list of addresses
(from the query). So what we get is a list of properties and then a map with
all the map points from this list. This is now being done manually, and
takes a lot of time. Is there a way that this could be automated: run a form
in Access that would run a query and list the addresses, then create a map
and show the map, all on the same page, automatically? Has anyone done this?
Thanks in advance- Gary
One program takes a (real estate) company and generates a list (via a query)
of their properties in the form of addresses. An employee then takes this
list (from 1 to 100 properties) and creates a map in MapPoint, saves it as an
image, and then pastes it onto a PDF form that contains the list of addresses
(from the query). So what we get is a list of properties and then a map with
all the map points from this list. This is now being done manually, and
takes a lot of time. Is there a way that this could be automated: run a form
in Access that would run a query and list the addresses, then create a map
and show the map, all on the same page, automatically? Has anyone done this?
Thanks in advance- Gary
DickGrier
Aug 30, 2010, 12:22:11 PM8/30/10
to
Go to www.mp2kmag.com and signup for the forums. I think that you may find
an Access (VBA) example to get you started.
an Access (VBA) example to get you started.
Dick
--
Richard Grier, Consultant, Hard & Software 12962 West Louisiana Avenue
Lakewood, CO 80228 303-986-2179 (voice) Homepage: www.hardandsoftware.net
Author of Visual Basic Programmer's Guide to Serial Communications, 4th
Edition ISBN 1-890422-28-2 (391 pages) published July 2004, Revised July
2006.
0 new messages