Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.50 seconds.

  1. Replies
    7
    Views
    707

    Re: DDE - How do you use it?

    What about DDE?

    EDIT: Ah, yes. Just saw it.
  2. 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...
  3. Re: What are the Major & Minor values of Windows 11

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

    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...
  5. Replies
    8
    Views
    199

    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...
  6. 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
  7. Replies
    33
    Views
    688

    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...
  8. 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
  9. 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
  10. 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...
  11. Re: SQL - Select where either but not both has values

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

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

    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"...
  14. Replies
    11
    Views
    457

    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...
  15. Replies
    4
    Views
    201

    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
  16. Replies
    3
    Views
    130

    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
  17. Replies
    14
    Views
    504

    Re: USB story 2 - The return.

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

    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...
  19. Re: Getting the ball rolling. Which VB6 projects are you working on?

    None....
  20. Replies
    10
    Views
    280

    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...
  21. Replies
    10
    Views
    280

    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...
  22. Replies
    10
    Views
    280

    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...
  23. 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)...
  24. Replies
    10
    Views
    280

    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...
  25. Replies
    4
    Views
    174

    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...
  26. 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...
  27. Thread: Ship of theseus

    by Zvoni
    Replies
    25
    Views
    509

    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 ,...
  28. Thread: Ship of theseus

    by Zvoni
    Replies
    25
    Views
    509

    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...
  29. Thread: Ship of theseus

    by Zvoni
    Replies
    25
    Views
    509

    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...
  30. 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...
  31. 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...
  32. Thread: Democracy

    by Zvoni
    Replies
    176
    Views
    5,966

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

    by Zvoni
    Replies
    176
    Views
    5,966

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

    by Zvoni
    Replies
    176
    Views
    5,966

    Re: Democracy

    I think it's actually the other way around (?). At least it was explained to me that way.

    If those tests are 70% reliable (note the different word i use, not effective), and i KNOW i'm not...
  35. Thread: Democracy

    by Zvoni
    Replies
    176
    Views
    5,966

    Re: Democracy

    While the unvacced still adhere to the "social" rules (Distance, Mask etc.).....

    I agree in general, that employees in health-care should make sure to not make it worse for the patients, including...
  36. Thread: Democracy

    by Zvoni
    Replies
    176
    Views
    5,966

    Re: Democracy

    JMC,
    agree with you for Health-Care employees.

    But look at this: https://www.straitstimes.com/singapore/unvaccinated-workers-in-construction-sites-must-be-clearly-identified-from-aug-16-bca
    ...
  37. Thread: Democracy

    by Zvoni
    Replies
    176
    Views
    5,966

    Re: Democracy

    Peter,
    it's been some months (I think it was in May or June), and fortunately it didn't grow. I think the whole thing was over within a week, at least concerning public "appearance" (on TV,...
  38. Re: Pause Execution Until Function Completed (web access function)

    You know what they say: Once you submit to the temptation......
  39. Thread: Democracy

    by Zvoni
    Replies
    176
    Views
    5,966

    Re: Democracy

    JMC, those conversations were shown by german TV-News-Stations to gauge the (then) current opinion of people.
    The TV-Stations didn't invent (and didn't comment) the conversation.

    I was witness to...
  40. Re: Pause Execution Until Function Completed (web access function)

    Brr.....shudder.....
    What's wrong with


    Do
    sUserInfo = AppRegValidation
    Loop Until Len(sUserInfo.Username) > 0


    No idea about inserting a mechanism to abort the loop (though should be...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width