Google maps from form

[JeroenMioch]

Greetings,

I have a form with underlaying table.
On the form i have a caption called 'maps'



In the table i have a field called 'GoogleLink' wich holds the link to the adress on google maps.
This is a hyperlink field and when clicked it goes to the adress on google maps but i want to click
the caption called 'maps' to do this.

Anyone clue to an approach ?

[June7]

Options:

1. put the url in the HyperlinkAddress property

2. use FollowHyperlink method in click event

3. use AllenBrown GoHyperlink code http://allenbrowne.com/func-GoHyperlink.html

4. use WebBrowser control


Labels are not dynamic. They do not have a ControlSource property. VBA can set properties so code in some event could set the label HyperlinkAddress property to value from the field.

[JeroenMioch]

Hi June,

Putting it into the hyperlinkadress is no option as my users need to be able to update the link if it changes.
I think i have tried the FollowHyperlink method but ill give it another go.

Ill let you know how it works out, Thanks for your reply !

Greetings : Jeroen

[ipisors]

Suggestion:

Do not use Hyperlink type fields at the table level. Change the field type to regular text, allowing plenty of char's (default 255 is fine). Store the real, un-obfuscated URL in the table field (and give your user a form interface to be able to change it).

Simply code the label's CLICK event to something like:

Application.FollowHyperlink Dlookup("fieldName","tablename")

[June7]

If you want the hyperlink field, it is still possible to use FollowHyperlink or GoHyperlink. Would have to extract the address part from the hyperlink field content. I think Allen Browne's function does that for you.

For an understanding of the hyperlink field review http://www.allenbrowne.com/casu-09.html

[ipisors]

If you want the hyperlink field, it is still possible to use FollowHyperlink or GoHyperlink. Would have to extract the address part from the hyperlink field content. I think Allen Browne's function does that for you.

For an understanding of the hyperlink field review http://www.allenbrowne.com/casu-09.html

(just to clarify) - I don't necessarily disagree with that, I just have a personal opinion that for most people, using hyperlink fields is a terrible idea. Why create something that obscures and obfuscates the real URL or path. I think it much better to store the regular URL in a text file then use any number of methods to open the file, navigate, etc.

Of course, this didn't become clear to me until the first time I did a project where someone was very hyperlink-happy, but all of a sudden we needed to get the real data out of the fields. Then I sure wish it was plain text.

I think hyperlink fields are a quick and lazy approach, an extra 10 minutes of coding will save you a lot of pain in the event you need to know the real paths someday - which you probably will.
Just my opinion

[June7]

Don't disagree with that either, just nice to know options.

Some people like the hyperlink wizard to assist with populating field, some find it frustrating. If hyperlinks are web urls, copy/paste or typing only other methods I know to populate field. The hyperlink wizard is intended to facilitate populating field with web url and it works for local folder paths as well.

[JeroenMioch]

I dont nessecary need to have the field in my table to be a hyperlink field.
My users are meant to be able to copy the URL in that field, Opening the URL should be done from a link om my form.

I can easely make a control wich holds the field in the table, but i just want to open it from a link on my form called (maps)

The code by allen Browne is long and i have bad memories from modules, but ill figure it out

[orange]

You may get some ideas from this.

[JeroenMioch]

Got it !
Application.FollowHyperlink Dlookup("fieldName","tablename") did it for me
I did have to pass the where clause but with success.

Only problem i have now is that the label doesnt show that its a link (no 'hand') and that the link opens in the background.

Any suggestions to this ?

[amrut]

See http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx for some help.
Label has hyperlink property and it can be formatted to look like a link.

[JeroenMioch]

I worked around the no link problem by using a transparent button.

Thanks all for thinking with me. The problem is solved

Greetings : Jeroen