Creating a Hyperlink

[dwmackay]

Greetings,



I am not a programmer, but have built myself a sales territory management database. I am trying to create a link to google maps from the company address. I store the address, city, state and zip in seperate fields in a single table (Main). I found the correct syntax for google maps addresses, but I cannot get it to work.

The syntax for google maps is: "http://maps.google.com/maps?hl=en&q=" followed by the address and zip.

I created a Control (Text 149) and set the data value as "=' http://maps.google.com/maps?hl=en&q=' & [Addr1] & ', ' & [Zip Code]". This produces the correct syntax, but it is not stored as a hyperlink. If I copy the resulting control and paste it into a browser, the syntax is correct and it takes me to google maps and the address.

For some reason, I cannot get this to be a hyperlink, just text. I set the properties of the Test 149 to Is Hyperlink: Yes, Display as Hyperlink: Always. But it does not work. I can click on it, but it only selects the underlined text, it does not launch the browser.

Now for the strange part. I added a field to the Main table in the database to add a Google map hyperlink address. I set that as a hyperlink and stuffed the Text 149 into the table using Set Value when the form is opened. That too does not work. It puts the value no the new Google field, but it is only text not a hyperlink. However, if I manually copy and paste Text 149 into the Google field, it works as a hyperlink. So it is the same data, it just starts working when I copy and paste.

Any help is appreciated.

Doug M.

[tdecker81]

http://www.access-programmers.co.uk/...d.php?t=104421

I used this code and made the openwebpage into a module function so i could use it from anywhere in access just by passing the url i want it to open.

Then added a label to the form that has the address info i needed. In the on click event of that label i added code to store the url with the address info like you have shown above as the data value. Pass that variable into the function and it should work. Post back if you're still having trouble. I have example code but not here on this computer.