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!

Recent content by Transcend

  1. Transcend

    Command Line Argument

    Console.Readline should let you give input. Transcend
  2. Transcend

    new vs override

    This link helps answer the question. http://blogs.msdn.com/csharpfaq/archive/2004/03/12/88453.aspx Transcend
  3. Transcend

    Read only error with VB6 and MSDE

    Could the MSDE database have become corrupted? Transcend [gorgeous]
  4. Transcend

    Do I need to Pause this?

    I don't think that is the case, your stored procedure is simply not returning any values to your recordset. Instead of this With cmd .ActiveConnection = strCn .CommandType = adCmdStoredProc .CommandText = "DISCREPANT_WIP_SUMMARY_TSR" .Parameters.Append...
  5. Transcend

    Do I need to Pause this?

    Could you explain a little more what it is you are trying to do? Do you have some code that doesn't work? You shouldn't need to pause anything if you are just manipulating and then loading some data ... Transcend [gorgeous]
  6. Transcend

    SUM function on a predicated YES/NO column

    btturner ... I don't think (but I could be wrong) that Access supports CASE statements. If you look closely at the CASE statement in SQLBill's post you may realise it is posted as a signature, and one which indicates that you have posted in the wrong forum. Transcend [gorgeous]
  7. Transcend

    Sum Field from Recordset

    Is the field called qtd?? if so you should do this QtdTotal = QtdTotal + VendaTable.Recordset.Fields("qtd") If this isn't the problem, then chances are that QtdTotal and the field qtd are different data types. What data type is QtdTotal? And what datatype is qtd in your database? Transcend...
  8. Transcend

    I need help Bolding the text for a MsgBox in VB6.

    Sorry about the spelling of labels .. I was in a hurry! Transcend [gorgeous]
  9. Transcend

    I need help Bolding the text for a MsgBox in VB6.

    I don't think you can in a message box - but you can create your own message box with a form and a couple of lables. Transcend [gorgeous]
  10. Transcend

    access database password

    This example uses sendkeys http://www.vbcity.com/forums/topic.asp?tid=21314&highlight=running%7Caccess%7Creport I don't know of another way with the access object but you could use ADO to connect which will usw the password in the connection string. Transcend [gorgeous]
  11. Transcend

    INSERT INTO Crashes with Apostrophe

    Glad to help :) Transcend [gorgeous]
  12. Transcend

    INSERT INTO Crashes with Apostrophe

    Does this work without apostrophes?? I just realised that you have quotes in your sql so you might be better off doing g_sSQL = "INSERT INTO tblRequests (sSurname, sInitials,sNino,bFromCCC, sRequested" & _ ",sAddress, sDetails, sFrom, dSent,dImported)" & _...
  13. Transcend

    INSERT INTO Crashes with Apostrophe

    So what error do you get? Transcend [gorgeous]
  14. Transcend

    registry get and save data to keys

    Does this thread help? thread222-909248 Do a search for 'Registry' in the search function here there were a few results. Transcend [gorgeous]
  15. Transcend

    INSERT INTO Crashes with Apostrophe

    You need to replace ' with '' g_sSQL = "INSERT INTO tblRequests (sSurname, sInitials,sNino,bFromCCC, sRequested" & _ ",sAddress, sDetails, sFrom, dSent,dImported)" & _ "VALUES('" & Field_Arr(0) & "','" & Field_Arr(1) & "','" & Field_Arr(2) & "'" & _...
See more

Part and Inventory Search

Back
Top