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: *

  1. chester27

    Anyone seen this before? [img http

    Anyone seen this before?
  2. chester27

    Excel Macro to launch remote command

    100's of miles away. We only have RDp access, and is the only box with the application we want to call. I can do it using calls to batch files that use PsExec from Sysinternals, but this is not practical to place on 100's of PC's Just looking for maybe a function to call and execute the command...
  3. chester27

    Excel Macro to launch remote command

    Looking for help with creating a macro to launch a command or script on a remote server, and return success or fail.
  4. chester27

    Excel Macro

    Andy I thought I had, I only changed one line as it was more an oversight on my part, but just in case it is misread here it is. Sub ConCat() ' ' ConCat Macro ' ' Dim oWS As Worksheet, lLastRow As Long, r As Long Set oWS = ActiveSheet lLastRow = oWS.Cells.SpecialCells(xlLastCell).Row For r =...
  5. chester27

    Excel Macro

    Skip Yep my bad, "If Len(oWS.Cells(r, 4)) > 0 And Len(oWS.Cells(r, 5)) > 0 Then"..... should have read "If Len(oWS.Cells(r, 1)) > 0 And Len(oWS.Cells(r, 4)) > 0 Then...." All works a treat now Zelgar Do Until IsEmpty(Cells(oWS.Cells(r, 4)) ' Combine A to D keeps throwing a debug error but not...
  6. chester27

    Excel Macro

    Looking for some help or advice. Trying to create a Macro that will concatenate 4 columns A-D with a ~ separator in Column F. It needs to start in E2 and continue till empty cell in column D. I have tried the below so far but fails to continue past E3. Sub ConCat() ' ' ConCat Macro ' ' Dim...
  7. chester27

    Formula to VBA

    I am trying to reduce the processing time of a spreadsheet that contains the following formula. The constants need to remain constant but the rest will need to reflect the position in the worksheet e.g. as it would if the formula were copied across columns...
  8. chester27

    Site to Site VPN

    Keep getting this in the logs... The ASA discarded a TCP packet that has no associated connection in the ASA connection table. The ASA looks for a SYN flag in the packet, which indicates a request to establish a new connection. If the SYN flag is not set, and there is no existing connection, the...
  9. chester27

    Site to Site VPN

    We have a site to site vpn setup between a cisco asa 5505 and a checkpoint NG firewall. We can do all the normal browsing of networks etc, but when we try and use a cisco ip phone, it rings once then goes engaged. If we use the VPN desktop client we are able to use IP communicator ok and all...
  10. chester27

    SQL Datetime again

    All sorted, found a rouge entry, and used the set dateformat to dmy then used the convert(xxxxx, 120) thanks for all the help.
  11. chester27

    SQL Datetime again

    This is driving me mad. Now finding dates as 1991-11-23. All these dates are in a VarChar column and need to update them to datetime in the new column.
  12. chester27

    SQL Datetime again

    Sorry for the confusion in advance, have had a closer look and it seems that the datetime given is 23-12-1991 00:00:00 and I am trying to update this into a datetime column and change it to 23/12/1991 00:00:00. If I leave as 23-12-1991 00:00:00 it works in the DB but application expects the / so...
  13. chester27

    SQL Datetime again

    I have a holding table with imported data from an external source. All columns are set to Varchar(50). When I try and run a script that takes this data and populates the correct table I get "conversion failed when converting to datetime error" data in Varchar field reads 22/11/2008 00:00:00...
  14. chester27

    Citrix Session Printing

    Using Citrix default drivers and a Seagull driver for a label printer.
  15. chester27

    Citrix Session Printing

    We have 4 CTX servers in a farm and 70 clients. Each PC that connects has a policy that sets the printers in session. These printers are mapped through from local clients. Printing is extremely slow, and puts a strain on the CTX servers if more than 10 users connected. Servers are W2K3 SP2 with...
  16. chester27

    Insert Into

    Thanks all, C4 was not mentioned as I only want to merge data into a few columns C2. It's now sorted, slight typo, and a little more understanding around join.
  17. chester27

    Insert Into

    Getting Cannot insert the value NULL into column 'C4', table 'T1'; column does not allow nulls. INSERT fails.
  18. chester27

    Error 10855, Severity: 20, State: 1

    It's SQL 2005 and this was the fix, nothing to do with SQL as such.
  19. chester27

    Error 10855, Severity: 20, State: 1

    The application code refers to an interface Microsoft.XMLHTTP There are different versions of this interface in the different msmxl.dlls that are released by Microsoft the reference in the registry for this interface was: %SystemRoot%\Msxml.dll with a Progid of Microsoft.XMLHTTP.1 I had to...
  20. chester27

    Insert Into

    Hi I have 2 tables, and need to append one column in table 1 with another column from table 2 where a certain columnID is the same. Insert Into T1.C1 Select C2 from T2 WHERE T1.C3 = T2.C3 Getting could not be bound error? Any help please.

Part and Inventory Search

Back
Top