Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.38 seconds.

  1. Re: Stuck with this Language Detection Service code

    My guess is the last Parameter "bag"
    You've declared ByRef As Any, and i just don't like it.
    The original expects a Pointer to the Structure
    Have you tried ByVal VarPtr(Bag)?
    Yes, i know, ByRef...
  2. MsOf10 Re: Absolutely bizarre workbook behavior

    Set Breakpoints in the 3 functions in module2, and ran "test"
    Cannot confirm!
    It's not entering the functions.
    Adding a sheet doesn't fire the code, but deleting it!

    At a guess: When deleting,...
  3. Replies
    6
    Views
    378

    Re: MS Access Database Engine 2010 problem

    What the others said, adding: Yes, put Access where it belongs: in the rubbish bin.
    I moved to SQLite some years ago, and never looked back, albeit SQLite has its own pitfalls, but none where you...
  4. Re: Pass a list of integers to stored procedure and perform insert on each

    https://stackoverflow.com/questions/10914576/t-sql-split-string
  5. Re: Pass a list of integers to stored procedure and perform insert on each

    Here is an example how to INSERT with a loop. Just put the loop-logic in your SP
    https://www.sqlshack.com/sql-while-loop-understanding-while-loops-in-sql-server/
  6. Re: Pass a list of integers to stored procedure and perform insert on each

    I think the "easiest" way would be to concatenate/join the integers into a string (1 2 3 4 5 becomes '1,2,3,4,5', comma delimiter) so you actually pass a single string into the SP.
    Inside the SP you...
  7. Re: Pass a list of integers to stored procedure and perform insert on each

    https://stackoverflow.com/questions/11102358/how-to-pass-an-array-into-a-sql-server-stored-procedure
  8. Re: Pass a list of integers to stored procedure and perform insert on each

    Which DBMS?
  9. Re: (Excel)____ VarType returning "wrong" result !

    Quick and dirty workaround:


    Function MyVarType(ByRef v As Variant) As VbVarType
    If TypeOf v Is Object Then
    MyVarType = vbObject
    Else
    MyVarType = VarType(v)
    End...
  10. Re: (Excel)____ VarType returning "wrong" result !

    All the others don't have a default-property?

    I just did a


    Sub main()
    Debug.Print Application
    End Sub

    'Prints "Microsoft Excel"
  11. Re: Making VB software in WINE in 32-bit linux that works with 64-bit windows 10

    Or use FreePascal/Lazarus.
    Develop natively on Linux, choose Target (Windows), hit compile, move exe to Windows-Computer, run
  12. Re: [RESOLVED] Form Saved as PDF in another folder

    Oh dear, and the fun starts, if the Window ("Form") has differing dimensions than A4/Letter......
  13. Re: (Excel)____ VarType returning "wrong" result !

    From: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/vartype-function
  14. Replies
    24
    Views
    807

    Re: VB6 Won't Update mdb database

    OK, the only thing left:
    Please test on the server moving the App and mdb-file to a another (public?) folder, where access-rights are on "full access" (or whatever it's called), and test there.
    If...
  15. Replies
    24
    Views
    807

    Re: VB6 Won't Update mdb database

    Leo, doesn't explain his statement, why it worked on XP, since his client is written in VB6.

    What i just noticed: He said that he moved the app to the server, too, and that it runs there.
    My...
  16. Replies
    40
    Views
    1,025

    Re: Reading Proficiency and Programming

    They should rename it to "Skynet".......or "The Architect" (Would there be an "Oracle"? Oh, wait. That one exists already......)
  17. Re: VB6 QUESTION: Code for reading ICNS file types from Mac?

    Like this?
    https://icns.sourceforge.io/
  18. Replies
    24
    Views
    807

    Re: VB6 Won't Update mdb database

    I wasn't talking about write-protected (in this Property-Tab of the File-Properties)
    I'm talking about access-rights to the Folder/File (In that Property-Window on Tab Security or whatever it's...
  19. Replies
    40
    Views
    1,025

    Re: Reading Proficiency and Programming

    Never been to Missouri. I'll take your word for it :D

    The thing is: As an instructor i find myself sometimes in situations, where i have to explain something, a process, a concept, some logic...
  20. Replies
    40
    Views
    1,025

    Re: Reading Proficiency and Programming

    Not having read it, but seeing the title, i'd guess that paper is from the late 90's (1999?) since it "projects" to 2006.

    To the question: The problem is the amount of crappy "tutorials" out...
  21. Replies
    40
    Views
    1,025

    Re: Reading Proficiency and Programming

    Thx dilettante for condensing it down.
    I admit i haven't read the links/articles, but it actually reflects my own experiences regarding "literacy" i see in other people
  22. Replies
    40
    Views
    1,025

    Re: Reading Proficiency and Programming

    Some 20 years ago, i had a chat with a guy in a bar.
    Turned out he was the "commercial competence" of a software-company (in the late 90's in Germany it was a big company selling ready-made...
  23. Replies
    3
    Views
    170

    Re: getting audio from webpage to server

    Err.......What now?

    Webbrowser/page to App ("Grab YouTube to App") or

    App To WebBrowser/Page ("Grab local file and forward it to Webpage")
  24. Replies
    24
    Views
    807

    Re: VB6 Won't Update mdb database

    Do you have an On Error Resume Next beforehand?
    Since you said it worked on XP, but not on 2012 i'm guessing write-access issues with the folder the mdb-file is placed in
    Check your rights on that...
  25. Re: Form Saved as PDF in another folder

    Or got confused with terms and definitions (and confused everyone else here)
  26. Replies
    24
    Views
    807

    Re: VB6 Won't Update mdb database

    At a guess: Somewhere is an OERN masking the actual error (probably write-access rights)

    EDIT: Just found something
  27. Replies
    10
    Views
    426

    Re: About RC6.cDataSource

    Whatever for?

    Or am i thinking in a too complicated way?


    If oDS Is Nothing Then .....
  28. Replies
    16
    Views
    593

    Re: Volume Control

    Or just a Picturebox, depending on where inside the PB you clicked, you paint that VLC-Triangle-Thingy adjusting the Volume at the same time
  29. Replies
    9
    Views
    415

    Re: COMBOBOX adn tooltip text

    I can't since i don't have/use vb6 anymore (except VBA in Office).

    That Link above: Read LaVolpes advice (Post 4), and try to find the codebank-entry westconn mentioned
  30. Replies
    9
    Views
    415

    Re: COMBOBOX adn tooltip text

    I'm not following any particular club or league, but i do like the championships (World and European).
    Ah well, my team (Croatia) got eliminated against Spain, so there:
    Job well done!
  31. Replies
    9
    Views
    415

    Re: COMBOBOX adn tooltip text

    Look here?
    https://www.vbforums.com/showthread.php?501428-RESOLVED-combobox-with-tooltips-for-each-item

    Oh, and Luca: Congratulations to Italy for reaching the EURO-Final.
    Forza Azzuri!
  32. Re: RC6 SQLite - how to store/read a LONG-Array?

    Olaf, that obviously only works if both Arrays have LBound=0
    And no, i'm not going to start a Jihad, if an Array always starts at zero or somewhere else.... :D
  33. Re: Can VB simulate the struct of C language?

    I'll take your word for it.
    Never had a Mother-in-Law......
    *BlessingMyLuck*
    :D
  34. Re: Can VB simulate the struct of C language?

    Trying to achieve that in Visual Basic is like trying to tighten a screw with a pair of tongs: It's the wrong tool

    Yes, you might be able to achieve that, but only after jumping through burning...
  35. Re: Can VB simulate all pointer operations in C language?

    In theory i should be a millionaire......

    I quote Bruce McKinney from his "Hardcore Visual Basic"-Bible:
    There is only one thing you can do with a pointer: Pass it to the Windows-API

    If you...
  36. Re: Can VB simulate all pointer operations in C language?

    No!...
  37. Re: RC6 SQLite - how to store/read a LONG-Array?

    CopyMemory ByVal VarPtr(LArray(0)), ByVal VarPtr(bArr(0)), (UBound(bArr) + 1) * LenB(bArr(0))

    EDIT: Err....Olaf.
    Please look at your Size-Field in CopyMemory..... that doesn't look correct
    ...
  38. Re: RC6 SQLite - how to store/read a LONG-Array?

    You mean like (Aircode):


    AddressOfFirstMember=VarPtr(MyLongArray(LBound(MyLongArray)))

    and

    ByteLen=(UBound(MyLongArray)-LBound(MyLongArray)+1)*LenB(MyLongArray(LBound(MyLongArray)))
  39. Re: RC6 SQLite - how to store/read a LONG-Array?

    Should be possible, since a Long-Array is basically just a consecutive memory-block like a byte-array,
    which you can even map to one another

    Quick Test in Excel-VBA (Don't have VB6), ignoring...
  40. Replies
    9
    Views
    514

    Re: Routine needs fixing

    There is!
    FindFirstFile and its sisters
    I remember writing something like that in the Office-Forum here some years ago.
    Nota bene: My Code (IIRC) as well as yours doesn't account for Access-Rights...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width