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 Rhinorhino 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: mattm31
  • Content: Threads
  • Order by date
  1. mattm31

    Excel Help

    I know this will be easy for most of you but i cant seem to get my head round it this morning, I have column A filled with numbers and column C with numbers in it. I want to compare A with C and if it finds a match in the range fill column B with the contents of column D. Thanks for your help
  2. mattm31

    Samsung Office Serv 7200 Trace Calls

    Hi Does anyone know away of tracing which extension an external call was picked up at ? think we have someone in the office hanging up on customers but not sure who! Thanks Matt
  3. mattm31

    Logon to DC from remote site

    Hi i'm looking for a bit of help with this. We have a remote site connected to us via a router to router VPN connection, i can ping the DC from the remote site but is there an easy way to make sure it tries to log on to the DC when the user logs in ?
  4. mattm31

    Samsung Office Serv 7200

    Hi We have an Office Serv 7200 and i'm trying to find a way to make several extenstion Internal only ie. Can't dial out of the building. I've been looking through the Manager but can't see anything. Is it possiable ? Thanks Matt
  5. mattm31

    Need help with strange problem

    Afternoon all, This morning i have come into the office and 2 pcs on the first floor have no network connection, I checked all the cables back to the switch with a network tester and there all showing fine, I plugged another PC into the two ports that appear not to be working and it worked...
  6. mattm31

    Excel formula help

    Hi I'm trying to get a formula to work but cant seem to get my head round it this morning. I have a cell E14 with a list in it, Gold, Silver, Bronze I want cell E15 to look at it and which ever value is selected use a folrmula for it. Something like this...
  7. mattm31

    Logon to domain Over VPN

    Hi We have a remote warehouse that is connected to us Via router to router VPN, I've been looking at ways of letting it logon to the Domain over the VPN and have been told that a logon script should do the trick but can't find any information anywhere of how to do it, Could someone point me in...
  8. mattm31

    SQL and IUSR

    Hi Not sure if i'm posting this in the right section but here we go. My server 2K server running SQL 2K and our Intranet was dying so i cloned the disk and moved it to a new machine. It came up fine and the Intranet which gets its stats from the SQL worked fine apart from its showing dates as...
  9. mattm31

    Windows Mobile

    We have exchange 5.5 and the directors have just got PDAs and want to pick up their email on them. Is this possible from 5.5 and if so can you direct me to any setup guide as i can't seem to find any info. Thanks Matt
  10. mattm31

    Site to Site VPN and Domain Controller

    Hi We have a site to site VPN using Netgear routers, Is there a way of directing the remote site XP Pro machines to the Domain controller for logons etc. ? Thanks Matt
  11. mattm31

    Sum from the results of a Select Query

    Here is a select query i have, SELECT Tame_cust.Rep_Name, sum (Case Tame_cust.hlp_benefits When 'No' Then 1 Else 0 End) As [ATP Leads], sum (Case Tame_cust.hlp_benefits When 'Child Tax Credit (less than £14200pa)' Then 1 When 'ATT Allowance' Then 1 When 'Disability living Allowance' Then 1...
  12. mattm31

    SQL Mail Help 2005

    Hi Not sure if this is possiable but i want to run a query and then dump the results into the main body of an email. I know you can do it with an attachment but i'd prefer not to do it that way. Thanks Matt
  13. mattm31

    Office Display screens

    Not sure if i'm posting in the right forum but i've been asked to setup for screens around our building displaying the same information from a single PC. Has anyone set this up that can give me a few pointers on whats the best kit to use. Thanks Matt
  14. mattm31

    SBS 2003 Standard & Exchange

    Hi we have a SBS 2003 Standard server installed and from what i've seen i belive this comes with Exchange 2003 but i can't find anywhere to install it. Does anyone have any ideas. Thanks Matt
  15. mattm31

    Add new Column with Autonumber

    Hi I have a SQL 2000 table with around 50,000 records, I have been asked if we can add a Auto Number to any new records added. I have added a int Data Type column which works fine but i have now been told that it needs to be 8 digits so starting at 00000001. Not sure how to do this if anyone...
  16. mattm31

    Spliting Column Help

    I think this is quite straight forward but i still can't figure it out. the first thing i want to do is copy everything before the first space from Field1 to Field2 and then everything before the first , from field1 to field3 ie Field1 The Dogs, Nuts Field2 The Field3 The Dogs
  17. mattm31

    Converting to Access from SQL

    i have this code that i've compiled in SQL and it works fine. But i have now been told the webpage its been written for is using an Access db and not SQL. Can someone give me some pointers on what code i need to change to get it working with Access & Frontpage. Thanks Select a.Team...
  18. mattm31

    Union Query Help

    A friend has asked me if i can automate his Cricket league table, I've had a go but am not familiar with running Union querys. I've got this far upto now. SELECT Team_list.Team AS Team, Count(LCL.home_team)AS [HP], Sum(Case LCL.home_points When '5' Then 1 Else 0 END)AS [HW 5], Sum(Case...
  19. mattm31

    Change Route Help

    We have a dialler connected to our Option 11 using a QSig link. At the moment if i dial 3999 it connects me to channel 21 or channel 22 (Which every is free) on the QSig link. I now need to change this to connect to Channel 27. Is this something quite simple that i can do myself ? and can...
  20. mattm31

    Looking for Info

    I looking for some help on the following things.. Does anyone have a templete for the keys on the M3820 phones that i could have ? Also is there anyway to get Meridian mail to kick in on busy instead of just when my phones on forward ? Thanks Matt

Part and Inventory Search

Back
Top