Recent content by itfellow

Hi, I just inherited a company document in Word 2003. It has about 50 pages, but on page 10, there is this mysterious graphic that looks like someone intended it to be a background, but instead it completely eclipses the text (the graphic is solid blue). I just want to get rid of it, but so far...

Thanks, the SUMPRODUCT formula did the trick perfectly.

Hey Chopstik, Did the lines of text in your original file get truncated when you opened it in Excel, or were they already truncated before you opened it in Excel? If opening it in Excel is what performed the truncation, I think you might be able to avoid that by opening the text file in Excel...

Hi all, I've got a spreadsheet with one column that is full of dates, and I want to add up the number of dates that fall within each year. So, if, for example, cells A1:A10 each have dates, I would like to know if it is possible to have a formula in cell A11 which counts all of the dates that...

Well, I finally found the problem. Of all things in the world, it turned out to be a bad ethernet cable from the router to the dsl modem/hub. There was no visible damage anywhere, but as soon as I swapped it out, the line protocol for the ethernet0 came online and I was able to ping the...

I used the same cable for the router that I did when connecting directly to the PC, which is, I suppose, a straight-through cable. I'm not sure why the crossover would be necessary, unless the WIC-1ENET is designed that way? Anyway, there is no duplex auto option. There is only duplex full and...

The WIC-1ENET module only does 10mbs, so there is no speed option. There is also no duplex auto option. I tried both half duplex and full duplex just to be sure, but neither works. I don't think I mentioned that the IP address from my ISP is static (that is necessary for my VPN tunnel). I...

burtsbees, I actually have the cat-5 cable plugged into the ethernet module (from the DSL modem) and I have a link light. I just haven't attempted to sync up the ethernet module settings with the DSL stuff yet. Would that be enough to expect a successful ping?

Hi all, I'm still a beginner with the Cisco routers. Here's my situation: I have two offices which communicate over the internet using the VPN tunnel between two Cisco 1721 routers. One office is out in the middle of nowhere, and just recently we were able to get DSL service to replace the old...

I have a friend whose Windows XP Home PC got hit with some spyware and a virus or two. I'm pretty sure I got that all cleaned off using various anti-virus and anti-spyware tools, but the virus appears to have done some damage that I have not been able to figure out how to completely undo. For...

Hi there, I am trying to create a report for use with SQLbase. The query for this report returns a value only if there is at least 1 row in table B that matches the key in table A. However, in some cases, there may be multiple rows in table B that match table A, in which case my query returns...

Actually, the server is not multi-homed. There is another adapter, but it is disabled.

If you use the "AT" command to schedule the batch file, you will need to specify /INTERACTIVE in order to allow the scheduled job to interact with the desktop. Otherwise, it runs as a background process. The command would be of the form: "at \\computername time /INTERACTIVE command" Hope...

Hey all, I have a small office with a Windows 2000 server as the only AD/Domain server, and up to a couple of weeks ago, everything was working just fine. Now, however, I cannot see any computer members of the domain in "My Network Places" from any client PC, and a net view from any client PC...

Ack, I knew it was something simple! Thanks for the help.