Search:

Type: Posts; User: Arnoutdv

Page 1 of 12 1 2 3 4

Search: Search took 0.09 seconds; generated 41 minute(s) ago.

  1. Replies
    11
    Views
    378

    Re: [RESOLVED] Time and Date from memory

    The Date datatype is just a double.
    The integer part is the date since 30 December 1899 (date = 0)
    The fractional part is the number of seconds divided by 86400
    No needs for roundtrips :)
  2. Replies
    18
    Views
    494

    VS 2019 Re: Process faster in nested for loops

    Then a 1 million dollar question still needs to be answered, what needs to be done when 2 records/items are the same?
  3. Replies
    18
    Views
    494

    VS 2019 Re: Process faster in nested for loops

    Does VB.Net also has the concept of UDT or Structs?
    Or is an UDT a lightweight class in .Net?
  4. Re: VSFlexGrid only picture in column and not text.

    Is there a specific reason for having the grid bound to a dataset?
    In other words can it be disconnected?
  5. Replies
    194
    Views
    34,768

    Re: NewTab: tab control for VB6

    Convert your form to a user control.
    If you insist in having a form in a form then use the SetParent API, but you can get strange behavior
  6. Re: VSFlexGrid only picture in column and not text.

    And what if you set .TextMatrix to ""


    With grid
    .Redraw = flexRDNone
    For f = 1 To .Rows - 1
    If .ValueMatrix(f, 2) = 0 Then
    .Cell(flexcpPicture,...
  7. Replies
    18
    Views
    494

    VS 2019 Re: Process faster in nested for loops

    You want to merge to 2 arrays?
    What would the outcome look like?
  8. Replies
    18
    Views
    494

    VS 2019 Re: Process faster in nested for loops

    You can reduce it to a single loop if you sort the data while keeping the indices of the items.
    Then you need a single loop in which you just compare the current item with the next item.

    An...
  9. Replies
    18
    Views
    494

    VS 2019 Re: Process faster in nested for loops

    Maybe a silly question, but why do you have 2 arrays if the contain the same data?
    And what needs to be done when there more than 1 instances of a value in the data?
  10. Replies
    7
    Views
    2,746

    Re: Aligning text in a msflexgrid

    Check this codebank sample, you can call this method to change the appearance for a range of cells:
    https://www.vbforums.com/showthread.php?901180-MSFlexGrid-The-power-of-the-FillStyle-property
  11. Replies
    54
    Views
    1,823

    Re: new project - DB help needed please

    You refer to a field in sSql1 which you don’t use (yet)
  12. Re: App works fine in the IDE, closes unexpectly in runtime mode

    So remove all error handling from UserControl_Resize events and handle the error in Form_Resize()?
  13. Re: App works fine in the IDE, closes unexpectly in runtime mode

    Can you show more of the code including the error handler?
  14. Re: App works fine in the IDE, closes unexpectly in runtime mode

    It makes sense as in it behaves the same as when running from the IDE.
    Now you have to start bug hunting and that can get frustrating.
    You can use an external debugger, I don't have any experience...
  15. Re: VB6 COMPILED DLL giving CLASS_E_CLASSNOTAVAILABLE issue

    Are you 100% sure all the external files used by the DLL have not been changed since 2023?

    When you compare the 2 DLL files, the old and the new, are the exactly the same?
  16. Re: VB6 COMPILED DLL giving CLASS_E_CLASSNOTAVAILABLE issue

    Aha, I thought you meant VS2023, but you mean the year 2023 :)

    So if you recompile the same source from 2023 again in 2024 then DLL can not be used from VB.Net?
    While the previous compiled...
  17. Re: App works fine in the IDE, closes unexpectly in runtime mode

    What happens if you compile to P-code?
  18. Re: VB6 COMPILED DLL giving CLASS_E_CLASSNOTAVAILABLE issue

    You have to explain in more detail what you are doing.

    The source code for a DLL written in VB6 can not be compiled using Visual Studio 2023.
    The source for a DLL written in VS2023 can not be...
  19. Replies
    123
    Views
    5,810

    Re: Another complicated query but perhaps possible

    Maybe you should start with writing down all requirements and use cases first.
    Now you ask for A, you get a solution for and then you say, but I can’t get B.
    Then you get an answer for B, and then...
  20. Replies
    32
    Views
    3,428

    Re: Delete duplicate in access table

    Use a Count and a Group By in the query
  21. Replies
    60
    Views
    1,809

    Re: Adding a huge number of records to a MariaDB

    I assume you are aware of these concepts:
    https://en.wikipedia.org/wiki/High-frequency_trading
    https://www.investopedia.com/terms/h/high-frequency-trading.asp...
  22. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    I use the vsFlexGrid and always use basic coding statements like:


    For lRow = .FixedRows To .Rows - 1
    '
    NofActiveCols = .Cols - .FrozenCols - .FixedCols
  23. Re: VBFlexGrid Control (Replacement of the MSFlexGrid control)

    Why do you need them? They are simple additions and subtractions of the current available properties
  24. Re: Running a x32 application in x64 environemtn

    I also use CreateObject.
    But I don’t use Excel as a database, just need to read values.
    Then I often use the Excel object to save the current worksheet to a tab delimited file and process this...
  25. Re: Determine which computer is running Excel file

    Don't put in a Const but in a Public variable.
  26. VS 2010 Re: vb2010 - how calculate the hit direction?

    The angle before hitting a wall is the same as the angle when bouncing of, but seen from a different perspective.
    When calculating the angle then it's 180-Angle

    See this article on WikiPedia:...
  27. Replies
    26
    Views
    1,613

    Re: Installing VB6 on Windows 11

    Try the method as described in this thread by Elroy:
    https://www.vbforums.com/showthread.php?852227-Installing-the-VB6-IDE-on-Windows-10-64-bit
  28. Re: Running a x32 application in x64 environemtn

    I have no problem using vb6 with office 64bit versions.
    But I do not use Ado to communicate with Excel
  29. Replies
    5
    Views
    305

    Re: Create Layers in photoshop

    So some sort of Photoshop automation?
    https://github.com/Adobe-CEP/CEP-Resources/tree/master/Documentation/Product%20specific%20Documentation/Photoshop%20Scripting
  30. Replies
    5
    Views
    305

    Re: Create Layers in photoshop

    Using Photoshop or VB6??

    Or do you want to simulate Photoshop from VB6?
  31. Re: Creating ADODB Connection to Excel Workbook

    Office and VBA and it's drivers are all 64bit.
    VB6 is a 32bit application and can only use 32bit drivers.
    It seems that there is no 32bit version of Microsoft.ACE.OLEDB.12.0 installed, available or...
  32. Thread: Mystery bug

    by Arnoutdv
    Replies
    8
    Views
    489

    Re: Mystery bug

    What value of did you expect?
    Is the program stuck in an endless loop?
    You really should provide more information
  33. Re: Decompressing a split ACE archive along with progress bar

    There is an unace.dll, the source has never been made available.
  34. Re: Decompressing a split ACE archive along with progress bar

    Why not use an existing tool?
    Like PeaZip: https://peazip.github.io/ace-files-utility.html
  35. Replies
    6
    Views
    590

    Re: Major issue: Old zip being corrupted.

    Thanks for sharing guys!

    I managed to download the ZIP file from this codebank submission by dilettante:
    https://www.vbforums.com/showthread.php?531321-VB6-Huge-(-gt-2GB)-File-I-O-Class
    Using...
  36. Replies
    19
    Views
    943

    Re: capitals letters only and..

    I think validation should be done when the user exits the input field.
    Not by trying to modify/limit the input on the fly.

    I would let users input a text value.
    In the validate event I would...
  37. Thread: Closing Form

    by Arnoutdv
    Replies
    3
    Views
    394

    Re: Closing Form

    Post the relevant code and the error number and message
  38. Replies
    43
    Views
    49,687

    Re: "continue" in vb6?

    Why not use Do .. Loop, though the effect of multiple exit clauses is not the same as using continue
  39. Replies
    5
    Views
    959

    Re: Visual Basic 6 compiler

    Visual Basic 6 comes with a compiler.
    Or are you looking where to get VB6 Professional?
  40. Thread: Beizers+VB6

    by Arnoutdv
    Replies
    1
    Views
    384

    Re: Beizers+VB6

    You mean bezier curves?
    https://www.vbforums.com/showthread.php?727765-BSpline-based-quot-Bezier-Art-quot
Results 1 to 40 of 459
Page 1 of 12 1 2 3 4



Click Here to Expand Forum to Full Width