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 Chriss Miller 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: patrichek
  • Content: Threads
  • Order by date
  1. patrichek

    make second line default for outbound

    Hi all, Could some one guide me how to make my IPCC (2nd line) the default line for outgoing calls. When i pick up my handset i want to get the dial tone from line 2 without having to manually switch lines. we're on call manager 6.1 and using 7941 and 45s. Thanks
  2. patrichek

    testing call routing

    Hi, Can someone give some insight on a good way to test our cisco IPT? To put a load on the system, right now we are doing it manually by gathering a bunch of people and everyone calling in at the same time. What we're looking for is holes in the system, whether it be human or computer error...
  3. patrichek

    problem with voicemail calling receptionists

    Hi all, We are experiencing several strange issues: 1. our receptionists randomly receive calls from their voicemail. (only our receptionists who are in a hunt group) 2. Sometimes the receptionists are on a call with a customer and it drops the call and goes straight to the receptionist...
  4. patrichek

    cisco vs. avaya vs. siemens

    Hi everyone, My company is currently struggling with this dilemma. We have 150 employees and expect to double that in a years time and open an additional office on the west coast. We do not have an opinion on IP vs. PBX and struggle to understand which is better? Our budget is not really an...
  5. patrichek

    Best place to install MS SQL 2005

    Hello everyone, I need a bit of advice. I will be installing MS SQL 2005 standard edition on a dual xeon 3ghz, 600gb hd raid 5, 60 gb raid 1, 4gb ram poweredge server that is already running exchange 2003 on windows 2003 standard edition. We have approximately 130 users who use the mail and 75...
  6. patrichek

    best place for page file

    hi, i have a w2k3 server running exchange and ms sql 2005 (soon)on a poweredge 2950 with raid 1 (OS) and raid 5 (exchange db). What is the best place for the page file? THe system has dual xeon 3ghz processors and 4gb ram. I will have about 100 users hitting this box. Thanks in advance
  7. patrichek

    IP routing by server help

    Hi All, I have 2 nics on a win 2k3 server and would like to use the server to route traffic between 2 subnets; 192.168.1.0 and 192.168.2.0 Server nic1 ip 192.168.1.240 sm 255.255.255.0 d/g blank Server nic2 ip 192.168.2.2 sm 255.255.255.0 d/g 192.168.2.1 trying to ping 192.168.1.x from my...
  8. patrichek

    IP routing by server help

    Hi All, I have 2 nics on one win 2k3 server and would like to route traffic between 192.168.1.0 and 192.168.2.0 Server nic1 ip 192.168.1.240 sm 255.255.255.0 d/g blank Server nic2 ip 192.168.2.2 sm 255.255.255.0 d/g 192.168.2.1 trying to ping 192.168.1.x from my laptop does not work, my...
  9. patrichek

    route traffic between 2 subnets windows 2003 server

    Hi All, I have 2 nics on one win 2k3 server and would like to route traffic between 192.168.1.0 and 192.168.2.0 nic1 ip 192.168.1.240 sm 255.255.255.0 d/g blank nic2 ip 192.168.2.2 sm 255.255.255.0 d/g 192.168.2.1 from my laptop my ip: 192.168.2.10 sm 255.255.255.0 d/g 192.168.2.1 I'm...
  10. patrichek

    delete records after running query

    Hi, I'm working on a database for lead distribution. I'm importing leads into a table then using queries to distribute them among our sales staff. Is there a way to query records from my leads table and then delete those records from that table? thanks!
  11. patrichek

    Microsoft office can't open the mail session

    Hi, i'm getting this error when trying to use sendobject and outlook express on windows server 2003 with exchange 03 installed on it. I've been researching the problem and I'm unable to find a solution. I've also installed outlook on the server and tried using it as the default mail client but i...
  12. patrichek

    Microsoft office can't open the mail session

    Hi, i'm getting this error when trying to use sendobject and outlook express on windows server 2003 with exchange 03 installed on it. I've been researching the problem and I'm unable to find a solution. I'm in the process of moving my database to a new server and this has become a snag in the...
  13. patrichek

    best way to archive old records?

    Hi all, I'd like ideas on how to archive records older than 1 year but still make them accessible. We are having speed issues. I thought about making an empty copy of my database and starting from scratch but thought there must be a better way than having 2 databases (one archive and one new)...
  14. patrichek

    how to exclude negative currency in query

    Hi Guys, can you help me figure out how to keep a negative currency out of my query? I've tried not like "(*" in the trantypetotal1 but it still returns the negative values. here's my sql: SELECT dbo_TranTotalsMaster.TranAccountNumber, dbo_TranTotalsMaster.TranTypeTotal1...
  15. patrichek

    sending data between worksheets?

    Hi, I have a spreadsheet with usually around 100 leads a day in it. I have 20 sales people i distribute the leads to every morning. Is there a way for me to add 20 worksheets to my spreadsheet and distributed the leads evenly among the sales staff? Each new worksheet would represent a sales...
  16. patrichek

    undefined function error in query

    Hi All, i borrowed and slightly modified one of PHV's functions and now I can't get it to run in an update query. Here's the code for the function: Public Function getPhoneNum(strPhone) Dim i As Integer, x As String, s As String If Len(Trim(Nz(strPhone, ""))) = 0 Then Exit Function For i = 1...
  17. patrichek

    parsing data from queries, is this possible?

    Hi, I am trying to devise a way to take a spreadsheet that we receive daily, containing the day's leads, which is then sorted and distributed according to certain column's variables. I have no problem linking the spreadsheet to access, but I don't know which query functions to try in order to...
  18. patrichek

    RRAS/VPN routing help.

    Hi all, I have a w2k3 server 2 nics, my ip scheme on nic 1: 192.168.1.250 255.255.255.0 192.168.1.1 nic2: 172.31.1.2 255.255.255.0 no gateway nic 1 has all PPTP WAN traffic forwarded from sonicwall router . In RRAS I have setup static ip range of 172.31.1.50-75 I can connect to my vpn thru...
  19. patrichek

    RRAS routing help

    Hi all, I have a w2k3 server 2 nics, my ip scheme on nic 1: 192.168.1.250 255.255.255.0 192.168.1.1 nic2: 172.31.1.2 255.255.255.0 no gateway nic 1 has all PPTP WAN traffic forwarded from sonicwall router . In RRAS I have setup static ip range of 172.31.1.50-75 I can connect to my vpn thru...
  20. patrichek

    normalizing phone number fields

    Hi, I need advice as to how to format my phone number field. Right now its not normalized. I have (nnn) nnn-nnnn, nnnnnnnnnn, nnn-nnn-nnnn, +nn-nnn-nnnn and so on... we get data from several different places and everyone seems to have a different way of inputting area codes and then throw in...

Part and Inventory Search

Back
Top