Return an IP address from a Host Name

[spaceisdeep]

I've been scouring the news groups for hours now an have not come up
with a solution to my problem. I very simply want to return the IP
Address in a text box of a host name that is in another text box upon
entering the form. I have discovered that their are API functions that
perform this and I have found information here:
http://www.mvps.org/access/api/api0067.htm that details how to
"Perform IP Lookups and resolve addresses" using modules and
functions. However I not sure how to apply this to my situation.
Thanks for any help in advance.

Rob

 

[Douglas J. Steele]

In the AfterUpdate event of the text box where the user enters the Host
Name, put a call to the function to populate your other text box.

If you're entering the name in a text box named txtHostName and want the IP
address in a text box named txtIPAddress, it would look something like:

Me.txtIPAddress = fGetHostIPAddresses(Me.txtHostName).Item(1)

 

[spaceisdeep]

That worked great! Thanks Doug! I didn't realize that you needed the
Me.txtIPAddress to equal the function. I thought you could just call
the function...but after thinking about it...you would need to tell
the function where to put the results.
Must have been a Brain Cloud!
thanks again,

rob