Button code for IP location

[dniezby]

I have a button on one of my forms that I want to program to give my DB user the location of an IP Address. Anyone have a way to code this into a button?



Here is the deal.

On my form, I have a field - USER IP which tells my DB user the IP address a contact's email and information was collected. I would like my DB user to be able to click a button next to that IP address field and have it return with some type of response that says responds with location and (hopefully) timezone. (IE : Chicago, IL - -6 GMT or even "Chicago, IL. - CST)

Can this even be done?

I hope someone already has some code for it.

Thanks again in advance.

[davegri]

Look here:
https://db-ip.com/db/https://db-ip.com/db/
A couple of the DLs appear to be free.

[dniezby]

Look here:
https://db-ip.com/db/https://db-ip.com/db/
A couple of the DLs appear to be free.

Holy cow! That's way more than what I'm looking for. Data I don't really want to bloat my DB with. It's not THAT important. Just thought it would be a cool feature.

I did find this site http://freegeoip.net

It says it takes http get requests like this

freegeoip.net/{format}/{IP_or_hostname}

I just don't know how to program the button with something like this nor how to handle the results if I did.

Any ideas?

[dniezby]

After reading that site, I think I figured out how to do what I want.

Here is what I did.

Made a button with this onclickevent

Private Sub btn_iplookup_Click()
Me.btn_iplookup.HyperlinkAddress = "http://freegeoip.net/?q=" & Me.IP
Me.btn_iplookup.Hyperlink.Follow True
Me.btn_iplookup.HyperlinkAddress = ""

End Sub