Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.57 seconds.

  1. Replies
    52
    Views
    1,005

    Re: Can anyone write an array module?

    But that‘s the thing: if i have dependencies (say a specific library) i can either declare it as dependent (and leave it to the user to install it) or i ship it with my app.
    If license of the lib...
  2. Thread: Extending VB6

    by Zvoni
    Replies
    62
    Views
    2,017

    Re: Extending VB6

    hrhrhrhrhr
    https://www.youtube.com/watch?v=InPIGu-bdwM

    :D:D
  3. Re: VB6 QUESTION: Providing Documentation for your Utility.

    Elroy,
    out of curiosity:
    How do you clean up that temp-Folder?
    Are you tracking whatever Viewer is used when it gets closed?
    Or are you polling the Folder trying to empty it with skipping the...
  4. Replies
    52
    Views
    1,005

    Re: Can anyone write an array module?

    But that's just it (at least for me): What happened to the Standalone-EXE?
    Whatever i write in Lazarus/FreePascal, which doesn't use external dependencies, i compile to an EXE, put it on a...
  5. Thread: Like Operator

    by Zvoni
    Replies
    6
    Views
    168

    Re: Like Operator

    then your If z Like "[1-9]*. " is not going to find that.....

    EDIT: Forget what i said..... it's too early in the morning.....
    In case it's actually a number, sometimes preceeded by an alpha, i...
  6. Thread: Like Operator

    by Zvoni
    Replies
    6
    Views
    168

    Re: Like Operator

    The Like-Operator is not RegEx.

    out of my left sleeve:
    I take it you mean digit (not number) --> What about a "0"?
    If it's actually digit, then you look for Length = 3 (1 Digit + 1 period + 1...
  7. Re: SQL - Select two columns where not null - return one row

    Sample Data taken from here: https://www.vbforums.com/showthread.php?893662-RESOLVED-SQL-Select-where-both-conditions-true

    tested in SQLite


    SELECT DISTINCT T1.Items, T2.ICRoles, T3.DVRoles ...
  8. Replies
    7
    Views
    708

    Re: DDE - How do you use it?

    What about DDE?

    EDIT: Ah, yes. Just saw it.
  9. Re: What are the Major & Minor values of Windows 11

    Look at "CurrentMajorVersionNumber", "CurrentMinorVersionNumber" and "CurrentBuildNumber"

    EDIT: What i could find out, why Win10 returns "6.3" for "CurrentVersion" from that Registry-Folder: 6.3...
  10. Re: What are the Major & Minor values of Windows 11

    Read the Registry?
    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion
  11. Replies
    8
    Views
    205

    Re: SQL Server Type name error in query

    *GROWL*
    I missed that his not working Parameters are Column-Aliases (vs. his working Query, where the Params are not Aliases)
    Column-Aliases can only be used in ORDER BY, GROUP BY and...
  12. Replies
    8
    Views
    205

    Re: SQL Server Type name error in query

    At a guess:
    you have "supername" and inspectname" twice as selected fields in your query (why? They even come from the same join-alias), so SQL_Server gets confused which one of those to use as...
  13. Re: how to auto tab or move to nxt txt box automatically wn took data frm Bar code re

    The code you found (and copy/pasted) is VB.NET
    It's not going to work in VB6 regardless what you do
    You have to rewrite it to VB6
  14. Replies
    52
    Views
    1,005

    Re: Can anyone write an array module?

    And it's not quoting some weird chinese statistics.....

    As for his first post:
    dz32, baka and Olaf have said what there is to say about this.

    If you want an Array to be an Object/Class (Notice...
  15. Re: Delete character from access database

    Aircode


    Dim RS As ADO.Recordset
    'Fetch your table-data
    RS.MoveFirst
    Do Until RS.EOF
    RS("MyField")=Replace(RS("MyField"), "-", "")
    RS.MoveNext
    Loop
  16. Re: SQL - Select where both conditions true

    So, basically for the sample data, you want Items A and B returned?


    SELECT *
    FROM
    Test T1
    INNER JOIN
    test T2
    ON
    T1.Items=T2.Items
  17. Re: Autofilter Criteria Array Parameters

    The question is not which output-format to use, but which format the input-values have

    Is "9/1/2021" the 1st of September 2021 or the 9th of January 2021?
    If the Input-Format is known, and...
  18. Re: SQL - Select where either but not both has values

    Your Query is not corresponding with the sample data.....
  19. Replies
    12
    Views
    255

    Re: language keeps coming back

    In a "standard"-Desktop-Config (one user = admin) it would still be miles more safer than Winbloze, just because of the fact your standard-one-user-is-admin IS NOT "root".

    But i think it has more...
  20. Replies
    12
    Views
    255

    Re: language keeps coming back

    And you wonder, why i abandoned Windows 4 years ago and switched to Linux?

    Just today i completed an online-training at the company i work for.
    It was about "Security at your workstation"...
  21. Replies
    11
    Views
    464

    Re: How to query an open ListObject?

    Having never worked with the Connections, there is one thing i noticed in your second code-block (which you said fails):
    Your SQL cannot work, since you tell it to SELECT from a Workbook, and from a...
  22. Replies
    4
    Views
    202

    Re: range testing

    You run through the Cells A2 to E6
    If none of those cells equals Range("E15") you're never going to set your Range to F2:F6, because it's in an If-ElseIf-construct
  23. Replies
    3
    Views
    132

    Re: Find -$####.#### or $####.###

    I'd first ask, if the content of those cells are REALLY strings (as the OP implies) or just "normal" numbers (Doubles from the looks of it), formatted to show up as currency values
  24. Replies
    14
    Views
    513

    Re: USB story 2 - The return.

    W10 says it all, why the Laptop is screwed up.
    Install Linux......
  25. Replies
    3
    Views
    281

    Re: Limit TextBox Entry to Specific Characters

    Why don't you process each keystroke (KeyDown, KeyPress) during entry, every time a "+" is entered you "start" a new member of a Long-array, where you CLng or Val each value before assigning it to...
  26. Re: Getting the ball rolling. Which VB6 projects are you working on?

    None....
  27. Replies
    10
    Views
    285

    Re: Debtor System Design

    That's actually a way better word to describe an invoice than my "unchangable"/"fixed"

    There is still one reason why i would still consider (partial) redundancy for the invoice-table:
    Changing of...
  28. Replies
    10
    Views
    285

    Re: Debtor System Design

    tg,
    yeah, that's the way you usually do it.
    You'd probably need a child-table to AR for partial payment of a specific invoice, since usually you're obligated to track every single transaction...
  29. Replies
    10
    Views
    285

    Re: Debtor System Design

    tg, correct.
    I just mentioned it for completeness sake.
    What's non-negotiable for me IMO is the separate table with the invoices, because this data is "fixed" (unchangeable), and all queries would...
  30. Re: Choosing a Server-less Database for a Desktop Application

    For completeness sake: Firebird

    Can be server-based, but also filebased desktop db

    EDIT: In your case it's Firebird Embedded (Single-Place/User)...
  31. Replies
    10
    Views
    285

    Re: Debtor System Design

    There are some issues with the model described.

    First off: Use a separate table for issued invoices with all fields pertaining to the invoice (Yes, it's redundancy, but e.g. a sales price can...
  32. Replies
    4
    Views
    177

    Re: need help with query

    Works in SQLite

    SELECT DISTINCT
    SUM(CASE WHEN Field1=0 THEN 0 ELSE 1 END) AS SUMFIELD1,
    SUM(CASE WHEN Field2=0 THEN 0 ELSE 1 END) AS SUMFIELD2,
    SUM(CASE WHEN Field3=0 THEN 0 ELSE 1 END) AS...
  33. Re: Bizarre Windows 10 / Excel 2019 behavior

    Hi Martin,
    Excel 365 64-Bit here. Cannot confirm (as far as i can tell).

    But you asked for Formula-Approach.

    Look at attached workbook, column F.
    I've commented out your...
  34. Thread: Ship of theseus

    by Zvoni
    Replies
    25
    Views
    516

    Re: Ship of theseus

    OK, i can see where you're coming from. But since you were born blind, you never had the concept of colors.
    It's different, if you get blind later in life (Accident, cataract in your eyes ,...
  35. Thread: Ship of theseus

    by Zvoni
    Replies
    25
    Views
    516

    Re: Ship of theseus

    To put it this way: If you lost a (or some) Limb(s) would it change "you"?
    Did ALS change Stephen Hawking?
    Yes, of course it would change someone, but, IMO, only in the "interaction" with the...
  36. Thread: Ship of theseus

    by Zvoni
    Replies
    25
    Views
    516

    Re: Ship of theseus

    Chipping in:
    1) Physical objects (as in the example of a ship):
    I'd say no, it's not the same anymore, because once taken apart there is an astronomically small chance to put it back together...
  37. Re: Configuring Windows Defender Firewall (Outbound)

    I don't think, you can create OutBound rules regarding File-Types.
    As Steve asked: How would they be sent out? With Mail? If Yes, which Mail-Client?
    I'd rather look in the Rules of your Mail-Client...
  38. Re: Multiple inner joins to Populate a treeview

    Don't do inner joins in this case
    Basically, you'd have 4 (nested) nested loops
    Grab the data from T1
    If T1.RecordCount>0 Start First loop
    Create Parent Node and enter data from T1
    Grab Data...
  39. Thread: Democracy

    by Zvoni
    Replies
    176
    Views
    6,009

    Re: Democracy

    I already wrote what The Solution to this whole crap would be: [SARCASM ON]Stop the World for 4 damned weeks![SARCASM OFF]

    Noone leaves his house/home/apartment for 4 weeks, noone interacts...
  40. Thread: Democracy

    by Zvoni
    Replies
    176
    Views
    6,009

    Re: Democracy

    JMC,
    what i fail to see is the importance of vacced vs unvacced on a construction site.
    I just don't get it: an unvacced construction site worker stabs himself on a nail, and then what?
    Because he...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width