Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.39 seconds.

  1. Replies
    6
    Views
    209

    Re: Solar position calculator

    Elroy,
    see my link.
    Sun‘s „Altitude“ is expressed in degree (angle)
  2. Replies
    6
    Views
    209

    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...
  3. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    Exactly what i and pete were telling you
  4. 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...
  5. 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")?
  6. 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
  7. Re: Excel vba, find sheet with variable condition

    Must be WB1.
    Everything else agreed!
  8. Replies
    18
    Views
    360

    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/
  9. Replies
    7
    Views
    252

    Re: 2 Dimensional Array

    Thirded!
  10. Replies
    7
    Views
    252

    Re: 2 Dimensional Array

    seriously????
  11. 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)
  12. Replies
    2
    Views
    157

    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
  13. Replies
    7
    Views
    252

    Re: 2 Dimensional Array

    https://visualbasic.happycodings.com/applications-vba/code30.html
  14. Replies
    11
    Views
    337

    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
  15. 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,...
  16. 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/
  17. 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
  18. Replies
    28
    Views
    1,029

    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
  19. Replies
    28
    Views
    1,029

    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
  20. 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...
  21. Replies
    28
    Views
    1,029

    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...
  22. Replies
    28
    Views
    1,029

    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...
  23. Replies
    28
    Views
    1,029

    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...
  24. Replies
    28
    Views
    1,029

    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
  25. Replies
    28
    Views
    1,029

    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...
  26. Replies
    33
    Views
    1,057

    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
  27. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,694

    Re: TwinBasic

    FPC = Free Pascal Compiler
  28. Replies
    40
    Views
    1,420

    Re: MsgBox font properties

    FWIW, a "Static"-Control (probably in C++) is what we usually call a "Label"-Control in vb6
  29. 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...
  30. 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*
  31. 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...
  32. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,694

    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...
  33. 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...
  34. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,694

    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...
  35. Replies
    16
    Views
    577

    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...
  36. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,694

    Re: TwinBasic

    Your point?
    If someone with such "own" syntax asks for support, he can get it in the "official basic" way.

    Would be the same as: "Why is my Function not working?" showing only the call to it, but...
  37. Replies
    16
    Views
    577

    Re: Extract Text from PDF

    Reporting back.
    Not exactly what i'm looking for. Yes, i can get stuff like MetaData, but not the actual content.
    At least it's a starting point.

    Thx anyway
  38. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,694

    Re: TwinBasic

    Baka, no need for an IDE setting or whatever.
    Since Wayne has already implemented those C-ish operators it's a fait accompli.
    No use to cry over spilt milk.

    TwinBasic offers NEW (intrinsic)...
  39. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,694

    Re: TwinBasic

    The Problem people have with "a = a + 1" in Basic, is that Basic has overloaded the "="-operator:
    Assignment AND equality/comparison
    Look at other languages
    a) Pascal: "=" equal - ":=" assign
    b)...
  40. Replies
    40
    Views
    1,420

    Re: MsgBox font properties

    Maybe here? https://www.vbforums.com/showthread.php?215392-MSGBOX-SETTING-FONT-SIZE-and-STYLE
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width