S
ScubaSteve
I'm trying to take an address from a textbox in a form "Address, City,
State, Zip" and create a url string from the data and pass it into
google maps that is in a webbrowser within an access tab.
The hyperlink should look like this:
"http://maps.google.com/maps?q=111+West+Gable+Lane+Dayton+OH+45410&iwl..."
So I just need Address to go in first, then city, state, zip etc. How
would I do that from a textbox? I get really confused with all of the
& and " in these statements. Is it easier to do from a table? I
imagine I'd have to pull up the primary key first so it passes the
right data along - which is why I thought it would be easier to do from
a textbox since it is already showing that data.
Form is [frmCase].[frmPatient] (which is a subform) and the textboxes
are txtaddress, txtcity, txt state, and txt zip.
Thanks!
State, Zip" and create a url string from the data and pass it into
google maps that is in a webbrowser within an access tab.
The hyperlink should look like this:
"http://maps.google.com/maps?q=111+West+Gable+Lane+Dayton+OH+45410&iwl..."
So I just need Address to go in first, then city, state, zip etc. How
would I do that from a textbox? I get really confused with all of the
& and " in these statements. Is it easier to do from a table? I
imagine I'd have to pull up the primary key first so it passes the
right data along - which is why I thought it would be easier to do from
a textbox since it is already showing that data.
Form is [frmCase].[frmPatient] (which is a subform) and the textboxes
are txtaddress, txtcity, txt state, and txt zip.
Thanks!