i want to get ip address in a text box on a form plesse help

[Govind]

i want to get ip address in a text box on a form plesse help

[June7]

Bing: Access VBA show IP address

Does this help http://www.everythingaccess.com/tuto...f-your-machine

[Govind]

Bing: Access VBA show IP address

Does this help http://www.everythingaccess.com/tuto...f-your-machine

Thank u for ur reply. given link help me to get ip address in a immediate window. but i required the same value to be copy in a text field on a form.

Thank u in advance.

[June7]

As the remark in code says, change the Debug to whatever you want to do with the value. If the procedure is behind the form, something like:

Me.textboxname = strIPAddress

[Govind]

I tried everything but i don't know where i making mistake. i m attaching the file and request you to please check and rectify.

[June7]

Suggest a regular button instead of a toggle.

Couple ways to fix the code:

1. Put just the GetIpAddresses sub behind the form. Everything else in general module. Change the Debug.Print line to Me.IP = strIPAddress
Then code behind form:
Private Sub IP_Click()
GetIPAddresses
End Sub

2. Put all the code in general module and change Sub GetIPAddresses to Function GetIPAddresses. Change the Debug line to GetIPAddresses = strIPAddress
Then code behind form:
Private Sub IP_Click()
Me.IP = GetIPAddresses()
End Sub

[Govind]

still not happening can u please make it and send the attachment to me. please..

[June7]

The instructions are simple and explicit. They worked for me. Follow them and it will work for you.

You have the textbox Click event property set to [Event Procedure] instead of the button. Can use the textbox Click event if you want then the button is not needed.

[Govind]

Still not able to do.. request u to upload the file for me. thank you very much...

[June7]

Why not? What happens when you attempt to run the code?

I'd rather you get it working by your own effort. This was such a simple code adaptation. You already have the general module in place. Make the 2 edits from option 2.

Remove all the code you have behind the form and replace with the 3 lines I show.

Click in the textbox and ip address should appear.

[Govind]

thank you very much...its Working now..

[Govind]

i want to ask one thing...

When ever i open access database to another new computer is asking for enable editing. can u resolve it.

[June7]

Options:

1. in Access on each computer, click the Office button at upper left corner of Access, Options > Trust Center > Trust Center Settings > Macro Settings > Enable All Macros
http://office.microsoft.com/en-us/he...010031071.aspx

2. set the database as trusted http://office.microsoft.com/en-us/ac...010256412.aspx