Recent content by keithvp

Thanks VBSlammer, However, I did use .Refresh within my code. It would reload the page but not show the additional file. I also tried programming the browser to go to Yahoo then back to the FTP site. I also added a button that specifically would load the FTP site. That would not show the new...

Hello, I have designed an Access DB that collects data and and extracts it to a text file. I then coded the DB to FTP the text file. In order to make it easier for the user, I inserted a Web Browser Control on the form where the user selects the data. Originally, the WBC opened to the FTP site...

Hey aheath, I had problems FTPing in IE once XP SP2 was installed. I could only reach some FTP sites. The solution that may help is to go into Tools-> Internet Options ->Advanced Tab. Remove the checkmark in Use Passive FTP.(for firewall or DSL modem compatability). You should be able to FTP...

I am working on a VB interface to a SQL server that will be used to track contract requirements. I am taking data from two tables and inserting it into another table that has been created. All of my SQL statements are correct. I have tested them in Query Analyzer. When I try to do the same...

If I understand, you want the field to blank on the form and be in add new record mode. If you are opening the form by a macro, set the macro to open the form. on the next line choode gotorecord under action. You can then choose "new" under Action Arguments. This will allow you to...

Does anyone have a script that checks the system uptime of a Windows 2000 server? The script I have is only for XP and Windows.net.

If you do not want the hyperlink to actually be a hyperlink, you can also right click on the hyperlink, go to the hyperlink sub-menu and select remove hyperlink. This will leave "www.yahoo.com" but without the blue underlining and link capabilities. Keith

I am using the following script for static configuration. However, I do not have anything for proxy. We do no use it. strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colNetAdapters = objWMIService.ExecQuery _...

Thanks. Both ways worked. However, I prefer the script. Keith

I am using the script below to enable DHCP. However, it will not set the Preferred DNS server to DHCP enabled. I need to be able to switch between all static and all DHCP enabled. How do I add in the cabability to set the Preferred DNS as DHCP enabled after it has statically assigned IP...

Thanks that worked perfectly Keith

Hello I am using a script from TechNet to statically assign an IP address for In/Out of office purposes. The script is below. However, I also need to statically assign the preferred and secondary dns servers. What is the vbscript reference to dns for me to assign those addresses? Thanks...

Thank you both for the suggestions. I have tried the original two suggestions, i.e small and array. Both worked fine. I tested the small function containing countif extensively to see if it worked. It did. The Array function worked well too. One of my concerns is that some of my users...

Is there a function in Excel that will find the minimum value in a range while excluding any zeros as a value? Or has anyone tweaked the min function to do this?

I have written a program that links images into a database to create ID cards for school pictures. It linked images. However, when an id did not exist on the CD, the next image in order on the CD was put in its place, i.e no 1.jpg on CD but 2.jpg does and is place in the record for 1. I tried...