Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds; generated 29 minute(s) ago.

  1. Replies
    19
    Views
    343

    Re: GUID/CLSID/UUID Comparison API?

    Really?
    I was under the impression, only "Objects" (Classes) can have Properties
  2. Replies
    19
    Views
    343

    Re: GUID/CLSID/UUID Comparison API?

    Color me surprised.
    Since when can you do a
    Private Property Get in a BAS-Module?!?!?!
  3. Replies
    39
    Views
    1,529

    Re: new project - DB help needed please

    More or less my question, too.
    What defines which 4 cards to be a set?

    EDIT: Coming from a Poker-Cards-Deck:
    You need a qualifier which defines which cards belong to which set
    1) "i have all 4...
  4. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    OK, i did a Test with my Data, and added Adam Sandler to Physics with Steven Spielberg (duplicate Subject, but different teacher).
    Returns correct Sum

    Same with teacher.
    So no idea what you're...
  5. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    You do realize that in your post you’re talking about teachers, but the query is for students?
  6. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    not possible.
    how do you want to get the fully paid teachers, when you want the SUM across teachers?
    same with students.

    this will only work, if you ignore teachers/students to receive a total...
  7. Re: set timer for a excel spread sheet using a variable for the time value

    TimeValue expects a (quoted?) Time-String
  8. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    OK, got a few minutes to look at it

    Students

    The first query above returns this (for the Values i have)



    Student
    SubjectName
  9. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    Will be thursday, since i‘m traveling the next two days
  10. Re: Parsing a String to Obtain a Discontinuous Print Range

    Did you uncomment the green lines?
    And you have to pass a String-Variable as the second Argument (it's byref) for TokenizePages
  11. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    ?!?!?!?!


    WITH
    SC AS (SELECT SC.Class_ID, SUM(COALESCE(SC.Price, S.SubjectPrice)*SC.NumOfSessions) As TotalPrice,
    TS.TeacherPercentage, SUM(SC.NumOfSessions) As...
  12. Replies
    23
    Views
    537

    Re: [RESOLVED] Listview loop

    Uh.... wrong.....
    It's called a decision-tree.
    We do it pretty much every second/minute of our life

    "If it rains Then take Umbrella with me Else a Coat is enough"

    Computers (and in that way:...
  13. Replies
    23
    Views
    537

    Re: [RESOLVED] Listview loop

    How do you figure that????!?
  14. Re: Parsing a String to Obtain a Discontinuous Print Range

    well, in that case:
    you know what valid "input-characters" are: digits and "delimiters"
    e.g. you only want to support two valid delimiters: "-" and ","
    I'd probably throw the "input-String" at...
  15. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    WITH
    TR AS (SELECT SC.ID, SC.Student_ID, COALESCE(SC.Price, S.SubjectPrice) AS SubjectPrice,
    S.SName As SubjectName, TE.TName As TeacherName, SC.NumOfSessions,
    ...
  16. Re: Parsing a String to Obtain a Discontinuous Print Range

    I'll add to this:
    This would translate as "valid": 1-5,9-7 (Note 9 left of 7)

    But how to proceed from here?
    Print 1,2,3,4,5 (in that order), and then?
    print 9,8,7 or re-sort to 7,8,9?
    ...
  17. Replies
    23
    Views
    537

    Re: [RESOLVED] Listview loop

    But that's exactly what tg is alluding to:
    Your drier (probably) has a "beeper" --> Drier.RaiseEventBeeper("Done")
    The question is: Is your Frontend (yourself) subscribed to this event (aka are you...
  18. Replies
    3,455
    Views
    627,820

    Re: What song are you listening to right now?

    Just LMAO...


    https://www.youtube.com/watch?v=S9WWz95ripA
  19. Replies
    23
    Views
    537

    Re: [RESOLVED] Listview loop

    And therein lies the problem, because people don't understand or are not even aware, that all those "concepts" (algorithms) are part of our daily life!

    e.g. Just this weekend i had a full washing...
  20. Replies
    23
    Views
    537

    Re: [RESOLVED] Listview loop

    For me it was my very first "Database" on a Commodore C64 somewhere Mid-80s
    My only source was the manual that came with the C64, explaining the "Basics" of "Basic".
    Late 80's nearing the end of...
  21. Replies
    39
    Views
    1,529

    Re: new project - DB help needed please

    Since OP is using MS Access (My condolences, btw), i'd rather go the route saving all those "Sub-Queries" as "Views" (Saved Queries) within Access itself.

    Then it would just be switching the...
  22. Replies
    6
    Views
    224

    Re: Ltrim to trim textbox

    Just use the Split-Function on any of your scenarios
    what you are looking for is in Member 1 of the resulting array, irrespective if it's only one "@" or more.
    As a sanity-check you'd just need to...
  23. Thread: SQL help pls

    by Zvoni
    Replies
    2
    Views
    237

    VS Code Re: SQL help pls

    This not withstanding: What's so hard about to read the official documentation?
    I have no clue about MS SQL, but it took me 2 minutes to find it...
  24. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    Just to make sure i understand it correctly:
    1) You need the Students/StudentTotal who have paid in full IRRESPECTIVE of the Subject
    2) You need the Teachers/TeacherTotal IRRESPECTIVE of Subjects
  25. Re: Passing different types of variable into a function

    Not just "thinking it was the issue".... IT IS the issue.
    A Variant itself can be an array already
  26. Re: Passing different types of variable into a function

    Works as well


    Public arrLong(1 To 5) As Long
    Public arrOutString() As String

    Public Function DoSomethingLong(ByRef InArray() As Long, ByRef OutArray As Variant) As Long
    Dim i As Long
    Dim c...
  27. Re: Passing different types of variable into a function

    Works for me


    Public arrLong(1 To 5) As Long
    Public arrString(1 To 5) As String
    Public arrByte(1 To 5) As Byte

    Public arrOutLong() As Long
    Public arrOutString() As String
    Public...
  28. Replies
    39
    Views
    1,529

    Re: new project - DB help needed please

    What DBMS?
    many Databases understand SELECT COUNT(DISTINCT SomeField) AS MyCount FROM MyTable
  29. Re: Sent private messages don't appear in sent items box->

    Yeah..... fun question: And did you have a smartphone in 2003? :D
  30. Replies
    13
    Views
    455

    Re: Label array issue - Error 91

    What i said.....
  31. Replies
    13
    Views
    455

    Re: Label array issue - Error 91

    Use code-tags


    Dim lbltst() As Label
    Dim x As Long
    x = 0
    Dim C As Integer
    C = 6
    ReDim lbltst(x)
  32. Re: Sent private messages don't appear in sent items box->

    Well, considering, how old vbforums is (i remember a User having Reg-Date 1999)......
  33. Re: Sent private messages don't appear in sent items box->

    Do you have the "Save Copy in Sent Items"-Option activated (below a "new" message)?
  34. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    WITH
    SC AS (SELECT SC.Class_ID, SUM(COALESCE(SC.Price, S.SubjectPrice)*SC.NumOfSessions) As TotalPrice,
    TS.TeacherPercentage, SUM(SC.NumOfSessions) As TotalSessions
    ...
  35. VS 2022 Re: std::string from c++ dll rejected by Visual Basic String

    std::string is a class. Basically you try to return a Class
    https://cplusplus.com/reference/string/string/

    Have you tried to change the returntype to "char*" ? Note the asteriks. Pointer to char
  36. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    That one will definitely be Tomorrow at the earliest
    (Currently my boss is looking at me from across the room)
  37. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    WITH
    TR AS (SELECT SC.ID, SC.Student_ID, COALESCE(SC.Price, S.SubjectPrice) AS SubjectPrice,
    S.SName As SubjectName, TE.TName As TeacherName, SC.NumOfSessions,
    ...
  38. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    No, he‘s right. I didn’t consider what he said.
    unfortunatly, it‘ll be thursday i can have a look at it since i‘m out of office the next 2 days.

    but i think it’s easy. I do have an idea, how to...
  39. Replies
    123
    Views
    5,734

    Re: Another complicated query but perhaps possible

    WITH
    SSC AS (SELECT SC.Class_ID, SC.Student_ID, SC.NumOfSessions, COALESCE(SC.Price,S.SubjectPrice) As SubjectPrice,
    COALESCE(SC.Price,S.SubjectPrice)*SC.NumOfSessions As...
  40. Re: TRYING TO RUN EXCEL OUTPUT USING Latest MS Office 365 (Versioin 16)

    And Elroy told you the solution: Late binding
Results 1 to 40 of 497
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width