Search results for query: *

Hi everyone, this is my code: SELECT CDDEBITEUR, INVOICENR FROM DEBINVOICE WHERE INVOICENR > & lngInvoiceNr & ORDER BY INVOICENR InvoiceNr is something like 05003456 or 55763243 (so either it starts with a zero or it doesn't) Suppose lngInvoiceNr = 05003456 Because I converted it to int...

I get a run time error -2147217913 (80040e07) when executing this statement: strUpdate = "INSERT INTO Related_Entries (Related_To_Id," & _ "Related_To_Number,Related_From_Id," & _ "Related_From_Number,""Desc"") " & _ "VALUES ('" & objMaxRec.GetFieldValue("IDentification") & "'," & _ "'" &...

Hi everyone, I'm trying to set the columnheaders for my Microsoft Hierachial Flexgrid control in VB6. This is the code but I don't get any column headers: With mshfCompanies .ColWidth(7) = 0 .ColWidth(8) = 0 .ColHeader(0) = "Company" .ColHeader(1) = "Address"...

Hi everyone, when I launch my app I get this runtime error: runtime error '-2147217900 (80040e14)' ODBC syntax error This is the select command: SELECT re.desc, c.Name as Company FROM Client c, Related_Entries re WHERE re.Related_From_Id = '" & strID & "' ORDER BY c.Name; If I leave re.desc...

Hi there, depending on the data in a datagrid's row, that row must have a specific backcolor. How to do this? By this code, I check the data, now I only need to set the backcolor for that row. I hope someone can help, it's pretty urgent. Many thanks already. Cheers, Ruben.