Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.28 seconds.

  1. Re: could anyone guide me on this byref arguement type mismatch error?

    Damn! Missed that one.
    Confusing: He has Option Explicit in his Module, where he declares sResp and the API's, but i agree: Probably the Dim vs. Public (Global Variable....bleh)

    EDIT: And it...
  2. Re: could anyone guide me on this byref arguement type mismatch error?

    But he does.
    Second Code-Block in the first post
  3. Re: WH_KEYBOARD_LL x64bit Windows 10 no longer works !

    If it doesn't work, then the code is not correct.
    And LongLong is not a pointer: It's a 64-Bit Integer
  4. Re: WH_KEYBOARD_LL x64bit Windows 10 no longer works !

    Is your Office 32 or 64-bit?

    EDIT: The Header/Parameters of the Callback-Function looks fishy to me.
    i would have expected the standard Datatypes for wparam and lparam
  5. Replies
    8
    Views
    227

    Re: Help with iniFile

    Write a Wrapper around the writeprivateprofilestring-API
  6. Re: could anyone guide me on this byref arguement type mismatch error?

    Since it's a pointer to a structure, i'd try ByVal sRespData As Long in your Declare, and use VarPtr-Function to get the Pointer to the UDT
  7. Re: could anyone guide me on this byref arguement type mismatch error?

    Do you have the Header-Files?
    What i could find, the ConnectDevice-Function takes 2 Long-Parameters, you have 3 in your Declare.....
  8. Replies
    18
    Views
    778

    Re: Should i learn VB6?

    I'm with Baka on this one: If just starting out, don't learn VB6.
    Look for cross-platform (everything baka said).

    For that purpose i go with FreePascal/Lazarus: Open Source, Free, Cross-Platform,...
  9. Re: How to get access field dataformat using ado

    *sigh*
    And a Date-Format is basically a Long Integer (actually: a Double without the Fraction part)
    and a Time-Format is a Double in the Range of 0 to 1 (actually: the fraction-part of a Double)
    ...
  10. Replies
    0
    Views
    181

    Excel2019 rounds/truncates Data from macro

    Hi Folks,

    something weird:
    Excel2019-64Bit on Win10Pro-64Bit

    Via macro i pull data from a database and transfer it to a worksheet.
    This macro has worked for years in production.

    Since i've...
  11. Re: DisplayResolution 2560 x 1440 gives run-time 6 overflow error program made with

    Besides having to sit at least 4 feet away? :D
  12. Re: How is the behaviour of VB6 compiler while comparing two string?

    True, but i wouldn't be surprised if under the hood it's the same function every time, overloaded with flags and what not. see Flag IGNOREWIDTH in wqweto's link, which basically can be used for...
  13. Re: How is the behaviour of VB6 compiler while comparing two string?

    Considering it's Microsoft we're talking about? *shrug*
    Out of my left sleeve: Take a binary representation of both strings, and subtract one from the other. If Result = 0 Then Equal Else NotEqual...
  14. Replies
    5
    Views
    363

    Re: MySQL Syntax Error Setting up SPROC

    Huh?
    You lost me there.....
    btw: I just noticed the name of your table.
    "user" is already a table in the database "mysql" (System-DB).
    Have you tried qualifying the tablename/SP?
    CREATE TABLE...
  15. Re: Loading a IniFile into a Dictionary

    Duplicate Keys where? Within a Section?
    That doesn't make sense.

    OTOH, a key can be repeated in a different section.

    Sections in an INI-File: Must be unique
    Keys within a Section: Must be...
  16. Re: How is the behaviour of VB6 compiler while comparing two string?

    ...which actually implies the same way RTLCompareMemory works: compare each "character" (honoring the flags), until there is a "difference"
    Otherwise it couldn't return Results like "is less" "is...
  17. Re: How to convert date&time information from date/time server into my local time?

    https://docs.microsoft.com/en-us/windows/win32/api/timezoneapi/nf-timezoneapi-systemtimetotzspecificlocaltime
    Depending on if that server is on UTC, or in its own TimeZone differing from UTC, you...
  18. Re: How is the behaviour of VB6 compiler while comparing two string?

    No idea if the compiler optimizes a String-Compare to a RTLCompareMemory, but i wouldn't be surprised,
    if a "If String1=String2 Then" compares the whole memory-blocks the Stringpointers point to....
  19. Replies
    8
    Views
    698

    Re: MySQL (with VB6) questions

    Have to disagree.
    Scroll down about one third. MySQl allows granting columnwise
    https://www.mysqltutorial.org/mysql-grant.aspx/



    GRANT
    SELECT (employeeNumber,lastName, firstName,email), ...
  20. Replies
    5
    Views
    363

    Re: MySQL Syntax Error Setting up SPROC

    Have you tried increasing the VARCHAR-size in the Parameter?

    https://stackoverflow.com/questions/13960760/mysql-stored-procedure-that-accepts-string-with-multiple-parameters
  21. Replies
    4
    Views
    329

    Re: Open an undefined data structure.

    At a guess: Records (VB6-speak: UDT's) accessed/written in random mode.
    Have you tried reverse engineering the Record-Structure?
    First, i would look, if there is a repeating pattern recognizable...
  22. Re: PRINT directlly a word document from dir

    ....and at its Window-Styles (HIDDEN, SILENT or whatever it's called)
  23. Replies
    14
    Views
    822

    Re: Date Type Mismatch

    That blasted "Active"-Something again.
    Is your "Active"-Sheet even the "correct" one?
    Does the error happen, when you qualify the sheet directly (via number/Name)?
  24. Re: How to select using multiple column match?

    Why don't you build a computed column from your 2 columns and compare that one?
    If you have fixed-length Text-Columns, use TRIM to cut off leading/trailing whitespace
    Aircode

    SELECT/DELETE *...
  25. Replies
    1,678
    Views
    95,104

    Re: Corona virus, China major city lockdowns, etc.

    A friend of mine made an "interesting" suggestion (note the quotation-marks):
    "Actually, we could defeat that blasted virus quite easily: The whole world just has to stop for 4 weeks, all at the...
  26. Re: Is PeekNamedPipe broken in current version of Windows?

    https://docs.microsoft.com/en-us/windows/win32/api/namedpipeapi/nf-namedpipeapi-peeknamedpipe
  27. Re: Is it possible to connect SQLServer via internet without opening port like teamvi

    Ehhhh.....wrong!
    I know for a fact, that TeamViewer has a central Server, where all clients connect to /register themselves with. That's the server which assigns you your TeamViewerID.
    So,...
  28. 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...
  29. 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
  30. 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...
  31. Thread: Dates...

    by Zvoni
    Replies
    5
    Views
    456

    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...
  32. Replies
    3
    Views
    318

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

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

    by Zvoni
    Replies
    5
    Views
    456

    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)
  35. Replies
    4
    Views
    299

    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...
  36. Replies
    18
    Views
    1,001

    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/
  37. Replies
    24
    Views
    1,046

    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
  38. Replies
    24
    Views
    1,046

    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:...
  39. Replies
    13
    Views
    748

    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...
  40. 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 +...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width