MapForums

Anonymous · #1 (**permalink**) 06-19-2003

I have a database and i just want my selections to show up. i only want to see my selections not the rest of the world, so if i have five address i only want then to show up. And if i have 3 of same category how can all three ballons show up?

jia_1980 · #2 (**permalink**) 06-19-2003

Hi, there:
Can you tell me what kind of database you are using? If it is SQL server, you can create a VIEW to store your selection, but for others, I am not very familiar with, I think you can create a temp table; after that, create a .UDL file. MAPPOINT can connect the database by the UDL file.

Hoping this is helpful.
Good luck.

petenyce103 · #3 (**permalink**) 06-20-2003

yes im using excel and not sql. For example im two text boxes one Profession and other zip code and when hit seacrh i just want it to show the professions in that area code. and have them all to show. I dont need any other data. So what options do i have? And what is the best route to use?
Thanks Pete

jia_1980 · #4 (**permalink**) 06-20-2003

Hi, Pete:
I am a little confusing about your purpose. Are you trying to create a windows-base application and it can search your EXCEL table by ZIPcode, is it correct? :) In this case, you can read the following article, it has some information about "Extract Information from Excel Sheet with DAO". http://support.microsoft.com/default...NoWebContent=1. If you are using VB and ADODB database engineer, the only thing you need is changing the DAO to ADODB.

Good Luck.

Jia

petenyce103 · #5 (**permalink**) 06-23-2003

well im into health care and if i have a text box called specialty and a text box called zip code. When the user types in specialty i want all the specialties in that zip code to show. Im using excel and i will ahve a database. so if the user types in bone specialist with a zip code of 11757 all the bone specialist in that area code show up. How should i do this?
thank you

bigRahn · #6 (**permalink**) 06-23-2003

I've not played with connecting Excel to MapPoint.

Once you have a DB though, it's pretty easy.
Create a query on the fly when the user enters their selection. (i.e. bone specialist, 98111).
Use a query similar to:
SELECT Name, Address, Phone FROM MySpecialists
WHERE specialtycode = '<insert user selection>" AND zipcode = '<insert user selection';

This will return the recordset with your information.
then just loop through the records and put them on your map.

As Jia mentioned, you can probably use DAO to link directly with Excel, so this same method will work.

As far as "not seeing the rest of the world", you'll need to put up with some of that...you can't turn off the whole map.
However, you can set your defaults to not show the internal points of interest.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Capture mappoints close event	Dazzer	MapPoint 2006/2009 Discussion	0	06-29-2004 05:19 AM
Export MapPoints Direction to GPS File. HELP	Anonymous	MapPoint 2006/2009 Discussion	2	06-20-2003 02:09 AM
Is it possible to export MapPoints' nearby places ....	Anonymous	MapPoint 2006/2009 Discussion	1	01-15-2002 09:14 AM

MapForums

Can you Use Your data only and not mappoints

Can you Use Your data only and not mappoints

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

Similar Threads