Outputting addresses Query to google maps in sequential order?

E

efandango

This code takes the various field data and outputs them to Google maps in
sequential order.

[Form_Runs].WebRouteMap.navigate
"http://maps.google.co.uk/maps?f=q&hl=en&q=" & "from: " & Me.Point_1 & (" to:
" + Me.Point_2) & (" to: " + Me.Point_3) & (" to: " + Me.Point_4) & (" to: "
+ Me.Point_5) & (" to: " + Me.Point_6) & (" to: " + Me.Point_7) & (" to: " +
Me.Point_8)

I want to do the same thing, but with a query based on a sequential list of
addresses from only one output field.

This is my SQL:

SELECT tbl_Run_Waypoints_Test.Run_waypoint_List_ID,
tbl_Run_Waypoints_Test.Run_No, tbl_Run_Waypoints_Test.AnswerWaypoint,
tbl_Run_Waypoints_Test.Postcode
FROM tbl_Run_Waypoints_Test;

The [AnswerWaypoint] field holds the output data; and the
[Run_waypoint_List_ID] holds the Run Order.

The obvious benefit of the Form based code is each field can be referenced
uniquely, but due to the nature of the data, I have no way of splitting it
into separate fields. Does anyone know how I can make the code take the data
straight from the single field query?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I parse or Loop a list based on single field to Googlemaps 2
Parsing data to Googlemaps with optional string ending 3
You can use Google Maps with an Acess DB 10
Passing URL to Google 4
Google maps "submit" from module 8
Create Macro to Copy and Paste into Google Maps 0
Adding Sequential Numbers to a Query 1
Add sequential number to select query 2

Top