VBA code to get IP address of PC? RRS feed

  • 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.  
    Wednesday, October 3, 2018 5:41 AM

All replies

  • 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.

    Wednesday, October 3, 2018 2:23 PM
  • 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

    Friday, October 5, 2018 2:58 AM
  • Hum, not a really short routine I can see/find.

    You can try this code:



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

    Edmonton, Alberta Canada

    Wednesday, October 10, 2018 10:55 PM