Ping from a form using a command button / Pull username logged on

[Guest]

I am wanting to create a form with buttons for each IP Address I am
responsible for. On the click event, I would like to ping 192.168.0.1 is this
possible? I have around 200 IP Addresses, so there is going to be a lot of
scripts in this. Is there a way to pull up the username logged on the domain?


Thanks,

Lee

 

[John Nurick]

Hi Lee,

There's VBA code at http://www.mvps.org/access/api/api0008.htm that returns
the current user name.

 

[jahoobob via AccessMonster.com]

You can create a .bat file that consists of this line:
ping %1
name it something like pinger.bat (In this example it is in C:\)
In a form have a combobox based on a table of all of your IP Addresses.
In the Afterupdate property of the combo place this code:
Dim stAppName As String

stAppName = "C:\Pinger.bat"
stAppName = stAppName + " " + Me![Combo_box_Name]
Call Shell(stAppName, 1)
Whenever you select an address from the combo you will see the "DOS" window
running your ping
If you use a combo you can either search the dropdown or type a partial or
whole IP.
I believe that this is easier to set up than a form with 200 checkboxes and
easier to use.
Hope this helps,
Bob

 

[Guest]

I have 3 different segments, I have already made the forms, one is named 231.
How can I use the check marks with multi select?

Lee

You can create a .bat file that consists of this line:
ping %1
name it something like pinger.bat (In this example it is in C:\)
In a form have a combobox based on a table of all of your IP Addresses.
In the Afterupdate property of the combo place this code:
Dim stAppName As String

stAppName = "C:\Pinger.bat"
stAppName = stAppName + " " + Me![Combo_box_Name]
Call Shell(stAppName, 1)
Whenever you select an address from the combo you will see the "DOS" window
running your ping
If you use a combo you can either search the dropdown or type a partial or
whole IP.
I believe that this is easier to set up than a form with 200 checkboxes and
easier to use.
Hope this helps,
Bob

I am wanting to create a form with buttons for each IP Address I am
responsible for. On the click event, I would like to ping 192.168.0.1 is this
possible? I have around 200 IP Addresses, so there is going to be a lot of
scripts in this. Is there a way to pull up the username logged on the domain?

Thanks,

Lee