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

Search results for query: *

  1. RubenV

    Getting the listindex in a listbox

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

    int conversion gives SQL outer join requirement error

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

    int conversion gives SQL outer join requirement error

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

    int conversion gives SQL outer join requirement error

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

    int conversion gives SQL outer join requirement error

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

    int conversion gives SQL outer join requirement error

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

    int conversion gives SQL outer join requirement error

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

    Error in assignment on insert statement: 80040e07

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

    Error in assignment on insert statement: 80040e07

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

    Error in assignment on insert statement: 80040e07

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

    Error in assignment on insert statement: 80040e07

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

    Error in assignment on insert statement: 80040e07

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

    Error in assignment on insert statement: 80040e07

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

    Urgent: VB runtime error SQL

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

    Automation error

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

    Urgent: VB runtime error SQL

    I now get the same runtime error, but now even when just doing this: strQuery = "select * from client;" dcContacts.RecordSource = strQuery & adOpenDynamic & adLockOptimistic & adAsyncConnect & adAsyncExecute & adAsyncFetchNonBlocking dcContacts.Refresh Set dgContacts.DataSource = dcContacts I...
  17. RubenV

    Column headers in MSHFlexgrid

    yeah ok, that does the trick. Didn't think it was that easy :p Thanks for your reply mate.
  18. RubenV

    MouseWheel Scroll in FlexGrid

    Hmm, but there's some added code. Anyway, it might have been nice indeed but it's nice to say the least. Well, if you can use it.
  19. RubenV

    MouseWheel Scroll in FlexGrid

    This is a great tip and something very useful. I tested it very quickly and it's indeed very neat. Good job :)
  20. RubenV

    Column headers in MSHFlexgrid

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

Part and Inventory Search

Back
Top