Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.36 seconds.

  1. Replies
    14
    Views
    370

    Re: FileCopy to Linux server

    I would be very surprised if you cannot access that Linux-Box via UNC-Path

    What i learned in my now 4 years of fiddling around with *Nix'es:
    1) If you want to access a Unix-Folder from "outside"...
  2. Replies
    5
    Views
    243

    Re: How to test if a font is available

    Maybe this helps: https://www.vbforums.com/showthread.php?847733-VB6-Parse-Font-Name-from-TTF-File-Data
  3. Replies
    28
    Views
    1,531

    Re: Crossword Generator?

    Not really. Never was an avid "Crossworder", so i wouldn't even know the rules implied there.
  4. Replies
    28
    Views
    1,531

    Re: Crossword Generator?

    Yeah, saw those, too, but .... "Racketing"? Seriously?? *lol*

    EDIT: Ahhhh.... "Rendering"... at least i was close... *lol*
  5. Replies
    28
    Views
    1,531

    Re: Crossword Generator?

    14 across: "Brainstorming"
    :-)

    12 Down: wth is "Racketing"?? (For "Translation, a performance") --> would have tried "Rendition"
  6. Replies
    8
    Views
    358

    Re: Solar position calculator

    Elroy,
    see my link.
    Sun‘s „Altitude“ is expressed in degree (angle)
  7. Replies
    8
    Views
    358

    Re: Solar position calculator

    Sounds like trigonometry
    https://sciencing.com/calculate-solar-insolation-8435082.html

    btw: I looked at the provided class.
    Is it just me or is the MonthLeap-Array wrong?
    For February it says...
  8. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    Exactly what i and pete were telling you
  9. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    Exactly what i was alluding to.
    The OP says his code jumps to the error-handler, meaning the error itself (renaming missing worksheet) is not the cause for the Lock-up.
    He closes his WB (and...
  10. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    When you close your Workbook --> with or without saving changes (if the WB is "dirty")?
  11. Re: [RESOLVED] Closing Excel Worksheet after completing VB6 Process

    Since oXL is an Excel.Application-Object, have you tried

    oXL.Quit
    Set oXL=Nothing

    btw: You should use
    wb.Close SaveChanges:=True
  12. Re: Excel vba, find sheet with variable condition

    Must be WB1.
    Everything else agreed!
  13. Replies
    18
    Views
    467

    Re: Mostly Merging Multiple Tables

    Why would you think, Merge only works in a SP?

    https://www.hackdeploy.com/how-to-run-a-sql-server-upsert-using-merge/
  14. Replies
    7
    Views
    303

    Re: 2 Dimensional Array

    Thirded!
  15. Replies
    7
    Views
    303

    Re: 2 Dimensional Array

    seriously????
  16. Re: [RESOLVED] help with mssql query to return top five selling products by date

    Your Problem is that you're not aggregating the fields and you're using unique-per-row fields in your Output (e.g. InvoiceNo)
  17. Replies
    2
    Views
    198

    Re: Dynamic Array Size

    Only without preserving content.
    If you want to keep the content of the array (Keyword Preserve) only last dimension is dynamic
  18. Replies
    7
    Views
    303

    Re: 2 Dimensional Array

    https://visualbasic.happycodings.com/applications-vba/code30.html
  19. Replies
    11
    Views
    402

    Re: max size of binary files to split

    Why not use an ADO-Stream-Object (Put DAO where it belongs: The garbage-heap)?
    And use LONGBINARY instead of Memo --> http://allenbrowne.com/ser-49.html
  20. Re: Marking an excel file with a key from system

    Why not use the Keyword-Property of the Workbook?
    Go to File-Explorer, choose a xlsx-file, right-click on it, go to Properties, go to Details
    There you'll find different Properties (Author, Title,...
  21. Re: [Word] suggestings for optimizing my macro that uses Application.CompareDocuments

    Have you thought about using a Diff-Tool?
    https://www.git-tower.com/blog/diff-tools-windows/
  22. Re: Calling function of Exe project in referenced aticvex project in vb6

    One approach not mentioned up until now is DDE

    And that one definitely works with an ActiveX-exe
  23. Replies
    28
    Views
    1,065

    Re: [RESOLVED] Need help from Olaf

    Olaf,
    yeah found that out researching this.
    just looked weird to me.
    but there shouldn’t be any difference including the field you group by in the select
  24. Replies
    28
    Views
    1,065

    Re: [RESOLVED] Need help from Olaf

    Yes, i missed a closing paranthesis

    Remove the "MyDate" from the Inner Subselect and add a GROUP BY-Clause.
    See Olaf's Answer
  25. Re: Calling function of Exe project in referenced aticvex project in vb6

    With the caveat, that you have to use an object-module to declare your subscriber "WithEvents" (maybe instead of a bas-module one of those "global" autoinstantiated classes which in a way behave like...
  26. Replies
    28
    Views
    1,065

    Re: [RESOLVED] Need help from Olaf

    *facepalm*

    I'm embarrassed :D

    BTW: How can you GROUP BY by a Non-Output-Column?

    OOPS, Olaf left out two Columns in the inner SQL: PID and MyDate
    And leaving MyDate out of it when there is...
  27. Replies
    28
    Views
    1,065

    Re: [RESOLVED] Need help from Olaf

    wqweto,

    all true. I wrote that he appears to be wanting to use parameters, though in a way which basically results in concatenation.
    In that case he can leave out the Replace-Juggling and concat...
  28. Replies
    28
    Views
    1,065

    Re: [RESOLVED] Need help from Olaf

    Just noticed that i stepped into the single-quote trap


    'Somewhere in a Bas-Module
    Public Function SQ(ByVal AString As String, Optional ByVal RemoveEmbedded As Boolean = True) As String
    If...
  29. Replies
    28
    Views
    1,065

    Re: [RESOLVED] Need help from Olaf

    OK, must have missed that it's SQLite.
    Yeah, in that case it's basically your only option to compare string-wise
  30. Replies
    28
    Views
    1,065

    Re: [RESOLVED] Need help from Olaf

    because your SQL-String is faulty

    You start the String with 2 Replace-Function-Calls, meaning the last 2 characters of that line have to be 2 closing paranthesis'
    But the last thing in that line...
  31. Replies
    33
    Views
    1,100

    Re: copying from List Box to Text box

    Copy To Clipboard: https://www.vbforums.com/showthread.php?738057-copy-the-content-of-the-textbox-to-the-clipboard
  32. Thread: TwinBasic

    by Zvoni
    Replies
    862
    Views
    282,368

    Re: TwinBasic

    FPC = Free Pascal Compiler
  33. Replies
    40
    Views
    1,475

    Re: MsgBox font properties

    FWIW, a "Static"-Control (probably in C++) is what we usually call a "Label"-Control in vb6
  34. Re: Calling function of Exe project in referenced aticvex project in vb6

    *Sigh*
    and if you look at the StackOverflow-Link i posted in #4 you would have seen, that it's the same User-Name, the same text as in opening Post,
    AND THAT HE RECEIVED ANSWERS 6 Days ago

    So...
  35. Re: Calling function of Exe project in referenced aticvex project in vb6

    Niya,
    take a look at the StackOverflow-Link in Post #4 ....
    .... illuminating... *g*
  36. Re: Calling function of Exe project in referenced aticvex project in vb6

    Ah, i see where i got confused
    You actually want to call a function in the EXE "B" from your DLL "A"
    Easiest way: in your DLL "A" raise an Event which you catch in your EXE "B"
    Aircode


    'In...
  37. Thread: TwinBasic

    by Zvoni
    Replies
    862
    Views
    282,368

    Re: TwinBasic

    I know i'm contradicting myself (since i said i'm out of this discussion), but PD responded directly to my post, and i respect PD for his skills and opinion.

    PD, everything true you said, but in...
  38. Re: Calling function of Exe project in referenced aticvex project in vb6

    IIRC, you can only call Class-Methods from "outside", but i might be wrong. been a long time for me
    You can define a Class as "Global" (or some such thing), and from outside it would look like a...
  39. Thread: TwinBasic

    by Zvoni
    Replies
    862
    Views
    282,368

    Re: TwinBasic

    Ah, Ed.
    has nothing to do with you.
    I respect opinions of others (even if i don't agree with them), and i'm definitely not offended, if someone disagrees with me, as long as he/she can provide...
  40. Replies
    16
    Views
    594

    Re: Extract Text from PDF

    Olaf,
    still testing, though i'll probably switch to pdftotext (instead of pdftoHTML), since i want to grab plain text.
    I'm just running tests with it (incl. the different output-layouts), firing it...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width