Recent content by Transcend

Console.Readline should let you give input. Transcend

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

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

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...

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]

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]

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...

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

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]

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]

Glad to help :) Transcend [gorgeous]

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)" & _...

So what error do you get? Transcend [gorgeous]

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

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) & "'" & _...