VBA code to get IP address of PC?

Question

How can i get ip address of my pc on a form text box or in access table. Vba code to write in on open event of access database form. i want to print ip address of my pc on form text box or in access table.  

Answer 1

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-powershell-1.0/ff405671(v=msdn.10)

---

If this post answered or helped you find the answer to your question, please mark it as such for other Forum users knowledge.

Answer 2

Why?

You're using Access, which implies you are most likely writing a business productivity application. Why do you need to display the IP address (which presumably comes from DHCP and can change over time)? Most business productivity application users will likely not even know what an IP address is, or what to do with it.

---

-Tom. Microsoft Access MVP

Answer 3

Hum, not a really short routine I can see/find.

You can try this code:

https://www.everythingaccess.com/tutorials.asp?ID=Get-all-IP-Addresses-of-your-machine

Regards,

Albert D. Kallal (Access MVP, 2003-2017)

Edmonton, Alberta Canada