Recent content by RubenV

For i = lstItems2.ListCount - 1 To 0 Step -1 If lstItems2.List(i) = txtName.text Then i would be your listindex :)

This gives me the same error as described above. It's not about the join though, it only means my query contains an error. So basically, the driver I use to access the SQLBase database is just too limited to execute conversions etc... in a query.

I have found the solution. It's a rather dumb error I made but for some reason I managed not to see it. Guess I was just focussing on the wrong thing. Anyways, this works great and it's just two strings compared with eachother: "SELECT CDDEBITEUR, FACTNUMMER, FACTDATUM, VERVALDATUM1...

AMACycleLoony: I tried declaring as a Variant, but this had the same result. DrJavaJoe: What you say is correct indeed. Still, I'm stuck to resolve this... Because I considered invoice number being a string in the database, I used WHERE TO_NUMBER(INVOICENR) >" & lngInvoiceNr & But this gave...

Normally, I shouldn't convert to NUMBER because even if it's a string, the conversion would happen automatically because the string consists of nothing but numbers... So, I'm still having the issue with the preceding zero... I therefore eliminiated the possibility of fetching numbers starting...

actually, this is my full vb statement: strSearchFacturen = "SELECT CDDEBITEUR, FACTNUMMER, FACTDATUM, VERVALDATUM1, VERVALDATUM2, FACTBEDRAG, BEDRAGBTW " & _ "FROM DEBFACTUUR " & _ "WHERE TO_NUMBER(FACTNUMMER) > " & intSearchFrom & " " & _ "ORDER BY FACTNUMMER" I guess my quotes are placed...

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

fredericofonseca, no I didn't loop through it yet. Should I do like this ON ERROR GOTO (yourcode) .execute YOUR CODE The problem is solved now though. The problem was this: Related_.._Id is a string field Related_To_Number is a string field but for some very awkwardreason they set...

Sorry, just a small question. Where exactly should I post the error code?

THANKS fredericofonseca !!! I really appreciate your help and advice. I will dig into this immediately and I will let you guys know how it works out. Thanks again, Ruben.

Here is the debug.print but it's the same as the errormessage... I don't know if it was this you wanted me to do but here it is: INSERT INTO Related_Entries (Related_To_Id,Related_To_Number,Related_From_Id,Related_From_Number,"Desc") VALUES...

First of all, sorry guys for this perhaps uncomplete post. Please forgive me but I was interrupted at the time of writing this. Ok, I already did print out the messagebox but as I said, I got interrupted in writing this post. Here is further information, thanks for your patience. the...

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

Strange... I recreated the form, just copy pasted the components and the code and it worked... Just VB having a difficult time then?

Are you sure that the system dsn you're connecting with is still there?