Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    35
    Views
    532

    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...
  2. Replies
    10
    Views
    228

    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)
  3. Replies
    8
    Views
    646

    Re: Why can't I post?

    You just did.....
  4. Replies
    12
    Views
    304

    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...
  5. Replies
    7
    Views
    255

    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$...
  6. Replies
    26
    Views
    58,928

    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......
  7. Replies
    4
    Views
    267

    Re: FILL COMBOBOX in one shot only

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

    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...
  9. Replies
    44
    Views
    3,246

    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?
  10. 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...
  11. Replies
    27
    Views
    613

    Re: CDO.Message Problem

    It could even be SSL-Stuff (different ports)
  12. Replies
    27
    Views
    613

    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
  13. Replies
    3
    Views
    144

    Re: Getting the active mailbox

    Shouldn't you search for a Folder?
  14. 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....
  15. 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)
  16. Replies
    11
    Views
    303

    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...
  17. Replies
    11
    Views
    303

    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...
  18. 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
    ...
  19. Replies
    46
    Views
    1,114

    Re: join three tables to get Sum

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

    by Zvoni
    Replies
    2
    Views
    210

    Re: VBA CountIf

    Uhmmm....Code?
  21. 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
  22. Re: Wrong number of arguments or invalid property assignment

    AddItem ws.Name?????

    Shouldn't that be ws.Range?
  23. Replies
    14
    Views
    488

    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...
  24. Replies
    20
    Views
    554

    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...
  25. Replies
    14
    Views
    488

    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 |
  26. Replies
    11
    Views
    477

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

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

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

    Did you read, what pete wrote?
  28. Replies
    6
    Views
    358

    Re: FILL ARRAY problem

    Aircode


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

    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....
  30. Replies
    5
    Views
    358

    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...
  31. Replies
    20
    Views
    744

    Re: Help converting code

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

    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.
  33. Replies
    5
    Views
    226

    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
  34. Replies
    7
    Views
    239

    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)
  35. 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,...
  36. Replies
    15
    Views
    498

    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...
  37. 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...
  38. Replies
    20
    Views
    744

    Re: Help converting code

    According to the Link in the first post, it's basically reading the StreamInfo-Metadata, and Duration boils down to "total_samples / Sample-Rate"
  39. Replies
    26
    Views
    991

    Re: Ethics and choice

    tg, thank you.

    Nevermind, that the "classic" Desktop-App is basically dead in such a scenario (let's call it "network-based ERP")
    Why?
    Each client-workstation has to be setup with the client-app...
  40. Replies
    26
    Views
    991

    Re: Ethics and choice

    Agree on the incorrect usage of descriptions.

    Neverthless, it doesn't change the fact, that nowadays it is the correct term.
    Point in case: An Intranet (like in the company i work for).
    We use a...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width