Updating hyperlink value with another field

[Totti]

Hello,
I am new to MS Access (2007) and am trying to create a hyperlink in a table to Google maps without much luck.

The URL I need to use in my hyperlink is http://maps.google.com/maps?&z=14&ll= followed by the longitude and latitude values for my location.

My table has a field ("LL") that holds the Longitude and Latitude values. Each entry in my table will have different LL co-ordinates. I have another field ("Hyperlink" ) that holds the first part of the URL that does not change.

I need a way of combing these two values in a hyperlink so that when the user clicks on the button, field or text box they will be taken to the Google maps website (and the correct location).

I have tried creating a text box on my form that combines the "hyperlink" and "LL" field values and have set the text box to "Is Hyperlink" equals Yes, but this appears to only display the combined text as a hyperlink but doesn't actually do anything.

I have also tried adding a command button on the form with a hyperlink, however I cannot get the hyperlink to pick up the values of the "LL" field as the Hyperlink SubAddress for the record being displayed on the form. This method does correctly go to Google maps but without any LL co-ordinates.

I have also tried creating a field of type hyperlink in my table but I cannot get that field to combine the values of the "hyperlink" and "LL" fields so it holds a complete URL.

I appreciate your help.

[ADezii]

Hello,
I am new to MS Access (2007) and am trying to create a hyperlink in a table to Google maps without much luck.

The URL I need to use in my hyperlink is http://maps.google.com/maps?&z=14&ll= followed by the longitude and latitude values for my location.

My table has a field ("LL") that holds the Longitude and Latitude values. Each entry in my table will have different LL co-ordinates. I have another field ("Hyperlink" ) that holds the first part of the URL that does not change.

I need a way of combing these two values in a hyperlink so that when the user clicks on the button, field or text box they will be taken to the Google maps website (and the correct location).

I have tried creating a text box on my form that combines the "hyperlink" and "LL" field values and have set the text box to "Is Hyperlink" equals Yes, but this appears to only display the combined text as a hyperlink but doesn't actually do anything.

I have also tried adding a command button on the form with a hyperlink, however I cannot get the hyperlink to pick up the values of the "LL" field as the Hyperlink SubAddress for the record being displayed on the form. This method does correctly go to Google maps but without any LL co-ordinates.

I have also tried creating a field of type hyperlink in my table but I cannot get that field to combine the values of the "hyperlink" and "LL" fields so it holds a complete URL.

I appreciate your help.

I've Attached a Sample Database for you that will Open Google Maps via Application.Hyp erlink. The User can specify a Street Address, City, State, Zip/Postal Code, or Country for the appropriate Map to be brought up. The Fields on the Form are Unbound, but it should be a simple matter to Bind them to Fields (TEXT) in a Table Record Source, then incorporate Longitude and Latitude into the logic. Hope this helps.