Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: split string help only few extracting

    I can help you tomorrow from my workplace (no VB at home)
  2. Re: split string help only few extracting

    Run through the array using do/loop until you hit first „GetHost“,
    next array-member is user hosting
    next array-member is game name
    next array-member is game description
    next array-member is...
  3. Re: split string help only few extracting

    Use my code in post 3, and ignore array-members you don’t need
    it‘s not rocket science
  4. Replies
    2
    Views
    119

    Re: How to totally clear a listbox

    From where are you calling it? From a Standard-Module?
    Fully qualify the ListBox? myForm.lstChars.Clear?
  5. Replies
    4
    Views
    149

    Re: Disappearing exe file!

    At a guess: Look in Settings for Include/Exclude Paths-Properties
  6. Replies
    4
    Views
    149

    Re: Disappearing exe file!

    Quarantined by AntiVir?
  7. Re: split string help only few extracting

    I think i understand


    Sub main()
    Dim s As String
    Dim t As String 'temp. String
    Dim d As String 'Delimiters
    Dim p As String 'Primary Delimiter
    Dim r As String 'remaining Delimiters
    Dim a()...
  8. Re: split string help only few extracting

    And your problem is?


    Sub main()
    Dim s As String
    Dim a() As String
    Dim i As Long
    s = "@dE%GetHost#@¥€¥€%@harris fna¥€%@men of...
  9. Re: vb6: save big data from textbox to txt file

    There is that, nevermind opening an existing (!) file for Output implies overwriting it, and maybe this is your time-penalty
    Maybe as a test: Open for Output to a different filename
  10. Re: vb6: save big data from textbox to txt file

    Well, not counting algorithm (Loops etc.) , IMO 95% of IO-File-Performance is due to Hardware, as in the "pure" read/write-operation.
    Like: SATA-HDD vs. SSD vs. NVMe
  11. Re: vb6: save big data from textbox to txt file

    It's probably your loop
    Untested


    Dim iFile As Integer
    Dim strAllDogs As String
    iFile = FreeFile
    Open App.Path & "\result.txt" For Input As #iFile
    strAllDogs = Input(LOF(iFile), iFile) ...
  12. Replies
    10
    Views
    223

    Re: Mysql Nested sub query

    Probably your best bet
  13. Re: vb6 database query sql contains like operator fail to work in Window 11?

    20,000 rows?
    that‘s ……. cute…..
  14. Replies
    10
    Views
    223

    Re: Mysql Nested sub query

    Got it without ROW_NUMBER

    SET @rn = 0;
    SET @ic ='';
    SELECT
    i.item_code,
    i.item_description,
    i.item_unit,
    ip.order_number,
    ip.order_date,
  15. Replies
    10
    Views
    223

    Re: Mysql Nested sub query

    Argg...and additionally i missed that ROW_NUMBER is only available in MySQL8 and later, not earlier.
    Damn!

    wqweto, OP's Problem is, that he wants to create a View for that Statement, and MySQL5.6...
  16. Replies
    10
    Views
    223

    Re: Mysql Nested sub query

    OUCH! Why such an old version?



    https://dev.mysql.com/doc/refman/5.6/en/create-view.html

    If i understand it correctly, with MySQL5.7 and newer you don't have that restriction, MySQL5.6 and...
  17. Replies
    10
    Views
    223

    Re: Mysql Nested sub query

    Returns:



    ABC01
    Item Number One
    Ea
    1238
    2022-07-09
    10.33
  18. Replies
    10
    Views
    223

    Re: Mysql Nested sub query

    Tested in SQLite (No MySQL at Hand).
    ROW_NUMBER might have a different Syntax on MySQL, but researching it couldn't find any difference
    SELECT
    i.item_code,
    i.item_description,
    ...
  19. Re: vb6 database query sql contains like operator fail to work in Window 11?

    From Post 10:


    Well then, as a last guess:: SELECT * FROM blablabla
    Do we know what he tries to pull in using "SELECT *"?
    Maybe some BLOB-Columns choking everything.
    It still wouldn't explain...
  20. Re: vb6 database query sql contains like operator fail to work in Window 11?

    Just saw it: Since when do you use single quotes in Jet-SQL?
  21. Re: vb6 database query sql contains like operator fail to work in Window 11?

    And since it's MS Access the wildcard should be "*" and not "%"
  22. Re: ActiveX dll's that reference each other

    How if he needs a Type provided by the "other" DLL?
    Or do you mean as a "dummy" (a.k.a. empty dll)?
  23. Re: ActiveX dll's that reference each other

    How if it cannot solve the dependency because the other dll is (still) not compiled?
  24. Re: ActiveX dll's that reference each other

    For me, THAT is close.... :-)
  25. Re: ActiveX dll's that reference each other

    Eh? So i was actually pretty close.....
  26. Re: ActiveX dll's that reference each other

    hmm....what about swapping out that "type" into a support-Ax-DLL, so both dll's can reference that type in that dll, and the second dll then only needs to reference the first one?
  27. Re: ActiveX dll's that reference each other

    Use latebinding?
  28. Replies
    16
    Views
    586

    Re: PrintCommunication COM error

    Go through the individual Settings in the PageSetup (comment them out one by one)
    I'm guessing, that you're trying to use a Setting your printer doesn't understand.

    OR: Have you checked your...
  29. Replies
    3
    Views
    389

    Re: [SQLite] How to use LIKE with IN

    hmm...
    I'll take your word for it, since i've never used EXISTS in that context (don't laugh, it's true),
    and IIRC, not all DBMS provide the EXISTS-Operator/Function. So i'm more used to use the...
  30. Replies
    3
    Views
    389

    [SQLite] How to use LIKE with IN

    Hi Folks,
    everyone knows the Problem trying to compare a column against multiple values with wildcards.
    This usually results in "constructs" like


    SELECT DISTINCT SomeTextField
    FROM Table...
  31. Re: [SQLite] How to get an Order within a GROUP_CONCAT

    I already quoted the SQLite-doc's, that there is an "arbitrary" Order for GROUP_CONCAT, though i also wrote my thoughts on it.

    Would have to disagree with your proposal.
    A CTE is basically a...
  32. Re: [SQLite] How to get an Order within a GROUP_CONCAT

    you're right :D
    It has to do with that i've started to explicitly select columns for JOINS, so call it personal preference
    (And yes, TID as Output-Column for the CTE is not necessary. It's a...
  33. Replies
    1
    Views
    304

    Re: VB6 can't show Office Help.

    Are you coding VBA inside Excel?
    because if yes, F1 refers to a Website, so if you don't have Internet-connection....
  34. [SQLite] How to get an Order within a GROUP_CONCAT

    In another Forum i helped out an User who was struggling with the following:
    He had a table "tbl_employee" and a table "tbl_task", which were connected in an "m:m"-scenario via "tbl_emp_task"

    He...
  35. Re: Project gets stuck when running on Apple computer

    Then the last thing coming to mind would be, if his Office is a "Pro" and if he can open the mdb in Access directly
  36. Re: Project gets stuck when running on Apple computer

    No, it's not.

    Is this even legal?
  37. Re: Project gets stuck when running on Apple computer

    Hmmm….. OP said he has Win10 on a separate partition of this (Apple) Harddrive.
    i‘m not familiar with Apple (APFS?) but maybe it‘s the harddisk-controller messing stuff up when trying to read/write...
  38. Re: Project gets stuck when running on Apple computer

    Check if "db1" is a valid (Database)-Object (in Watch-Window?). Maybe OpenDatabase fails and returns "Nothing"

    EDIT: Wait a sec. He has DAO and ADO referenced, but his "Dim rs1 As Recordset" is...
  39. Re: Project gets stuck when running on Apple computer

    Remember: he has an active Error-Handler
  40. Re: Project gets stuck when running on Apple computer

    That's DAO, definitely (as you can see in his References).
    But why he's referencing ADO too, escapes me.
    Next: Is Excel/Office installed on that VM? (I'm guessing he runs Win10 in a VM on the...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width