Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 8 of 8

link data wizard won't let me use parameter queries

This is a discussion on link data wizard won't let me use parameter queries within the MapPoint Desktop Discussion forums, part of the Map Forums category; Why can't I link data using a query that has in the criteria something like [Forms]![Customer Info]![Customer Id] ? When ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    link data wizard won't let me use parameter queries

    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?

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Is this a query that exists in an MS Access table?

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Yes, the query is in MS Access.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    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
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  5. #5
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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.

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    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..
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  7. #7
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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.

  8. #8
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    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.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Link Data Wizard Problem (URGENT HELP!!!)
    By craig_korn in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-19-2005, 02:03 PM
  2. Link Data Wizard fails
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-24-2004, 08:03 PM
  3. using access 2003 queries as a data source
    By roberta walker in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-27-2004, 07:06 AM
  4. After using the Link Data Wizard in Microsoft MapP....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-28-2003, 06:37 AM
  5. I've tried using the data link wizard to connect t....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-18-2002, 10:47 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25