Search:

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...

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)

You just did.....

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...

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$...

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......

or if it's in Office. There you can assign an Array directly to a List/ComboBox

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...

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?

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...

It could even be SSL-Stuff (different ports)

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

Shouldn't you search for a Folder?

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....

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

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...

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...

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
...

LEFT JOIN instead of INNER JOIN?

Uhmmm....Code?

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

AddItem ws.Name?????

Shouldn't that be ws.Range?

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...

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...

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 |

Have you checked the sub-object „Designer“ if it has a caption-property?

Did you read, what pete wrote?

Aircode


rs.movelast
ReDim MIO_ARRAY(1 To 2*rs.Recordcount)
rs.movefirst
Do While Not rs.eof
'blablablabla

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....

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...

Or check, if the ffmpeg-collection is already installed, and use ffprobe

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.

I'd rather use the KeyUp-Event, since there the entered KeyCode is already part of the content of the Textbox

I'd rather use CDbl instead (safer for "bigger" values), and "#,##0.00" as Format (Note the 0 before the dot)

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,...

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...

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...

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

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...

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...