Display ID number of store as pushpin

I want to map locations of our stores and have displayed the store's ID 
number within a colored circle. Then I can have a separate index showing the 
store's number and the store's name, etc on the side.  

In my store data base we have the number associated with address and lat/lon 
(an other data). How do I get this type of data (the store's ID number) to 
display instead of a pushpins, etc.  When I try to display the store number 
as mapped data based on lat/lon I can only display a bar chart.  Any add-ons 
to help with this? 

"msi" <msi@discussions.microsoft.com> wrote in message
news:51BA0FFA-CD4B-4FDC-91BD-0109D097FF3D@microsoft.com...

>I want to map locations of our stores and have displayed the store's ID
> number within a colored circle. Then I can have a separate index showing 
> the
> store's number and the store's name, etc on the side.
>
> In my store data base we have the number associated with address and 
> lat/lon
> (an other data). How do I get this type of data (the store's ID number) to
> display instead of a pushpins, etc.  When I try to display the store 
> number
> as mapped data based on lat/lon I can only display a bar chart.  Any 
> add-ons
> to help with this?
>
> Thanks

Hi msi,

I looked around and didn't find an addin for that purpose.

This does require both programming and custom icons.
I have stuff here that will do the job (this is routine for me),
but I haven't actually made an addin for it.

I'm available for freelance work.

-- 
Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com 

I just wrote a VB6 program for an ambulance company that uses custom icons 
and labels each pushpin as a vehicle number.  Your application should not be 
that much different.  One might even be able to do this via VBA in Access as 
well.  If need be, the app I wrote could also be upgraded to VB.Net.   Give 
me a ring if you want help.

Trent Anderson
tanderson78@hotmail.com


"msi" wrote:

> I want to map locations of our stores and have displayed the store's ID 
> number within a colored circle. Then I can have a separate index showing
the 
> store's number and the store's name, etc on the side.  
> 
> In my store data base we have the number associated with address and
lat/lon 
> (an other data). How do I get this type of data (the store's ID number) to

> display instead of a pushpins, etc.  When I try to display the store number

> as mapped data based on lat/lon I can only display a bar chart.  Any
add-ons 
> to help with this? 
>