Search:

Type: Posts; User: Arnoutdv

Page 1 of 13 1 2 3 4

Search: Search took 0.92 seconds.

  1. Re: Cannot debug 'Subscription out of range error'

    Ah clear, I'm not familiar with VBA specific functions and methods.

    But even then you can not concatenate variables with references.
    Or is this also possible in VBA?


    Dim r As Range
    ...
  2. Re: Cannot debug 'Subscription out of range error'

    It stores the range text specification in a variable.
    This should be a string variable, that's what inputbox returns
    Then you use the range specification in the Range object as a parameter

    Like...
  3. Re: Cannot debug 'Subscription out of range error'

    You first ask for a range, which is stored in r (a range variable)
    Then I think the code should be the following


    a(i, j) = aWb.Sheets("Sheet1").Range(r).Cells(j, 1)
  4. Re: Problem with ActiveX Controls (level: beginner; problem: very easy!!!)

    Maybe this:
    https://www.freetutes.com/learn-vb6-advanced/lesson13/index.html
  5. Re: Adjust Textbox size to Cursor(carat) Position

    You could use a Label control for this.
    Set the .AutoSize property to True
    Make sure it has the same font as your Text control.
    Assign the text to the .Caption property of the Label.
    Then check...
  6. Thread: Rotated text

    by Arnoutdv
    Replies
    8
    Views
    223

    Re: Rotated text

    Maybe this code sample is of any help to you:
    http://www.vb-helper.com/howto_center_rotated_text.html

    And another sample on VBForums with some explanations:...
  7. Re: Problem with ActiveX Controls (level: beginner; problem: very easy!!!)

    Start looking for tutorials about creating a usercontrol using VB6.
    https://www.dreamincode.net/forums/topic/134432-create-own-user-control-basic-steps/
  8. Replies
    6
    Views
    193

    Re: How much memory is taken up by an array?

    The value 0 takes also space, so yes
    For an array of strings the size is unknown until there are elements in the array.

    A long is 4 bytes, a dynamic string has a dynamic size.
  9. Replies
    9
    Views
    295

    Re: get data from html table

    But does it work??
    What do you expect from us?
  10. Replies
    9
    Views
    295

    Re: get data from html table

    What have you done so far?
  11. Replies
    2
    Views
    274

    Re: XML Class to read & write

    Menu option "Project" -> "References"
    Create a reference to "Microsoft XML, v6.0"



    Private Sub Command1_Click()
    Dim oXML As MSXML2.DOMDocument60
    Dim oNode As MSXML2.IXMLDOMElement
    Dim...
  12. Replies
    8
    Views
    198

    Re: Open file with specific application

    If the .jsx extension is not exclusively registered to be openend with Photoshop then I think you will need to search both Program Files folders for "Photoshop.exe"
  13. Replies
    12
    Views
    323

    Re: print list1 four columns

    This is air code, untested:


    Dim aLine() As String
    For i = 0 To List1.ListCount - 1
    List1.ListIndex = i
    ' The Text is delimited with a Tab
    aLine = Split(List1.Text, vbTab)
    ...
  14. Replies
    1
    Views
    65

    Re: ubound; subscript out of range

    Have a good look at the code.
    In the first line you set the max value of the loop to Ubound of TerminalID.
    In the next lines you are changing the size of the array and the content.
  15. Thread: TwinBasic

    by Arnoutdv
    Replies
    124
    Views
    8,865

    Re: TwinBasic

    Never had any problem with any version of W10 for developing VB6 applications.
    My customers also have a wide range of W10 version.
  16. Replies
    3
    Views
    172

    Re: Passing UDT to a form...

    ' Replace
    Public Function getPerson(ByRef lPerson As personStruct)
    ' With
    Friend Function getPerson(ByRef lPerson As personStruct)
  17. Replies
    36
    Views
    807

    Re: .txt files

    How big is the file?
    You mentioned that the file didnít need to be written back.



    How do you deal with the data in your application?
    Because you donít want anything it seems..
  18. Replies
    36
    Views
    807

    Re: .txt files

    ADODB is not a database.
    https://en.wikipedia.org/wiki/ActiveX_Data_Objects
  19. Replies
    36
    Views
    807

    Re: .txt files

    Did you check my post?

    Did you study the sample posted by wqweto?
    His sample can also read CSV files.
    And a reference to Microsoft ActiveX Data Object 2.8 Library, has nothing to do with Access...
  20. Replies
    36
    Views
    807

    Re: .txt files

    With a basic sort on text data the numeric field will not be sorted correct.
    It will be a text sort instead of a numeric sort.

    So for this sample I created an UDT with a numeric variable which...
  21. Replies
    36
    Views
    807

    Re: .txt files

    I assume there is a typo in the first line?
  22. Replies
    36
    Views
    807

    Re: .txt files

    What kind of delimiter is used for your text file?
    Does it need to be written back to disk?

    Can you show the first 10 records/lines of a sample file?
  23. Replies
    4
    Views
    157

    Re: Listbox control

    I think it's related to the "Sort a text file" topic.
  24. Re: RC5 Simplest way to copy table from ADODB to SQLite

    Then you have to assign the CreateSelectCommand to a variable/object.



    With MemDB.CreateSelectCommand("SELECT * FROM country WHERE some_bool = ? AND some_currency = ? AND some_datetime = ?")...
  25. Replies
    4
    Views
    157

    Re: Listbox control

    According to me it's 32K

    https://www.vbforums.com/showthread.php?829737-Listbox-maximum-limit-VERY-IMPORTANT-FOR-ME
  26. Replies
    36
    Views
    807

    Re: .txt files

    You can read the text file in an array and sort the the array.

    You can use ADO:
    http://www.vb-helper.com/howto_ado_load_csv.html

    What is your goal?
  27. Replies
    7
    Views
    274

    Re: MOD operator problems

    That's the problem with floating point number respresentation, calculation and the internal storage in 64 bits.


    ? 7 * 8333.33 - 58333.31
    1.81898940354586E-12
  28. Replies
    7
    Views
    274

    Re: MOD operator problems

    https://stackoverflow.com/questions/9505513/floating-point-modulo-operation


    The algorithm you want, to limit a floating point value between 0 and some modulus n:

    Double fmod(Double value,...
  29. Replies
    7
    Views
    274

    Re: MOD operator problems

    a=58333,31 b=8333,33
    Fix(a / b) -> 6
    b * 6 -> 49999,98
    a - (49999,98) -> 8333,33


    What's your actual question?
  30. Re: In a very large project, how to deal with thousands of interface classes?

    But in real life you would only include the libraries you need.
    Not one big huge library which contains all you will ever need, at least what you can think of right now.

    You would have a math...
  31. Re: Does anyone want to help me with my project

    Oh, it doesn't work for me because I'm not going to install the ShockWave player on my computer.

    But you shouldn't save the data in C:\, use the TEMP directory for it. You can get the location...
  32. Re: Does anyone want to help me with my project

    What is your question, aside from asking for help :-)
  33. Re: how to Draw rounded rectangle by vb6 GDI++?Draw a triangle

    Why not use a polygon?
  34. Re: In a very large project, how to deal with thousands of interface classes?

    Thousands of classes and interfaces?
    What kind of project is this?

    I would normally put classes which are related in a single DLL and in the main project only reference whatís needed.
    Why do you...
  35. Replies
    10
    Views
    279

    Re: [RESOLVED] MxFlexgrid cellbackcolor BLACK

    No, CellForeColor behaves the same, when set to 0 it uses the .ForeColor value


    Option Explicit

    Private Sub Form_Load()
    With MSFlexGrid1
    .Cols = 2
    .Rows = 2
    .TextMatrix(1, 1)...
  36. Replies
    10
    Views
    279

    Re: MxFlexgrid cellbackcolor BLACK

    I think the .CellBackColor = 0 by default, meaning using the .BackColor value
  37. Replies
    10
    Views
    279

    Re: MxFlexgrid cellbackcolor BLACK

    vbBlack or 0 never worked, you have to fake it using RGB(1, 1, 1) like you already did.
    As if the value 0 is meant as "not set at all"
  38. Replies
    15
    Views
    639

    Re: Distibute an EXE without OCX issues

    I have the same.
    I have created a setup package (MSI) for only the OCX and DLLs.
    The (updates of the) application is delivered as a ZIP archive and can be placed wherever the customers like.

    ...
  39. Replies
    40
    Views
    1,174

    Re: Very complicated but perhaps possible!

    Also outdated??

    Sorry, but I don't have clue why it doesn't work for newbie2

    *edit:
    I just tried it in DB Browser for SQLite Version 3.12.1 and it works fine for me too.

    File -> New...
  40. Replies
    40
    Views
    1,174

    Re: Very complicated but perhaps possible!

    Yes he's using RC5, but maybe an older release which predates the minimum SQLite version
    At least version 5.0.68 is needed:
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width