HI,

I have an Access Service report file that I have imported into MapPoint. One of the fields contains date information. We would like to perform a query for a particular date range and have those specific pushpins show up in MapPoint. How can we do this? I have never tried using Visual Basic or any other programming instructions.

Thanks.

John

Do you use Access much? The simplest would probably be to do your query in Access and then import the results.

Of the ways to tackle this programmatically, I would probably recommend doing it all in Access, i.e. control MapPoint from Access VBA rather than as a MapPoint COM Add-in. I think that will give you more flexibility as far as preparing your data before it gets to MapPoint.

Eric

I think Eric has the right idea. Do a query for reduce your dataset, then put the pushpins into MapPoint.

But, based on your original post, one question I have is how did you import your data into MapPoint? Did the date make it into your pushpin information?

I found that Map Point is unable to retrieve data from a parameter querry in Access (it won't even show up in the import data wizard). I worked around this by creating a tmp table, filled it with the querry results and then pass the data through to MP.

I am having the same problem; not being able to import a query that uses a function I developed to extract the Postal Area. Is the only known work around for this to dump the info into a temp table? Surely it being a MS Office product they would have developed for this?!?