IPAddress LIKE

[BLFOSTER]

Hi. I want to open a database from a location where the location is different depending upon the IP Address of the computer. I have been trying to use the "LIKE" operator in VBA to do this, with no luck. I have no idea what I am doing and do not even know if I can use the function GetIPAddresses OR set db/open database here ...thank you for any assistance you can provide!!

If GetIPAddresses() Like "*" & PMB & "*" Then




Set db = OpenDatabase("Z:\STS\Start.STracking.DB.accde")

elseif GetIPAddresses() Like "*" & SE & "*" Then

Set db = OpenDatabase("goodledrive:\STS\Start.STracking.DB. accde")


End If

[ItsMe]

What is GetIPAddresses?

I do not believe this is a built in function.

[BLFOSTER]

A function to get the IP address....not a built in.