Pulling the IP Address

[Randy]

I work in a shop that develops two applications. We use the same SQL Server
2k dB, and share a common table named Logins. When the C# application opens
up it updates this table with things like ... IP Address. When our Access
application opens, the users must login, and we post to the same Logins
table. We never post the IP Address though. We were just talking about
some changes that we were going to make to the Access application and we
were wondering if there was an easy way to pull the current IP Address like
there is in C# (Environment.IPAddess).

Thanks,

Randy

 

[Randy Birch]

Get the IP address of a machine under VB / VBA ? ... sure, though not via
any property or such ... see
http://vbnet.mvps.org/code/network/iplookup.htm

Although the demo pix shows a web url, you can also pass the local machine
name (retrieved with this code:
http://vbnet.mvps.org/code/core/getcomputername.htm)

--

Randy Birch
MVP Visual Basic
http://vbnet.mvps.org/
Please respond only to the newsgroups so all can benefit.


: I work in a shop that develops two applications. We use the same SQL
Server
: 2k dB, and share a common table named Logins. When the C# application
opens
: up it updates this table with things like ... IP Address. When our Access
: application opens, the users must login, and we post to the same Logins
: table. We never post the IP Address though. We were just talking about
: some changes that we were going to make to the Access application and we
: were wondering if there was an easy way to pull the current IP Address
like
: there is in C# (Environment.IPAddess).
:
: Thanks,
:
: Randy
:
: