Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: [RESOLVED] Renaming of overloaded functions from .NET

    We might be all right, and we might be all wrong.
    My point is, that you can overload subs, too, which don't have a return type, and that you can call functions as if they were a sub.

    Bottom line...
  2. Re: Finding OLB, TLB file paths dynamically at runtime ?

    How would that work?
    if it‘s not registered, then a TLB is like any other file (like a something.txt).
    The only approach for not registered TLB‘s to keep them „close“ to the app (e.g. their own...
  3. Re: [RESOLVED] Renaming of overloaded functions from .NET

    Niya,
    i don‘t know C#, but in vb6 we always had the possibility to call a function as if it‘s a sub (and thusly ignoring the return type).
    I‘d hazard a guess that‘s the reason, because a compiler...
  4. Re: [RESOLVED] Renaming of overloaded functions from .NET

    That would be the correct way.
    AFAIK, when determining WHICH overload to call the Return Type (if even existent --> Sub instead of Func) is ignored!
    (But it might differ from language to language)
  5. Re: Finding OLB, TLB file paths dynamically at runtime ?

    If the tlb is registered, you can look it up in the Registry
    You would need the GUID for it though.
    https://docs.microsoft.com/de-de/windows/win32/api/oaidl/nn-oaidl-itypelib?redirectedfrom=MSDN...
  6. Re: Renaming of overloaded functions from .NET

    Don't forget the Order of the ParamTypes.
    Count and Types can be the same for two Overloads, just Order is different

    If first String And second Long and third Double Then NukeMoscow
    ElseIf First...
  7. Re: How to convert this C style UNION in a UDT to VB ?

    Both Members are 4 Bytes long, oInst = unsigned Integer 32-Bit, *lpvarValue = Pointer to Something

    so
    UnionMember As Long
  8. Re: Renaming of overloaded functions from .NET

    Yeah, i know, but i still say: it depends, what the original code (the code to be transpiled) is actually doing, because if it's really just emulating Optional Parameters, it would create redundant...
  9. Re: Renaming of overloaded functions from .NET

    Exactly what i was talking about (Polymorphism).
    In this example the vb6-analogy would be


    Sub DoSomething(p As Variant)
    If TypeOf(p)=vbString
    DoThis
    ElseIf TypeOf(p)=vbInteger...
  10. Re: Renaming of overloaded functions from .NET

    Would have to disagree in this particular case.
    I repeat: It depends what the underlying source-code is doing.

    In your example, all (overloaded) Function-Signatures have in common the Parameter...
  11. Re: Renaming of overloaded functions from .NET

    Only if you translate the .NET-Function-Calls "1 to 1", then yes, but also in regards to Niya's answer:

    What's easier?
    Deciding which of the 8 Functions to explicitely call (depending on the...
  12. Replies
    5
    Views
    206

    Re: help extract link by name

    Why are you reinventing the wheel?
    https://www.vbforums.com/showthread.php?782765-How-to-parse-HTML-and-XML-files-in-VB6
  13. Re: Renaming of overloaded functions from .NET

    Function GetProperty( _
    ByVal name As String, _
    Optional ByVal returnType As Type, _
    Optional ByVal types() As Type, _
    Optional ByVal modifiers() As ParameterModifier, _
    Optional ByVal...
  14. Re: Create an object array with a length of zero (or UBound = -1)

    Checking against UBound = -1 is nonsense, since UBound(array) = -1 is a valid upper Bound for e.g. Dim MyArray(-5 To -1) As SomeType

    An Array with Length=0 IS "Dim MyArray() As SomeType", since...
  15. Replies
    3
    Views
    201

    Re: Annoying Excel 2019 Habit

    Confirmed behaviour in O365
    Never noticed it, since when i'm in the VBA-Editor (ALT+F11) i never hit that combination again
  16. Replies
    6
    Views
    213

    Re: Merge multiple tables into one table

    If you don‘t have it that way in the database, the only way as tg wrote:
    a SELECT UNION ALL
  17. Re: How do you create a command that hides each label on the surface of the form?

    There is no "one thing that hides everything".
    you have to iterate either through
    a) your Control-Array of Labels, setting each Member to invisible
    b) the Control-Collection of the Form containig...
  18. Re: How do you create a command that hides each label on the surface of the form?

    Label.Visible = False
  19. Replies
    5
    Views
    206

    Re: help extract link by name

    *gazing into my crystal ball*
    *the answer is there*
    .
    .
    .
    Huh? My Crystal Ball just had a Blue Screen of Death
    probably meaning it couldn't find an answer, because there is "none" (which even...
  20. Replies
    6
    Views
    213

    Re: Merge multiple tables into one table

    That's what i was talking about.
    I'd even make an own "Manufacturer"-Table, and then point its PrimaryKey to a ForeignKey to this "Monitor"-Table

    Table Manufacturer
    ID (Primary Key)
    Description...
  21. Re: Please I need help sql for two selected Month

    Your point?
    What do you think the result is of my sample query?


    SELECT Blbalbabla FROM SomeTable WHERE ARealDateColumn BETWEEN #2022-04-01# AND #2022-06-30#
    Returns all "Blablablbla" for...
  22. Replies
    6
    Views
    213

    Re: Merge multiple tables into one table

    Add a Column "Manufacturer".....
  23. Replies
    1
    Views
    162

    Re: is it possible to use access in vb.net 2010

    https://stackoverflow.com/questions/4234941/vb-net-2010-to-connect-to-ms-access-database
  24. Re: transfer user-defined data types between apps

    Are both Apps written in VB6?
    1) If yes, you could compile them as ActiveX-EXE's, and reference them to each other. That way you could use Public Objects and their methods
    1b) Write an ActiveX-Dll...
  25. Re: WITH ADO SQL query to substituite comma with ""

    It's an Access-DB
    Now it depends: is OP wanting to execute the SQL from within Access, then he can use Replace within the SQL-Statement,
    If it's from "outside" (e.g. from a VB6-Cllient) then he's...
  26. Re: Please I need help sql for two selected Month

    Why in the name of the holy 8 bits do people always seperate Dates (and Times) into its individual components?

    And name your Database-System!
    SQLite, Access, MySQL?


    SELECT Blbalbabla FROM...
  27. MsOf10 Re: Speed up the copying of data from one worksheet to another

    OK, just looked at it again.
    He examines the value in wsManual.Cells and takes this as the Column(Offset) to place the value in wsKD

    Hmm.....me thinks you could solve this even without VBA, but...
  28. Thread: TwinBasic

    by Zvoni
    Replies
    1,059
    Views
    395,800

    Re: TwinBasic

    Why did i just read "can generate a mayonnaise"......
  29. MsOf10 Re: Speed up the copying of data from one worksheet to another

    Have you thought about using an ADODB-Recordset with your sheet as its source?
    The Query could be like

    rs.Open "SELECT * FROM [Sheet1$C3:Z20]", connection
    Then you could use...
  30. Re: listbox move selected item to listindex 0

    Untested


    Dim tmpStr As String
    Dim Index As Long
    If List9.ListIndex>0 Then
    Index=List9.ListIndex
    tmpStr=List9.List(Index)
    List9.Selected(Index)=False
    List9.RemoveItem Index
  31. Re: listbox move selected item to listindex 0

    And your question is what?
  32. Re: LynxGrid + sqlite : runtime error 13 type mismatch

    Not knowing how LynxGrid works, this confuses the hell out of me:
    Is LynxGrid recognizing vbTab as the Cell-"Delimiter"?
    because for me, that's adding one Item (which is basically a concatenated...
  33. Re: LynxGrid + sqlite : runtime error 13 type mismatch

    I wouldn't be surprised, if the AddItem-Function(!) returns the RowNumber of the Grid where it was added

    Nevermind that an "AddItem" implies adding a Row automatically, and he's doing that three...
  34. Replies
    12
    Views
    377

    Re: GetMonitorInfo API

    IIRC, "As Any" is used when you want to pass a pointer to an API which accepts different types (that pointer points to) for the same function, so you don't have to write (multiple) Aliases for each...
  35. Replies
    7
    Views
    352

    Re: Handling Non-Existent Printer Error

    My money is on Printer not reachable
  36. Replies
    7
    Views
    352

    Re: Handling Non-Existent Printer Error

    Since it is a company network printer, i'd hazard a guess it has a static IP.
    Try to reach the IP-Address before creating the DC?
  37. Re: Get module (or/and) class, but also sub/function names ?

    As a workaround (and i've seen it in use):
    You have a global, dynamic Array of Strings


    'Somewhere "global"
    Public MyStringArray() As String

    in modMain
  38. Replies
    2
    Views
    237

    Re: MULTI find in sql server table

    Yes, SQL is the way to go
    (and this thread to the Database-Forum)
  39. Thread: Counting colors

    by Zvoni
    Replies
    6
    Views
    295

    Re: Counting colors

    Correct.
    I fell for that trap before i found out about DisplayFormat.
    Question: How do you "trigger" the vba-code now?
    I've seen mention to use Worksheet_Change resp. Worksheet_Calculate-Event for...
  40. Thread: Counting colors

    by Zvoni
    Replies
    6
    Views
    295

    Re: Counting colors

    After researching this: The Problem is conditional Formatting.
    You cannot use DisplayFormat in any UDF, only directly in VBA-Code
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width