Search results for query: *

Hi Guru's, My issue is this, I have a column of values(word1, word2, word3) in column C and numerical values in column B. I want to search Column C for a text value and then sum the related value in column B. Values for column C are single words Ex. Column B Column C 2...

Hi, I have four computers that move between six different offices. Is there a way to allow only the same four mac addresses on six ports to provide some sort of port security? Something like the below config. The public has unsupervised access to these rooms so I want to secure it as much as...

Hi All, My director has come up with an idea for an IT department "Outreach" program. I'm not sure what made him think this is a good idea. What this entails is that each of the IT staff (4 of us) is assigned a certain number of directors (6 - 10 depending on department size) to find out any...

Hello Guru's, I hope I can explain this well enough so here it goes - We have a remote site that is connected to our HQ via a layer 2 gig connection through our ISP. Our connection through the ISP is not going to change. I need to expand the amount of vlans I can use at the remote site but...

Hi all, I have bought a 3640 and a 2621 routers for my home lab. They do not have any wic cards in them and I wanted to know what cards I should get for them to setup a CCNP lab. They have the latest IOS. Thanks for any suggestions Stubnski

Hi all, I hope someone can give me any ideas on what is happening. I hope I can explain it well enough for any of you to understand. The problem is I cannot access a NATed server from the same subnet as the NAT. ex - public IP address subnet - 200.200.200.1 /28 ASA 5520 version 8.0(3)(doing...

Hello all, I have just ordered the CCNP Official Exam Certification Library (5th Edition) from Cisco. Is there any other books/websites that is a good supplement/fill-in the blanks for the Cisco books? Also does anyone that has taken the exams have any suggestions on the order to take the...

Hi everyone, We are currently forcing proxy and graying out the checkbox to uncheck proxy settings through GP. Is there a script or some other way besides unchecking the check box in internet options --> connections --> lan settings that a user can either double click or the laptop will...

Hello everyone, Outlook 2007 - When you click on the task button in the navigation pane it goes to the "To-Do List". How can I make it so the default is the users Tasks? Thank you in Advance Stubnski

I've checked the FAQ's, and searched for the answer but am unable to find it. At my PC I am able to click on two different Excel 2002 documents and have each one open up in a new Excel instance (not a new window in Excel). When a user at a different PC, with the same version of MS Office...

Hi, I had Vista loaded on my PC but couldn't get a few older programs to work on it so I tried to install XP Pro. I can get to the Xp Install screen and format the drive and install but when it goes to boot from the hard drive all I get is a blinking cursor. I've tried formatting the hard...

Hi, guru's. My computer was stolen this weekend and I wanted to know if I could deactivate XP pro from the stolen computer and reactivate it on a new computer that I'm putting together so the stolen computer's copy will (hopefully) stop working. Is this wishful thinking or can I even...

Hi all, I would appreciate if someone can point me in the right direction with my problem. This is for a financial application, Access 2000 I have four tables - Application, Approved, Funded, and Canceled. Every new record starts out by being added to the Application table, from there it is...

Hi experts Is there a formula that will say If address2 ="" then delete this line else address2. It is for a mail merge. The program that I need to use connects to Word, but it will not use the suppress blank lines when merging option. So I have a blank line in the members address on some...

Hi experts Is there a formula that will say If address2 ="" then delete this line else address2. It is for a mail merge. The program that I need to use connects to Word, but it will not use the suppress blank lines when merging option. So I have a blank line in the members address on some...

Hi VB experts! I have a mail merge document in word 2000 with a merge field named effective_date. I need to insert a date 9 days in advance of the effective date (effective_date + 9). Ex. effective_date = 5-1-06 date to be inserted = 5-10-06 NEXT DAY - effective_date = 5-2-06 date to be...

Hi VB experts! I have a mail merge document in word 2000 with a merge field named effective_date. I need to insert a date 9 days in advance of the effective date (effective_date + 9). Ex. effective_date = 5-1-06 date to be inserted = 5-10-06 NEXT DAY - effective_date = 5-2-06 date to be...

Hey Everyone, I get this error message - [C:\Program Files\Microsoft Office\Office\msqry32.exe] [SQLCODE: <-400>:<Fatal error occured>] [Cache Error: <<NOLINE>^CacheSql4>] [Details: <Serverr>](spelled with two rr's on the end) It only happens when I use comparison operators(=,<>,<=,>=)to...

Hi everyone, Here is my code - =PROPER(LOOKUP(A2,'C:\[Member Data.xls]MBRDATA'!$A$2:$A$600,'C:\[Member Data.xls]MBRDATA'!$D$2:$D$600)) Column A are numbers(account #'s) Column D is text formated as General(Names). When I paste the code down the column all the records return what I need, all...

Hi everyone, this is what I have been banging my head against. I have three columns - column A are dates ex. 1/3/06 1/3/2006 1/6/2006 1/10/2006 .... formated as date The dates are random. In column B I have text ex. IN HOUSE CNTRY PHH... formated as general In column C I have currency ex...