View Full Version : link data wizard won't let me use parameter queries

08-12-2002, 04:07 PM
Why can't I link data using a query that has in the criteria something like [Forms]![Customer Info]![Customer Id] ?
When I go to use the link data wizard in mappoint, it doesn't list any queries with any parameters like the one above or one like [Enter Customer ID:].
Is there a reason?

08-19-2002, 03:18 PM
Is this a query that exists in an MS Access table?

08-20-2002, 05:55 PM
Yes, the query is in MS Access.

Eric Frost
08-20-2002, 06:15 PM
I've noticed this.. You just have to work around it.. Maybe there will be support for it in MapPoint 2003.

keywords: access, parameter, link data wizard, query

08-21-2002, 11:08 AM
I even called Microsoft, and talked to someone about it. They couldn't give me a reason why, which I thought was weird. I can't figure out why they would allow a query with the criteria for customer id to be "1" but will not allow the same query with the criteria for customer id to be Forms![Customer Form]![Customer ID]. Werid.

Eric Frost
08-21-2002, 11:37 AM
I think it's like "software's never finished, it's released".. I don't think they fail to support this intentionally, they probably just haven't gotten to it yet.. MapPoint is still an immature product (3rd release, three years) and new features are being added rapidly..

08-23-2002, 07:07 AM
You can easily work around this by creating a query that uses a linked text file that has a join to the field where you would otherwise use a parameter. Simply put, change the value in the text file just prior to running the stored query. For example if you were interested in only plotting data associated with Florida, you would change the value in the text file to FL. Having the linked text file joined to the state field in your table will yield the desired result set.

Eric Frost
08-23-2002, 10:14 AM
Thanks, that looks like an elegant approach... we used VB to re-write i.e. re-create the entire query via sql statements in the last project.