Can you Use Your data only and not mappoints

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?

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.

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

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.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q190/1/95.ASP&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

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

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.