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!

  • Congratulations strongm 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: mtevensorrison
  • Order by date
  1. mtevensorrison

    No external e-mails

    Hi there We had a problem on Friday where our server almost ran out of memory, now this in turn knocked one of our exchange services out. I managed to free up some memory & then had to mount two mailboxes( mailbox store(server) & public folder store (server)) to get our users connected to...
  2. mtevensorrison

    Terminal service log on

    Yes the laptop is assigned a proper ip off the network! 192.168.16.x I jst checked the DNS(not too familiar with this), there was an IP in the reverse lookup zones which conflicted with the gaffers IP address. I deleted this and now the connection with the server name is going through fine...
  3. mtevensorrison

    Terminal service log on

    When i attempt to do ipconfig /flushdns on my mangers laptop the command prompt displays the following message - the requested operation requires elevation! Ive also checked the tcp/ip settings and it states that the laptop is connected through DHCP but when i run an ipconfig/ all is states...
  4. mtevensorrison

    Terminal service log on

    Jst attempted to ping the server name from my gaffers laptop and it times out each time, i then pinged the sppservers ip address and it went through no bother at all????? Strange, any suggestions anyone Thanks
  5. mtevensorrison

    Terminal service log on

    The ping went through with no problems from my desktop, i can also connect to the server using the server name, the bad thing is its my gaffers laptop that wont connect. How will i check for the host record and can i refresh the DNS as im sure this problem has occured before!
  6. mtevensorrison

    Terminal service log on

    Hi there have a little issue with my terminal service server Now we use server 2003 and have about 10 licenses, all our client PCs use windows XP. We can usually log on to the terminal server with no problems at all, but recently when we try to log on to the terminal server using the server...
  7. mtevensorrison

    The NTVDM CPU has encountered an illegal instruction

    Hi there Every time i boot my PC i'm faced with a Dos window with an error message. I just click ignore and the error message vanished but i feel its affecting the performance of my PC. My PC which is connected to my works domain runs windows XP and is only about 6 months old! The MS - DOS...
  8. mtevensorrison

    The NTVDM has encountered an illegal instruction

    Hi there Every time i boot my PC i'm faced with a Dos window with an error message. I just click ignore and the error message vanished but i feel its affecting the performance of my PC. My PC which is connected to my works domain runs windows XP and is only about 6 months old! The MS - DOS...
  9. mtevensorrison

    Printing over terminal services

    Hi there I have a little problem concerning colour & black & white printer settings we use a sharp MX2300 over terminal services My manager always moans when people print in colour so i set all terminal service sessions to print in black & white, i also have the main printer config on the...
  10. mtevensorrison

    Excell COUNTIF

    OK i've got it going So its now comparing collumn C on both worksheets and letting me know if that value in workshhet 1 exists in worksheet 2 and also if theres multiple entry's of the same value. Confusing stuff this, especially when you working with 15,000 rows of data Thanks
  11. mtevensorrison

    Excell COUNTIF

    Yeah im with you about the headers! so all i put in C2 or(without headers) is =A2&B2 Will this be on both workbooks? then in D2 i will put =COUNTIF(remitt!C:C,C2) Thanks
  12. mtevensorrison

    Excell COUNTIF

    Ok im with you now That is exactly what im looking for Is their a specific way of setting up a helper coolumn? Cheers
  13. mtevensorrison

    Excell COUNTIF

    Sorry to be a pest but this helper collumn is just going to keep the sum off A2 + B2 added together! Thanks
  14. mtevensorrison

    Excell COUNTIF

    Would that mean inserting the formulae in to collumn D? Cheers
  15. mtevensorrison

    Excell COUNTIF

    Hi there Thanks for the reply I don't really know why that 0 is on there! Its option 2 i would be looking for please. Thanks again Steven
  16. mtevensorrison

    Excell COUNTIF

    Hi there I'm need of a little advice from one of you geniuses out there! Here goes I use the followinf formulae -- =(COUNTIF(remitt!A:A,A7908)>0)+0 This formulae shows me which numbers in sheet2 collumb 1 are actually in sheet 1 collumb 1 - -hope that makes sense! The formula is placed in...
  17. mtevensorrison

    Excel Find & Replace

    Thanks very much Thats a pint i owe you Cheers
  18. mtevensorrison

    Excel Find & Replace

    Hi there Having a little problem with excel WE have the about 10,000 rows containg values in this format 006215586/001/ Now i want to remove all the /001/'s and put them elwsewhere on the worksheet i can remove the /001/ by using a find and replace, using /*/ But it just removes the /001/...
  19. mtevensorrison

    Filter limits in excel

    Thanks for the help guys This clears things up a bit Jst wanted clarification. Thanks again
  20. mtevensorrison

    Filter limits in excel

    We checked through the spreadsheet and there are no empty rows at all! ive seen a few articles on the web stating that excel is only capable of filtering 1400 jobs at a time. Have you tried this? Thanks for the reply by the way

Part and Inventory Search

Back
Top