Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 5.55 seconds.

  1. Re: vb6: how use an user type parameter on a class function\sub?

    I admit: It's been some time having tried something like this,
    but, couldn't he define a "child"-class "POINTL" with just two public Properties (x and y As Long), in this mode "Public - Not...
  2. Re: vb6: how use an user type parameter on a class function\sub?

    Had that thought, too, but since it's Graphic-API's i wouldn't be surprised when there are other API's waiting down the code, which actually are expecting a POINT-Structure as an argument
  3. Re: vb6: how use an user type parameter on a class function\sub?

    hrhrhrhrhr.....
    Written in Office/VBA (that's why the PtrSafe and LongPtr is there)



    Private Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As...
  4. Thread: Dates...

    by Zvoni
    Replies
    5
    Views
    193

    Re: Dates...

    Urggghhh.....forgot about the implicit Type-Cast

    Nevermind, that you should never save a Date/Time-value in a String-Variable.
    Just use Format (which returns a string) to assign/show/display...
  5. Replies
    3
    Views
    159

    Re: Can I view contents of a recordset?

    Or if you know the internals of your DB-Backend you can just query the System-Tables......
  6. Replies
    7
    Views
    241

    Re: Truncate the Array

    Or Dim the new Array to its new Size, and then CopyMemory the VarPtr of the old Array to the new Array with the correct/new length.
    Don't forget to cheat the ref-count.

    EDIT: I'm with baka on...
  7. Thread: Dates...

    by Zvoni
    Replies
    5
    Views
    193

    Re: Dates...

    Why not just use the predefined Formats?
    Debug.print Format(Now, "Short Date")
    Or the FormatDateTime-Function?
    Debug.Print FormatDateTime(Cstr(EstDate),vbShortDate)
  8. Replies
    4
    Views
    129

    Re: Correct use CreateDirectory API

    It has nothing to do with SecurityAttributes, but with Access-Rights the User, who's running the Program, has.

    It's the age old problem with write-access to "c:\Program Files" and similiar folders...
  9. Replies
    18
    Views
    478

    Re: Extended ascii characters

    Eh? How do you figure it's supposed to be 241?
    On my machine (Germany) the "" is: ALT+0177
    https://www.ascii-code.com/
  10. Replies
    24
    Views
    481

    Re: Different Boggle Question

    You know, looking at the link wqweto provided.......

    .... i don't think there is enough alcohol on the planet for me to suddenly understand a single word of that one day.......
    :D
  11. Replies
    24
    Views
    481

    Re: Different Boggle Question

    Sam, your initial Problem reminds me of Conways "Game of Life":
    It checks the (max) 8 possible squares around the "selected" square for a "state" (dead/alive)
    Maybe you can find an algorithm there:...
  12. Replies
    13
    Views
    405

    Re: Remove Duplicate Entries From UDT Array

    As a "quick" ( ! ) solution:
    Your "RT"-Field seems to be the "key" of the Array, and you want it to be unique, albeit with the Highest Width of a Glyph.
    As an algorithm (Aircode)
    Define/Dim a...
  13. Re: [VB6/VBA] A clipboard management class (currently have issues in x64)

    Have you checked, if "lpClipMemory + Len(tDropFiles)" in your copymemory-call actually translates to a Memory-Address?
    Add to Watch-Window:
    lpClipMemory
    Len(tDropFiles)
    lpClipMemory +...
  14. Replies
    12
    Views
    319

    Re: Timestamp on data change

    Haven't looked at the Workbook.
    1) If you want to use a VBA-Function directly in a cell on a sheet, this function must be "Public" in a standard-module.
    2) That said in 1): How are you passing...
  15. Re: Finding a subfolder with the highest number that matches a pattern

    Agree with Arnout.
    Collect the Foldernames with Dir (or its API-Sisters) matching that particular pattern,
    comparing Foldernames to your Pattern you can use the "Like"-Operator
    in a hidden ( ! )...
  16. Re: [VB6/VBA] A clipboard management class (currently have issues in x64)

    Between your working 32-Bit and not working 64-Bit-Version: Have you checked if there is a difference between Len(tDropFiles) vs. LenB(tDropFiles)?
  17. Re: [VB6/VBA] A clipboard management class (currently have issues in x64)

    You do know, that the VBA7-constant checks the Office-Version, not the Bitness of the Office-Version?

    I've run into a similiar Problem, when the company i work for switched from Office2016-32Bit...
  18. Excel 2019: ActiveX-Listbox works on my computer, but not on another Computer

    Hi Folks,

    something weird:

    I've written a small tool for my boss in excel (for him to query our database).
    For that, on the primary worksheet there are some ActiveX-Controls (ActiveX, not...
  19. Replies
    9
    Views
    445

    Re: Textbox with calculator?

    And now i'm going for the Overkill:
    Why not shell calc.exe, use the PID that shell returns to find/get the hWnd of calc.exe, and then SetParent to a Picture-Box?

    Right, just thinking out of my...
  20. Replies
    39
    Views
    1,382

    Re: Load image into STATIC control Win32

    You mean besides the point that this is VBA/Office apparently?
  21. Replies
    22
    Views
    772

    Re: VBRichClient - SQLite - Slow Loading Data

    ...."...and i see fire...."....errrr....."SELECT * FROM....."

    if all those queries are supposed to be displayed in one and the same Grid, i'd start taking them apart, and see if can create one...
  22. Replies
    22
    Views
    772

    Re: VBRichClient - SQLite - Slow Loading Data

    Agree with Arnout: It's probably more your query than sqlite or RC5
    the usual culprit is a "SELECT * FROM Table".....

    Btw: What's the expected RecordCount?
    I don't know if RC5 is already...
  23. Replies
    23
    Views
    792

    Re: Vb6: Winsock data arrival truncated problem

    Is it a multiline-textbox (incl. expanded on the form to be bigger and show more lines than the "standard" one line?
    Maybe there is a vbCrLF/chr(0) hidden in your data arriving......
  24. Re: How to duplicate a column in the same table (SQLite)

    Errr...right...that one....

    Just after re-reading it, i got a suspicion regarding his SQL-command (especially regarding this missing double-quote):
    His result/screenshot suggests he's updating...
  25. Re: How to duplicate a column in the same table (SQLite)

    I'm more surprised his code compiles (if it compiles), since he's missing a closing paranthesis in his SQL-command
    As jmc said: you have to filter out the entries you want/don't want to update.
    ...
  26. Re: SQL - Query to return sum and 0 if no match is found

    On SQLite (don't have SQLServer)
    You have to test DA.CaseID if it's null



    SELECT
    HOC.ListItemName,
    SUM(CASE WHEN C.CaseID ISNULL THEN 0 ELSE 1 END) As TotalSum
    FROM HOC
    LEFT JOIN
  27. Re: SQL - Query to return sum and 0 if no match is found

    zip it first!
  28. Replies
    13
    Views
    557

    Re: Jet SQL: Insert Null FK?

    FD, correct.
    But that comes back to my argument:
    Since the ForeignKey is in the "Pie"-Table, that would (in DB-Terms) make the "Filling"-Table the Master, and the "Pie"-Table the Detail/Slave, and...
  29. Re: Looking to make this macro Faster

    Not sure i understood what you're trying to do
    Aircode:


    ......
    Dim i As Long
    With WS1
    Range("O2")=100
    For i=2 To UsedRange.Rows.Count
    Range("K" & i)=Range("K" & i)*Range("O2")
  30. Replies
    13
    Views
    557

    Re: Jet SQL: Insert Null FK?

    FD, was thinking about that, too, but it would still be fired for each new "Pie".
    And i'm a fan of "bulk"......
    Albeit, it would actually be the smallest change to the code.
  31. Replies
    13
    Views
    557

    Re: Jet SQL: Insert Null FK?

    You mean, as in my second idea?
    I agree, it would be the "cleanest" way to skin that cat.
    you would just have to change/update those two views and the AssingForeignKey-procedure.

    And i actually...
  32. Replies
    9
    Views
    362

    Re: eliminate multiple zeros

    Your "gross" in your GROUP BY irritates me. I'm surprised this works, since you're grouping on an aggregated field.

    I would have expected: GROUP BY Collected_WorkstationCode
  33. Replies
    13
    Views
    557

    Re: Jet SQL: Insert Null FK?

    I'd look at it from the other side: Do you need a "real" Foreign Key in "Pies"?
    As in: To me it looks like a 1:1 or 1:0-Relation between "Pies" and "Fillings" (A "Pie" can have only one or none...
  34. Re: Using public type as input parameter for function

    Hmm, OK.
    I don't see anything wrong here.
    My suspicion was you declare it with other variables in one line (which is true), but ommiting the VarType for all except the last.
    In that case only the...
  35. Re: Using public type as input parameter for function

    Show the Line where you declare/dim FirstPoint as you have it in your code. Don't "beautify" it.
    I have a suspicion.....
  36. Replies
    7
    Views
    419

    Re: Delete the last item in listview

    ?
    Just check the Index of SelectedItem against ListItems.Count
    Beware, if your ListView allows MultiRow-Selection

    btw: Is your ListView sortable? If it's sortable you could run into the fact,...
  37. Re: [RESOLVED] Help with Appending Access from Excel

    A drive-Letter "A"??? Floppy-Disk?

    IIRC i too had problems with something similiar.
    What cursor-Type do you use? I remember that i had to switch to server-side cursor to make it work

    And i...
  38. Thread: Thanks....

    by Zvoni
    Replies
    19
    Views
    855

    Re: Thanks....

    Refuel? You're on Reserve? :D
  39. Re: Running code against Sqlserver worked fine first time but now 'Access denied'

    Backup (write-permissions) in "Program Files"?
    Good lord......
  40. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    That's not the Problem.
    The Problem is: When is Week 1 (according to date)?
    Is it the Week having Jan 1st, or is it the week having the first Monday of the year?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width