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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SteveMac32

  1. SteveMac32

    Load Combo via .ItemData

    Hi Guys I ended up making a procedure out of the original loop and called it when I had a combo that needed to be set. thanks for all the input. Steve
  2. SteveMac32

    Load Combo via .ItemData

    Hi Guys I am loading a combo box With cboSalesCallReason .Clear Do Until rs.EOF .AddItem Trim(rs!CallReason) .ItemData(.NewIndex) = rs!URN rs.MoveNext Loop End With I need to set the combo box depending on the .ItemData (the URN)...
  3. SteveMac32

    IGNORE_DUP_KEY return message

    Hi Joe Thats exactly what I did as it looks like you cannot suppress messages well with sql2000. Thanks also gmmastros bit it is easier and quicker to do in vb, like your solution though. Steve
  4. SteveMac32

    IGNORE_DUP_KEY return message

    Thanks Emtucifor but I am afraid that SET NOCOUNT ON does not work in this case, I thought that NOCOUNT returned or not the number of rows affected by statement and did not suppress other messages. I have had to come up with a solution using the calling VB application.
  5. SteveMac32

    IGNORE_DUP_KEY return message

    I am running a stored procedure which populates a table and has a IGNORE_DUP_KEY and a clustered index on it I am getting the message that "Duplicate key was ignored" which creates an error in the calling VB program Can this be suppressed or changed somehow? I have tried a number of things...
  6. SteveMac32

    INET control SFTP wont get files

    oops sorry I have amended the Put to: .Execute , "put \\global\Files\Exports\Temp_ExportData\ExportTest.txt [b]ExportTest.txt[\b]"
  7. SteveMac32

    INET control SFTP wont get files

    Hi all sorry I need to raise this up again I am now connecting to a FTP not SFTP so i just need a sanity check on the above code, I know its correct well I think i do, Would you agree? If this code is correct it means I can move on and look for the problem elsewhere because when I run either...
  8. SteveMac32

    INET control SFTP wont get files

    Thanks that answers a lot of questions….
  9. SteveMac32

    INET control SFTP wont get files

    Hi all really hope you can help me out here.. I know Inet is not the best but this is protocols they use and they won’t let me change them... That said I have been working on this for hours and about to give up, if only I could, I can’t seem to get or put files onto the sFTP site even though I...
  10. SteveMac32

    Strange Timeout expired error

    Yea sure did, there arnt any only a few default values.
  11. SteveMac32

    Strange Timeout expired error

    Hi Thanks for the info I have tried them all in QA it runs fine I think you may be correct in the server timeout as it actually runs on two tables on one it works on the other it does not. Both tables are the same except for the data held in them. The full error message is Run-time error...
  12. SteveMac32

    Strange Timeout expired error

    My VB6 program calls a stored procedure (SQL server 2000) that runs the code outlined below CREATE PROCEDURE [spExportResetDNP] @TableName as varchar(50) AS Declare @SQL as varchar(250) Set @SQL = 'UPDATE ' + @TableName + ' SET ExpProcess = Null Where ExpProcess = 1' Exec (@SQL)...
  13. SteveMac32

    Listview finding selected row number

    Thanks Guys That was the road i was going down but i keep getting these errors: vwData.ListItems.SelectedItem.Index ‘Method or data member not found’ on SelectedItem vwData.ListItems.Item.SubItems(17) ‘Argument not optional’ on Item thought i must have some strange property values but...
  14. SteveMac32

    Listview finding selected row number

    Hi all This is/should be a simple one but for some reason I just can’t get it, I think my brain has gone for a long walk. I load the listview from a recordset and when the user clicks on a row I want to be able to look in a particular element and if that element holds a true value we can then...
  15. SteveMac32

    Trap the Tab Key

    I Guys, thanks for all your answers and help some really interesting ones in there. Unfortunately I made a school boy error in actually believing what my client was saying, doh!!!!! Strongm thanks you turned the light on and was correct in saying “Erm, I'm slightly confused. A TAB char should...
See more

Part and Inventory Search

Back
Top