Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MapQuester (v2K)

    I have a customer table with clients, addresses, visitation days and visitation order. The visitation days and visitation order work like this: Juan's Nacho Shop, Monday, 3 means Juan is visited on Monday and is the 3rd stop.

    We maintain a route book with Mapquest printouts from one stop to the next. As we add/delete clients, we have to re-run all the maps. In Access, how can I build a mechanism that pulls driving directions from one stop to the next for each day and adjusts to the customer table automatically?

    Thanks,
    Dashiell

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: MapQuester (v2K)

    How are you currently getting the maps? It's a good-sized jump to try to drive a web browser with Access and do it that way - I'm not sure it is even possible. There is a server product that you can use, but I would guess it's quite expensive.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MapQuester (v2K)

    We run each map individually. Do you have the name of the server product?
    Thanks,
    Dashiell

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: MapQuester (v2K)

    The MapQuest server product is called MapQuest Enterprise V2.0 Server and you can read about it here.
    Wendell

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: MapQuester (v2K)

    You might look at a product called Microsoft MapPoint 2004. This may work better than trying to fetch some simple MapQuest maps off a web site, which is not a task Access was designed for. According the MapPoint FAQ page:

    "MapPoint 2004 is a stand-alone application in Office XP. However, it does enable users to seamlessly import data from Office XP applications such as Access, Excel or the Outlook

  6. #6
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MapQuester (v2K)

    Thanks Wendell and Mark. These new programming challenges and twists keep things interesting. Thanks for shedding light and I'll let you know how things turn out.

Posting Permissions

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