Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.21 seconds.

  1. Replies
    3
    Views
    121

    Re: Extract from table all row between date

    Wrong Forum. This belongs at Database

    To your Question: Which DBMS?
  2. Replies
    16
    Views
    371

    Re: What's wrong with this oop program.

    At first look:
    There is a reason i dislike "Dim MyArray(101) As Integer"
    A "Dim MyArray(0 To 100) As Integer" is more clear in regards to your requirement.
    Then your test against it is just "If...
  3. Thread: Query db

    by Zvoni
    Replies
    2
    Views
    112

    Re: Query db

    Uhhh.... start learning SQL?


    SELECT
    cod,
    SUM(quantity) As qty
    FROM
    MyTable
    GROUP BY
    cod
  4. Replies
    35
    Views
    715

    Re: Prevent Form_Activate

    IIRC, the Activate-Event fires when a Form gets the Focus (back).
    So as the others said: you need a flag preventing the Code in the Event to run.

    I don't like global variables, so another...
  5. Replies
    10
    Views
    309

    Re: Trying to identify the *.BAS file

    I know why i love the "grep"-Tool on Linux....
    As jdc recommended: "grep" for something static and known (like a Caption of a Form)
  6. Replies
    8
    Views
    691

    Re: Why can't I post?

    You just did.....
  7. Replies
    12
    Views
    464

    Re: SQL Query to eliminate duplicates

    Turn it around!
    Think about it: One "Client" will ever only have one Room.
    But a Room can have one or two (more) clients.

    To me it looks like Room being the Master-Table, and the Client being...
  8. Replies
    7
    Views
    289

    Re: [RESOLVED] SQLite & RC5 iff issue

    There is one small midgen of "optimization" from me (and i'm aware that it's one more instruction):
    Every time i test a String against Length=0 (or content being ""/vbNullstring), i first use Trim$...
  9. Replies
    27
    Views
    59,141

    Re: how to copy a file in vb6

    Nevermind that this is a 12 year old thread.....

    Are you sure the Folder "C:\My documents\HHA" exists?............

    and your variable "sourcefile" is not a string......
  10. Replies
    4
    Views
    290

    Re: FILL COMBOBOX in one shot only

    or if it's in Office. There you can assign an Array directly to a List/ComboBox
  11. Replies
    44
    Views
    3,321

    Re: Any technical reason not to use Call in VB6?

    I know that vb6 is cleaning up after you, but i know from other languages that you have to clean up after yourself.
    For all intents and purposes: Imagine vb6 NOT cleaning up after you, would that...
  12. Replies
    44
    Views
    3,321

    Re: Any technical reason not to use Call in VB6?

    Yes, i know: old thread, but out of curiosity:
    IMO, the above code is going to leak, since i don't have any chance to destroy the new "class1"

    Am i right?
  13. Re: Need help with this complicated query

    Yes, if you have FK-Constraints, you have to delete in reverse Order, since the constraint won't allow a child-record being without a parent.

    The more interesting question: What kind of...
  14. Replies
    30
    Views
    735

    Re: CDO.Message Problem

    It could even be SSL-Stuff (different ports)
  15. Replies
    30
    Views
    735

    Re: CDO.Message Problem

    This one sounds the same:
    https://www.vbforums.com/showthread.php?874421-RESOLVED-Email-setup-(SMTP-port-SSL-etc)-did-it-change-in-Windows-10
  16. Replies
    3
    Views
    171

    Re: Getting the active mailbox

    Shouldn't you search for a Folder?
  17. Re: Monitoring local network performance over time

    Then recommend using wireshark, and then you can stay out of that minefield

    i‘m speaking out of experience.
    One day users complained about a very slow network, they attributed to the ERP we use....
  18. Re: Monitoring local network performance over time

    Well, one, obviously "overkill", way would be to figure out, how to use/access the wireshark libraries (which are Open Source)
  19. Replies
    11
    Views
    330

    Re: SQLite save images in database

    tg,

    btw: Out of curiosity: Do you have any numbers on overhead for db-stored blobs vs. stored as files in a filesystem, and in the db just storing the links/paths?

    Kinda like:
    i have 1000...
  20. Replies
    11
    Views
    330

    Re: SQLite save images in database

    There are pro's and con's to each approach.

    as tg said:
    blobs in db:
    con: it increases the size of your db
    pro: you're not dependent on a folder-tree being in the correct place (As i've often...
  21. Re: Break through the limitations of VB6-Type

    Are you implying that in vb6 you can declare an Enum consisting of strings?
    I was under the impression, that an Enum-Variable is basically a Long


    Public Enum MyEnum
    Member1
    Member2
    ...
  22. Replies
    46
    Views
    1,162

    Re: join three tables to get Sum

    LEFT JOIN instead of INNER JOIN?
  23. Thread: VBA CountIf

    by Zvoni
    Replies
    2
    Views
    232

    Re: VBA CountIf

    Uhmmm....Code?
  24. Re: SQL - Challenge selecting from two tables

    1) INNER JOIN
    2) Table1 LEFT JOIN Table2 with ISNULL on Right Hand side (Table2)
    3) Table2 LEFT JOIN Table1 with ISNULL on Right Hand side (Table1)

    EDIT: Or all three together: FULL OUTER JOIN
  25. Re: Wrong number of arguments or invalid property assignment

    AddItem ws.Name?????

    Shouldn't that be ws.Range?
  26. Replies
    14
    Views
    504

    Re: comma value in csv file

    Not really. At least in my opinion.
    reason: TAB is a non-printable character, and there is always a smart-ass trying to edit such files in a Texteditor, blowing the file to smitherens, just because...
  27. Replies
    20
    Views
    586

    Re: Need help with this query

    He only compares Item_ID
    If he compares PID too, then he will get his result


    StrSql = "Select * from Item_Tbl " & _
    " inner join Tbl_Debt on Item_Tbl. ID = Tbl_Debt .Item.Id " & _
    " inner...
  28. Replies
    14
    Views
    504

    Re: comma value in csv file

    Export each field with quotation marks
    Downside: Every Field in the CSV is a String

    EDIT: Easy solution: Don't use comma as field-delimiter. In such cases i use the pipe-symbol |
  29. Replies
    11
    Views
    512

    Re: How to call a certain vba Form from vb6 ?

    Have you checked the sub-object „Designer“ if it has a caption-property?
  30. Replies
    11
    Views
    512

    Re: How to call a certain vba Form from vb6 ?

    Did you read, what pete wrote?
  31. Replies
    6
    Views
    376

    Re: FILL ARRAY problem

    Aircode


    rs.movelast
    ReDim MIO_ARRAY(1 To 2*rs.Recordcount)
    rs.movefirst
    Do While Not rs.eof
    'blablablabla
  32. Replies
    5
    Views
    379

    Re: Data base show patern

    tg,
    he could even go with a detail-table in „1:n“-relation
    master-table are the movies itself (name, description, year, etc.) and the detail-table would have the (links to) the movie-files incl....
  33. Replies
    5
    Views
    379

    Re: Data base show patern

    If you know a Movie is 3 Disks long, und your Movie Files are named properly, e.g. "Movie-Disk.1.mp4", "Movie-Disk.2.mp4", "Movie-Disk.3.mp4",
    i'd rather look for a "Playlist"-Feature/Property of...
  34. Replies
    20
    Views
    767

    Re: Help converting code

    Or check, if the ffmpeg-collection is already installed, and use ffprobe
  35. Replies
    20
    Views
    767

    Re: Help converting code

    As 3rd-Party, i'd recommend ffprobe.exe from the ffmpeg-collection.
    No idea about shelling it "silently" (a.k.a. no "DOS"-Window), or piping the output.
  36. Replies
    5
    Views
    250

    Re: When enter is not Enter

    I'd rather use the KeyUp-Event, since there the entered KeyCode is already part of the content of the Textbox
  37. Replies
    7
    Views
    253

    Re: Summation of Currency issue

    I'd rather use CDbl instead (safer for "bigger" values), and "#,##0.00" as Format (Note the 0 before the dot)
  38. Re: return information from form to calling macro

    Pete, correct, that's one of the "obvious" ways,
    but that would be the child updating the parent, which is considered "bad practice"

    And i did say "hiding" the form, not closing/unloading.
    IMO,...
  39. Replies
    15
    Views
    509

    Re: Listview truncating texts

    Have you tried different sorting? As in the item with the longest Text being the first item?
    And i don't mean throwing everything into the ListView and then setting sorted to true.
    I mean leaving...
  40. Re: return information from form to calling macro

    You don't. You can only pass a value back to the calling macro, the moment control is back to the calling macro.
    As jdc said: Declare a Public Variable in your Form-code, assign the keycode (or...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width