Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.48 seconds.

  1. Re: Quantum Resonance Magnetic Body Analyzer 52 Reports MINI - error message

    Is it even VB6?.....
  2. Replies
    10
    Views
    120

    Re: Allow users to build WHERE clauses

    I feel you.
    I've had users trying to formulate such a WHERE-Clause running into a "deadlock" (at least i call it a deadlock --> basically the one filter excluding the other) returning an empty...
  3. Replies
    10
    Views
    120

    Re: Allow users to build WHERE clauses

    Do you mean like providing a TextBox the user can enter "WHERE Salary>=2000"?

    I'd rather first check, if the way i'd usually do something like this would be feasable (if i ever would get such an...
  4. Re: VB6 QUESTION: Detecting when PC comes back from sleep mode

    Use the API
    https://docs.microsoft.com/en-us/windows/win32/api/powerbase/nf-powerbase-powerregistersuspendresumenotification?redirectedfrom=MSDN

    Or by subclassing:...
  5. Re: Does New-Basic really need class inheritance?

    The age-old question........
    For what it's worth: IMO inheritance is a basic principle, which should be implemented in any language, which wants to be taken seriously.

    Example:
    Base class...
  6. Re: Cannot debug 'Subscription out of range error'

    Yes, you're right.
    Got confused with it. I rarely use Ranges in my VBA
  7. Replies
    7
    Views
    235

    Re: VBA Function returns 0

    Which solution are you using?
    If you use mine, you shouldn't assign the result of the StrSpn-API-Call directly to the Function-Result (as in my example, that was quick and extremely dirty!)

    It...
  8. Re: Cannot debug 'Subscription out of range error'

    Yes, that's possible to "interpose" the Range-Object there.
    The Cells following after it are then refering to the Range, not the Sheet (Think as in "offset").
    Cells(1,1) would be the Top-Left cell...
  9. Replies
    10
    Views
    191

    Re: Delete all records in a table

    Gary, thx.
    As i said: Never had/used SQL-Server, so i'm not familiar with the intricacies/pitfalls of it

    But, as i said: as long as that table is NOT a Parent/Master to a Detail-Table.....
    ...
  10. Replies
    10
    Views
    191

    Re: Delete all records in a table

    You're welcome.
    Any thoughts on my DROP TABLE/CREATE TABLE Approach?
    Wouldn't mind some performance-results with a few 100K/1M rows
  11. Replies
    10
    Views
    191

    Re: Delete all records in a table

    To me it actually makes perfect sense, to not use the '*' in the DELETE statement (contrary to a SELECT).
    In a SELECT i can choose which columns to show, or all with '*'
    But in a DELETE i will...
  12. Replies
    10
    Views
    191

    Re: Delete all records in a table

    Have you tried "DELETE FROM dbo.CellNumbers"? No Asteriks
    https://docs.microsoft.com/de-de/sql/t-sql/statements/delete-transact-sql?view=sql-server-ver15


    EDIT: If that Table is not a...
  13. Re: Cannot debug 'Subscription out of range error'

    Eh, no!
    The OP correctly states using Type 8 in the Inputbox
    Look here: https://docs.microsoft.com/en-us/office/vba/api/excel.application.inputbox
  14. Re: VB6 application not connecting to Access database 2016 in windows 10

    ... or throw Micro s h i t where it belongs, and use sqlite for local, filebased database
  15. Re: Cannot debug 'Subscription out of range error'

    What are the values for i and j when your code throws the error?
    And how many Columns and Rows does that Range have?
    If you have a Range, say A3:B4, you have 2 columns and 2 rows, but your Loop...
  16. Re: is there other Copymemory faster than WinAPI ?

    I'm trying to understand what you're trying to do.....
    Looks like "shifting" an array "down" an element (a.k.a removing first element)
  17. Re: is there other Copymemory faster than WinAPI ?

    I'm trying to understand what you're trying to do.....
  18. Replies
    7
    Views
    235

    Re: VBA Function returns 0

    Yes, you're right.
    I edited my post, and i forgot that one
  19. Replies
    7
    Views
    235

    Re: VBA Function returns 0

    Assuming numeric Portion is at the beginning/left of the string:
    No Error-Handling whatsoever!


    Private Declare PtrSafe Function StrSpn Lib "SHLWAPI" Alias "StrSpnW" (ByVal lpSource As LongPtr,...
  20. Replies
    9
    Views
    354

    Re: get data from html table

    That's Excel-VBA (see that "Sheets(1).Cells-Thingy?)
    IIRC, each Cell on a Worksheet has a Hyperlink-Property and an Event FollowHyperlink
  21. Replies
    8
    Views
    228

    Re: Open file with specific application

    GAHHH!!!

    I'm an Idiot!

    Which "Directory" did i have opened in the Registry? Correct, HKCU .......

    *SlamHeadOnTable* *facepalm*
  22. Replies
    8
    Views
    228

    Re: Open file with specific application

    Company-Laptop. I'm definitely NOT going to step into that minefield......
    I'm at odds with our IT-Department enough as it is.... :D
  23. Replies
    8
    Views
    228

    Re: Open file with specific application

    Huh?

    Looking at my Registry (Win10Pro-64Bit) there is no "Applications"-Subkey in HKCR.....
  24. Replies
    8
    Views
    228

    Re: Open file with specific application

    Why not just query the Reqistry?

    e.g. the entry for my Acrobat Reader (don't have photoshop)
    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Adobe\Acrobat Reader
    Reader_2018_URI = C:\Program...
  25. Replies
    3
    Views
    248

    Re: Get Length of MIDI File

    Found on SO (albeit 10 years old): https://stackoverflow.com/questions/6037534/how-to-calculate-the-time-length-of-a-midi-file

    Bottom Line:
    You have to calculate it yourself, keeping track of...
  26. Replies
    3
    Views
    190

    Re: Passing UDT to a form...

    Basically the same discussion:
    https://www.vbforums.com/showthread.php?889125-vb6-how-use-an-user-type-parameter-on-a-class-function-sub
  27. Replies
    36
    Views
    861

    Re: .txt files

    Huh? Didn't know that one.
    Now, the interesting question would be: Does this work with a "SELECT....INTO....." Statement?

    Aircode-Algorithm
    Source-File: source.txt
    Target-File: target.txt
    Do...
  28. Replies
    35
    Views
    1,173

    Re: Need help with a querry

    DM, here is the original Thread: https://www.vbforums.com/showthread.php?891128-Very-complicated-but-perhaps-possible!
    If you look at my aircode in Post 16, you'll see there is a line with...
  29. Replies
    2
    Views
    150

    Re: Function not running from excel

    Is it a Public Function in a Standard Code-Module?
  30. Replies
    40
    Views
    1,269

    Re: Very complicated but perhaps possible!

    Well, there we go.
    its now on him
  31. Replies
    40
    Views
    1,269

    Re: Very complicated but perhaps possible!

    Would it explain why he fails in DB-Browser?
  32. Replies
    40
    Views
    1,269

    Re: Very complicated but perhaps possible!

    Hes using RC5
    See post #11
  33. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    Holy smoke! Yes, i remember High-school, too.
    End of the eighties "Computer Science" was an elective for the last 2 years
    Yeah, laugh it up: "Computer Science" with, IIRC, three XT-Machines with 5...
  34. Replies
    40
    Views
    1,269

    Re: Very complicated but perhaps possible!

    Try it as a single line


    SELECT DISTINCT T1.aut, T2.remain FROM trans As T1 LEFT JOIN (SELECT Aut, ID, remain, Acquit, ROW_NUMBER() OVER(PARTITION BY item_id ORDER BY Aut DESC) AS RN FROM Trans)...
  35. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    There is already one: https://www.vbforums.com/forumdisplay.php?74-Other-Programming-Languages
  36. Replies
    40
    Views
    1,269

    Re: Very complicated but perhaps possible!

    So it works?
  37. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    I advise against such a migration-tool.
    FPC/Lazarus has such a slew of options you can use to improve your vb-code.
    Yes, start with a simple project, and port it, but "rewrite it" in a way.
    Yes,...
  38. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    Porting not that much, since i'm not (and never was) a professional dev.
    Mainly stuff i use at work, which were Excel-VBA-things that i moved/ported to Lazarus.

    @easier/harder: Funny enough:...
  39. Replies
    40
    Views
    1,269

    Re: Very complicated but perhaps possible!

    Eh?
    True.
    It's time for some offtime..... overworked, underjumped, the whole slew......
  40. Replies
    40
    Views
    1,269

    Re: Very complicated but perhaps possible!

    *groan**facepalm*
    Missed that one
    I actually used Arnout's CREATE TABLE/INSERT INTO Statements to create my sample data
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width