MapForums

I have an access database which i am using to color counties and specific states around the usa. I need to able to filter the database inside visual basic and display it in mappoint's method: "Display data map". The Display data map method allows me to choose a table but i have not found a way to establish parameter in its properties so i can only map the filtered information. Any help on that would be grealty appreciated.

The code below maps everything together, however i need to be able to filter the field practice code to a specific value before submitting the information to mappoint.

'---Similar to the Pushpin version, the following code display a shaded data map on the screen

Dim objMap As MapPointCtl.Map
Dim szconn As String
Dim objDataSet As MapPoint.DataSet
Dim objDataMap As MapPoint.DataMap
Dim objField As MapPoint.Field
Dim lRangeValues(1 To 5) As Variant
Dim zRangeNames(1 To 4) As String
Dim lColorRange As Long
Dim objPin As MapPoint.Pushpin
Dim rs As ADODB.Recordset
Dim sSql As String


Set objMap = MappointControl1.NewMap(geoMapNorthAmerica)
Set objMap = MappointControl1.ActiveMap

With objMap.DataSets
szconn = "C:\Silveus\MapPoint\Texas\Texas.mdb!Texas997"
Set objDataSet = .ImportData(szconn, , geoCountryUnitedStates, , geoImportAccessTable)

Set objField = objDataSet.Fields("practicedescription")

Set objDataMap = objDataSet.DisplayDataMap(geoRangeTypeUniqueValues , objField, _
geoShowByRegion2, , _
geoRangeTypeDiscreteEqualRanges, _
, _
lColorRange)
End With

I think Richard answered this same question recently. The approach is to do your filtering in Access before you do the .ImportData to MapPoint. In your case create a query in Access that selects the rows you want from table "Texas997." Set szconn (DataSourceMoniker) to the name of the new query and then use geoImportAccessQuery as the ImportFlags.

If you run into trouble check the help files in MapPoint Programming Information - there are a couple examples there.

Ciao,

__________________
Calv1ns

Yes that would be my approach.

I haven't done much work with color shaded plotting and ImportData, but datasets are read-only. Even user-imported pushpin sets!


Richard

__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009