Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: stubnski
  • Content: Threads
  • Order by date
  1. stubnski

    Formula to look up value and then sum related value

    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...
  2. stubnski

    Port Security - allow 4 computers on 6 ports

    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...
  3. stubnski

    IT Outreach Program

    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...
  4. stubnski

    Tunneling Vlans

    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...
  5. stubnski

    What WIC cards to get for routers for lab

    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
  6. stubnski

    Cannot reach NAT'd server

    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...
  7. stubnski

    CCNP Study Material

    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...
  8. stubnski

    Proxy script for off site laptops

    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...
  9. stubnski

    Outlook 2007 Change default view in tasks

    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
  10. stubnski

    Open and view Multiple Documents in Excel 2002

    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...
  11. stubnski

    Cannot Reinstall XP Pro over Vista

    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...
  12. stubnski

    computer stolen should I deactivate windows?

    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...
  13. stubnski

    Temp Table or something else

    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...
  14. stubnski

    Word 2000 IF-THEN-ELSE delete blank line

    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...
  15. stubnski

    Word 2000 If - then- else delete line formula

    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...
  16. stubnski

    Add date + 9 in word 2000 mail merge

    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...
  17. stubnski

    Add date + 9 in word 2000 mail merge

    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...
  18. stubnski

    Error Message when use comparison's with dates

    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...
  19. stubnski

    lookup in Excel 2000

    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...
  20. stubnski

    Get the count and sum based on a conditions

    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...

Part and Inventory Search

Back
Top